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();
}
}
}
}