public virtual void Delete(TEntity entityToDelete) { if (context.Entry(entityToDelete).State == EntityState.Detached) { dbSet.Attach(entityToDelete); } dbSet.Remove(entityToDelete); }
public void UpdateRole(VSEC_ROLE_MST vsec_role_mst) { try { if (vsec_role_mst != null) { VSEC_ROLE_MST obj = new VSEC_ROLE_MST { RoleId = vsec_role_mst.RoleId, RoleSName = vsec_role_mst.RoleSName, DisplayName = vsec_role_mst.DisplayName, ActiveFlag = vsec_role_mst.Status == "A" ? "Y" : "N", Status = vsec_role_mst.Status, MC_Status = vsec_role_mst.Status, CreatedBy = vsec_role_mst.CreatedBy, CreatedOn = DateTime.Now, LastUpDtBy = vsec_role_mst.CreatedBy, LastUpDtOn = DateTime.Now }; _db.VSEC_ROLE_MST.Attach(obj); _db.Entry(obj).State = EntityState.Modified; _db.SaveChanges(); } } catch (Exception e) { throw; } }
public void UpdateProfile(VSEC_PROFILE_MST vsec_profile_mst) { try { if (vsec_profile_mst != null) { VSEC_PROFILE_MST obj = new VSEC_PROFILE_MST { ProfileID = vsec_profile_mst.ProfileID, ProfileName = vsec_profile_mst.ProfileName, PwdExpDays = vsec_profile_mst.PwdExpDays, PwdRetryCount = vsec_profile_mst.PwdRetryCount, PwdGracePeriod = vsec_profile_mst.PwdGracePeriod, Status = "A", MC_Status = "A", CreatedBy = vsec_profile_mst.CreatedBy, CreatedOn = DateTime.Now, LastUpDtBy = vsec_profile_mst.CreatedBy, LastUpDtOn = DateTime.Now }; _db.VSEC_PROFILE_MST.Attach(obj); _db.Entry(obj).State = EntityState.Modified; _db.SaveChanges(); } } catch (Exception e) { throw; } }
public void UpdateUser(VW_UserDetail vw_userdetail) { if (vw_userdetail != null) { VSEC_USER_MST vsec_user_mst = new VSEC_USER_MST { UserMstID = vw_userdetail.UserMstID, FirstName = vw_userdetail.FirstName, MiddleName = vw_userdetail.MiddleName, LastName = vw_userdetail.LastName, FatherName = vw_userdetail.FatherName, DOB = vw_userdetail.DOB, Gender = vw_userdetail.Gender, Email = vw_userdetail.Email, Address1 = vw_userdetail.Address1, Address2 = vw_userdetail.Address2, Address3 = vw_userdetail.Address3, ContactNo = vw_userdetail.ContactNo, Status = vw_userdetail.Status == "true" ? "A" : "D", MC_Status = vw_userdetail.Status == "true" ? "A" : "D", CreatedBy = vw_userdetail.CreatedBy, CreatedOn = DateTime.Now, UpdatedBy = vw_userdetail.CreatedBy, UpdatedOn = DateTime.Now, P1 = vw_userdetail.P1 }; VSEC_LOGIN_MST vsec_login_mst = new VSEC_LOGIN_MST { LoginMId = vw_userdetail.LoginMId, LoginID = vw_userdetail.LoginID, ProfileId = vw_userdetail.ProfileId, ActiveStatus = vw_userdetail.Status == "true" ? "Y" : "N", Password = vw_userdetail.RPassword, CreatedBy = vw_userdetail.CreatedBy, CreatedOn = DateTime.Now, UpdatedBy = vw_userdetail.CreatedBy, UpdatedOn = DateTime.Now }; _db.VSEC_USER_MST.Attach(vsec_user_mst); _db.Entry(vsec_user_mst).State = EntityState.Modified; using (System.Data.Entity.DbContextTransaction dbTran = _db.Database.BeginTransaction()) { try { _db.SaveChanges(); vsec_login_mst.UserMstID = vw_userdetail.UserMstID; _db.VSEC_LOGIN_MST.Attach(vsec_login_mst); _db.Entry(vsec_login_mst).State = EntityState.Modified; _db.SaveChanges(); dbTran.Commit(); } catch (System.Data.Entity.Validation.DbEntityValidationException e) { dbTran.Rollback(); } } } }