public void UseConfirmDataToAdd(MSIT116APEXEntities db, IEnumerable <uRolePowerConfirmHistoryConfirmDataDetail> urpchcdds, T _entity) { db.Entry(_entity).State = EntityState.Added; DbEntityEntry <T> entry = db.Entry(_entity); foreach (var property in entry.CurrentValues.PropertyNames) { //var current = entry.CurrentValues.GetValue<object>(property); //if (current == null) // entry.Property(property).IsModified = false; foreach (var urpchcdd in urpchcdds) { if (urpchcdd.cColumnName == property) { entry.Property(property).CurrentValue = Convert.ChangeType(urpchcdd.cColumnValue, Type.GetType(urpchcdd.cColumnType)); urpchcdd.state = 1; } } } try { db.SaveChanges(); } catch (Exception ex) { throw; } }
public void UseConfirmDataToUpdate(MSIT116APEXEntities db, IEnumerable <uRolePowerConfirmHistoryConfirmDataDetail> urpchcdds, T _entity) { db.Entry(_entity).State = EntityState.Modified; DbEntityEntry <T> entry = db.Entry(_entity); foreach (var property in entry.CurrentValues.PropertyNames) { //var current = entry.CurrentValues.GetValue<object>(property); //if (current == null) // entry.Property(property).IsModified = false; foreach (var urpchcdd in urpchcdds) { if (urpchcdd.cColumnName == property) { if (urpchcdd.cColumnType == "Byte[]") { string[] ptmps = urpchcdd.cColumnValue.Remove(urpchcdd.cColumnValue.Length - 1, 1).Split(','); byte[] pbtmp = new byte[ptmps.Length]; for (int i = 0; i < ptmps.Length; i++) { pbtmp[i] = Convert.ToByte(ptmps[i]); } entry.Property(property).CurrentValue = pbtmp; } else { entry.Property(property).CurrentValue = Convert.ChangeType(urpchcdd.cColumnValue, Type.GetType(urpchcdd.cColumnType)); } urpchcdd.state = 1; } } } try { db.SaveChanges(); } catch (Exception ex) { throw; } }
//MSIT116APEXEntities db = new MSIT116APEXEntities(); public void ExecConfirmAction(MSIT116APEXEntities db, uRolePowerConfirmHistoryConfirmData urpchcd, T _entity) { IEnumerable <uRolePowerConfirmHistoryConfirmDataDetail> urpchcdds = db.uRolePowerConfirmHistoryConfirmDataDetail.Where(n => n.uRolePowerConfirmHistoryConfirmDataSn == urpchcd.urpchcdSn).ToList(); if (urpchcd.execAction == SaveExecConfirmDataModelActionEnum.Create.ToString()) { UseConfirmDataToAdd(db, urpchcdds, _entity); } if (urpchcd.execAction == SaveExecConfirmDataModelActionEnum.Remove.ToString()) { db.Entry(_entity).State = EntityState.Deleted; urpchcd.state = 1; foreach (var urpchcdd in urpchcdds) { urpchcdd.state = 1; } db.SaveChanges(); } if (urpchcd.execAction == SaveExecConfirmDataModelActionEnum.Update.ToString()) { UseConfirmDataToUpdate(db, urpchcdds, _entity); } }
public AccountMethod() { dbUser = new Repository <AspNetUsers>(); db = new MSIT116APEXEntities(); }
public Repository() { db = new MSIT116APEXEntities(); dbSet = db.Set <T>(); }