public void CreatRole(VSEC_ROLE_MST vsec_role_mst) { try { if (vsec_role_mst != null) { VSEC_ROLE_MST obj = new VSEC_ROLE_MST { RoleId = 0, RoleSName = vsec_role_mst.RoleSName, DisplayName = vsec_role_mst.DisplayName, ActiveFlag = "Y", Status = "A", MC_Status = "A", CreatedBy = vsec_role_mst.CreatedBy, CreatedOn = DateTime.Now }; _db.VSEC_ROLE_MST.Add(obj); _db.SaveChanges(); } } catch (Exception e) { throw; } }
public void CreateProfile(VSEC_PROFILE_MST vsec_profile_mst) { try { if (vsec_profile_mst != null) { VSEC_PROFILE_MST obj = new VSEC_PROFILE_MST { ProfileID = 0, ProfileName = vsec_profile_mst.ProfileName, PwdExpDays = vsec_profile_mst.PwdExpDays, PwdRetryCount = vsec_profile_mst.PwdRetryCount, PwdGracePeriod = vsec_profile_mst.PwdGracePeriod, NoofSessions = vsec_profile_mst.NoofSessions, Status = "A", MC_Status = "A", CreatedBy = vsec_profile_mst.CreatedBy, CreatedOn = DateTime.Now }; _db.VSEC_PROFILE_MST.Add(obj); _db.SaveChanges(); } } catch (Exception e) { throw; } }
public void CreatUser(VW_UserDetail vw_userdetail) { try { if (vw_userdetail != null) { VSEC_USER_MST vsec_user_mst = new VSEC_USER_MST { UserMstID = _db.VSEC_USER_MST.Max(m => m.UserMstID) + 1, 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, P1 = vw_userdetail.P1 }; VSEC_LOGIN_MST vsec_login_mst = new VSEC_LOGIN_MST { LoginMId = 0, 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 }; _db.VSEC_USER_MST.Add(vsec_user_mst); using (System.Data.Entity.DbContextTransaction dbTran = _db.Database.BeginTransaction()) { try { _db.SaveChanges(); vsec_login_mst.UserMstID = _db.VSEC_USER_MST.Max(m => m.UserMstID); _db.VSEC_LOGIN_MST.Add(vsec_login_mst); _db.SaveChanges(); dbTran.Commit(); } catch (System.Data.Entity.Validation.DbEntityValidationException e) { dbTran.Rollback(); } } } } catch (Exception e) { throw; } }
public void Save() { context.SaveChanges(); }