#LoadModule php5_module "c:/php-5/php5apache2_2.dll"
#AddHandler application/x-httpd-php .php
#PHPIniDir "C:/php-5"
LoadModule fcgid_module modules/mod_fcgid.so
FcgidInitialEnv PHPRC "c:/php-5"
AddHandler fcgid-script .php
FcgidWrapper "c:/php-5/php-cgi.exe" .php
And, to avoid HTTP 403 errors, don't forget ExecCGI in your directory configuration.
By the way, mod_fcgid.so can be found here (http://mir2.ovh.net/ftp.apache.org/dist//httpd/binaries/win32/)Options Indexes FollowSymLinks ExecCGI #...
//the default value for datetime properties
public DateTime DefaultDate { get; set; }
public override int SaveChanges() {
Boolean defaultSet = false;
//seeking only pertinent entities
foreach (DbEntityEntry dbee in ChangeTracker.Entries().
Where(x => x.State != EntityState.Deleted && x.State != EntityState.Detached ) ) {
defaultSet = false;
Object o = dbee.Entity;
Type t = o.GetType();
foreach ( MemberInfo m in t.GetProperties() ) {
PropertyInfo p = t.GetProperty(m.Name);
switch (Type.GetTypeCode(p.PropertyType)) {
case TypeCode.String:
if (p.GetValue(o, null) == null) {
p.SetValue(o, String.Empty, null);
defaultSet = true;
}
break;
case TypeCode.DateTime:
if ((DateTime)p.GetValue(o, null) == DateTime.MinValue) {
p.SetValue(o, DefaultDate, null);
defaultSet = true;
}
break;
}
//update the state if needed
if ( defaultSet ) {
switch ( dbee.State ) {
case EntityState.Unchanged :
dbee.State = EntityState.Modified;
break;
}
}
}
}
return base.SaveChanges();
}
This could be used to implement business rules, such as LastModificationDate.using System;
using System.Linq;
using System.Data.Entity;
using System.Collections.Generic;
using System.Data.Entity.ModelConfiguration;
using System.Reflection;
using System.Data.Entity.Infrastructure;
namespace testef {
public class Order {
public Int32 Id { get; set; }
public String Title { get; set; }
public virtual ICollection Details { get; set; }
public DateTime OrderDate { get; set; }
public virtual OrderType Type { get; set; }
}
public class OrderType {
public String Code { get; set; }
public String Description { get; set; }
}
public class OrderDetail {
public virtual Order Order { get; set; }
public Int32 Id { get; set; }
public String D { get; set; }
public Boolean IsActive { get; set; }
}
public class OrderDetailConfiguration : EntityTypeConfiguration {
public OrderDetailConfiguration()
: base() {
HasRequired(d => d.Order).WithMany(o => o.Details);
}
}
public class OrderConfiguration : EntityTypeConfiguration {
public OrderConfiguration()
: base() {
HasRequired(d => d.Type).WithMany();
}
}
public class OrderTypeConfiguration : EntityTypeConfiguration {
public OrderTypeConfiguration()
: base() {
Property(x => x.Code).HasColumnType("varchar").HasMaxLength(10);
HasKey(x => x.Code);
}
}
public class TestEFContext : DbContext {
public DbSet Orders { get; set; }
public DbSet Details { get; set; }
public TestEFContext(String cs)
: base(cs) {
Database.SetInitializer(new DropCreateDatabaseAlways());
//Database.SetInitializer(null);
//Database.SetInitializer(new CreateDatabaseIfNotExists());
//Database.SetInitializer(new CustomDataBaseInitializer());
}
protected override void OnModelCreating(DbModelBuilder modelBuilder) {
}
public DateTime DefaultDate { get; set; }
public override int SaveChanges() {
Boolean defaultSet = false;
foreach (DbEntityEntry dbee in ChangeTracker.Entries().
Where(x => x.State != EntityState.Deleted && x.State != EntityState.Detached ) ) {
defaultSet = false;
Object o = dbee.Entity;
Type t = o.GetType();
foreach ( MemberInfo m in t.GetProperties() ) {
PropertyInfo p = t.GetProperty(m.Name);
switch (Type.GetTypeCode(p.PropertyType)) {
case TypeCode.String:
if (p.GetValue(o, null) == null) {
p.SetValue(o, String.Empty, null);
defaultSet = true;
}
break;
case TypeCode.DateTime:
if ((DateTime)p.GetValue(o, null) == DateTime.MinValue) {
p.SetValue(o, DefaultDate, null);
defaultSet = true;
}
break;
}
if ( defaultSet ) {
switch ( dbee.State ) {
case EntityState.Unchanged :
dbee.State = EntityState.Modified;
break;
}
}
}
}
return base.SaveChanges();
}
}
public class CustomDataBaseInitializer : CreateDatabaseIfNotExists {
public CustomDataBaseInitializer()
: base() {
}
}
class Program {
static void Main(string[] args) {
String cs = @"Data Source=ALIASTVALK;Initial Catalog=TestEF;Integrated Security=True; MultipleActiveResultSets=True";
using (TestEFContext ctx = new TestEFContext(cs)) {
ctx.DefaultDate = new DateTime(2000, 1, 1);
OrderType t = new OrderType {
Code = "T1",
Description = "type One"
};
ctx.Orders.Add(new Order {
Title = "first order",
Type = t
});
ctx.SaveChanges();
}
using (TestEFContext ctx = new TestEFContext(cs)) {
Order o = ctx.Orders.First();
Console.WriteLine(o.OrderDate);
}
}
}
}
<w:document>
<w:body>
<w:p>
<w:pPr>
<w:numPr>
<w:ilvl>X</w:ilvl>
<w:numId val="Y" />
//word/numbering.xml
<w:numbering>
<w:num w:numId="Y">
<w:abstractNumId w:val="Z" />
//word/numbering.xml
<w:numbering>
<w:abstractNum w:abstractNumId="Z" >
<w:lvl w:ilvl="X">
...
</w:lvl>
<w:num w:numId="Y">
<w:abstractNumId w:val="Z" />
private void tbFilter_TextChanged(object sender, EventArgs e) {
CurrencyManager cm = (CurrencyManager)BindingContext[dgvList.DataSource];
cm.SuspendBinding();
foreach (DataGridViewRow r in dgvList.Rows) {
r.Visible = String.IsNullOrEmpty(tbFilter.Text) || r.Cells[1].Value.ToString().Contains(tbFilter.Text);
}
cm.ResumeBinding();
}
Here the difficulty is the use of a CurrencyManager.
This article is about how to use Int32 as a key for users in asp.net identity.
First the model. As I seed it, you can also see how to instanciate the UserManage.
For this thank you to SymbolSource and to Microsoft of course!
namespace cclw4c.Models
{
// You can add profile data for the user by adding more properties to your ApplicationUser class, please visit http://go.microsoft.com/fwlink/?LinkID=317594 to learn more.
public class ApplicationUser : IdentityUser <Int32, CustomUserLogin, CustomUserRole, CustomUserClaim>: {
}
public class CustomRole : IdentityRole<Int32, CustomUserRole> {
public CustomRole() { }
public CustomRole(String name) { Name = name; }
}
public class CustomUserRole : IdentityUserRole<Int32> { }
public class CustomUserClaim : IdentityUserClaim<Int32> { }
public class CustomUserLogin : IdentityUserLogin<Int32> { }
public class ApplicationUserDbContext : IdentityDbContext<ApplicationUser, CustomRole, Int32, CustomUserLogin, CustomUserRole, CustomUserClaim>
{
public ApplicationUserDbContext()
: base("ApplicationUser")
{
Database.SetInitializer<ApplicationUserDbContext>(new CreateDatabaseIfNotExistsWithSeedData());
}
}
public class CreateDatabaseIfNotExistsWithSeedData : CreateDatabaseIfNotExists<ApplicationUserDbContext> {
protected override void Seed(ApplicationUserDbContext context) {
base.Seed(context);
var user = new ApplicationUser() { UserName = "root" };
UserManager<ApplicationUser, Int32> am =
new UserManager<ApplicationUser, Int32>(new UserStore<ApplicationUser, CustomRole, Int32, CustomUserLogin, CustomUserRole, CustomUserClaim>(context));
IdentityResult ir = am.Create(user, "******");
if (ir.Succeeded) {
RoleManager<CustomRole, Int32> rm = new RoleManager<CustomRole, Int32>(new RoleStore<CustomRole, Int32, CustomUserRole>(context));
rm.Create(new CustomRole("Root"));
am.AddToRole(user.Id, "Root");
}
}
}
}
Second use Int32.Parse(User.Identity.GetUserId()every where it is needed.
new UserManager<ApplicationUser, Int32>(new UserStore<
ApplicationUser,
CustomRole,
Int32,
CustomUserLogin,
CustomUserRole,
CustomUserClaim
>(context));