public List <StartAdmissionModel> UpdateStartAdmissionList(List <StartAdmissionModel> startAdmissionModels) { try { using (GEEDbContext context = new GEEDbContext()) { foreach (var item in startAdmissionModels) { AdmissionStatu admissionStatus = context.AdmissionStatus.Where(a => a.AdmissionStatus_id == item.AdmissionStatus_id).FirstOrDefault(); if (admissionStatus != null) { admissionStatus.AdmissionCode = item.AdmissionCode; admissionStatus.AdmissionStatus = item.AdmissionStatus; admissionStatus.Startdate = item.Startdate; admissionStatus.FromDOB = item.FromDOB; admissionStatus.TODOB = item.TODOB; admissionStatus.ApplicaitonFees = item.ApplicaitonFees; admissionStatus.RegistrationFees = item.RegistrationFees; context.Entry(admissionStatus).State = EntityState.Modified; context.SaveChanges(); } } } return(null); } catch (Exception ex) { throw; } }
/// <summary> /// This is for Update Application no and IsSubmited Prop /// </summary> /// <param name="entity"></param> /// <returns></returns> public ApplicationModel UpdateApplicationNo(ApplicationModel entity) { using (GEEDbContext context = new GEEDbContext()) { Application application = context.Applications.Where(a => a.Enquiry_ID == entity.Enquiry_ID).FirstOrDefault(); if (application != null) { //If isSubmitted false if (!entity.IsSubmitted) { application.ApplicaitonNo = entity.ApplicaitonNo; application.ApplicationSoldDate = DateTime.Now; } else { application.IsSubmitted = entity.IsSubmitted; application.SubmitDate = DateTime.Now; } context.Entry(application).State = EntityState.Modified; context.SaveChanges(); } } return(new ApplicationModel { Application_ID = entity.Application_ID }); }
/// <summary> /// This methoda is used for update is deleted column /// Added by Jiya /// addedWehn 28 July 2019 /// </summary> /// <param name="entity"></param> /// <returns></returns> public int DeleteEmployeeDetails(EmployeeMasterModel entity) { GEEDbContext objGEEDbContext = new GEEDbContext(); var EmployeeData = objGEEDbContext.EmployeeMasters.Where(a => a.EmployeeMasterID == entity.EmployeeMasterID).SingleOrDefault(); EmployeeData.Modifiedby_ID = entity.ModifiedBy_ID; EmployeeData.ModifiedDate = DateTime.Now; EmployeeData.IsDeleted = true; objGEEDbContext.Entry(EmployeeData).State = System.Data.Entity.EntityState.Modified; return(objGEEDbContext.SaveChanges()); }
public Enquiry Save(Enquiry enquiry) { try { _context.Enquiries.Add(enquiry); _context.SaveChanges(); return(enquiry); } catch { return(null); } }
/// <summary> /// This is for Update Registration no and IsSubmitedDate Prop /// </summary> /// <param name="entity"></param> /// <returns></returns> public RegistrationModel UpdateRegistrationNo(RegistrationModel entity) { using (GEEDbContext context = new GEEDbContext()) { Registration registration = context.Registrations.Where(a => a.Enquiry_ID == entity.Enquiry_ID).FirstOrDefault(); if (registration != null) { registration.RegistrationNo = entity.RegistrationNo; registration.IsSubmitedDate = DateTime.Now; } context.Entry(registration).State = EntityState.Modified; context.SaveChanges(); return(new RegistrationModel { Registration_ID = entity.Registration_ID }); } }
/// <summary> /// Delete /// </summary> /// <param name="id"></param> /// <returns></returns> public bool DeActivate(int id) { bool isDelete = false; try { GEEDbContext objGEEDbContext = new GEEDbContext(); var UserData = objGEEDbContext.AssessmentStructureAssessmentTypeMappings.Where(a => a.AssessmentStructureAssessmentTypeMapping_Id == id).FirstOrDefault(); UserData.IsDeleted = true; objGEEDbContext.Entry(UserData).State = System.Data.Entity.EntityState.Modified; //objGEEDbContext.Entry(UserData).Property(x => x.CUserId).IsModified = false; if (objGEEDbContext.SaveChanges() > 0) { isDelete = true; } } catch (Exception) { isDelete = false; } return(isDelete); }
/// <summary> /// Delete /// </summary> /// <param name="id"></param> /// <returns></returns> public bool DeActivateCourse(int id) { bool isDelete = false; try { GEEDbContext objGEEDbContext = new GEEDbContext(); var _Data = objGEEDbContext.CourseMasters.Where(a => a.CourseMaster_ID == id).FirstOrDefault(); _Data.IsDeleted = true; objGEEDbContext.Entry(_Data).State = System.Data.Entity.EntityState.Modified; //objGEEDbContext.Entry(UserData).Property(x => x.CUserId).IsModified = false; if (objGEEDbContext.SaveChanges() > 0) { isDelete = true; } } catch (Exception) { isDelete = false; } return(isDelete); }
public AspNetUserModel Update(AspNetUserModel entity) { int cuid = Convert.ToInt32(entity.CUserId); GEEDbContext objGEEDbContext = new GEEDbContext(); var UserData = objGEEDbContext.AspNetUsers.Where(a => a.CUserId == cuid).FirstOrDefault(); UserData.Email = entity.Email; UserData.PasswordHash = entity.PasswordHash; UserData.PhoneNumber = entity.PhoneNumber; UserData.UserName = entity.UserName; UserData.FirstName = entity.FirstName; UserData.LastName = entity.LastName; UserData.UserGroupId = entity.UserGroupId; UserData.StuStaffTypeId = entity.StuStaffTypeId; objGEEDbContext.Entry(UserData).State = System.Data.Entity.EntityState.Modified; objGEEDbContext.Entry(UserData).Property(x => x.CUserId).IsModified = false; int i = objGEEDbContext.SaveChanges(); return(new Model.Admin.AspNetUserModel { CUserId = i }); }
public RoomModel Update(RoomModel entity) { ///Updated by jiya 10--Aug-2019 ///Cause: Code breaking while data not available. GEEDbContext objGEEDbContext = new GEEDbContext(); var roomMaster = objGEEDbContext.RoomMasters.Where(a => a.RoomMaster_ID == entity.RoomMaster_ID).FirstOrDefault(); roomMaster.Building_ID = entity.Building_ID; roomMaster.Modifiedby_ID = Convert.ToInt32(entity.ModifiedBy_ID); roomMaster.ModifiedDate = DateTime.Now; roomMaster.Name = entity.Name; roomMaster.Code = entity.Code; roomMaster.SeatingCapicity = entity.SeatingCapicity; roomMaster.Remarks = entity.Remarks; roomMaster.GeoCoordinates = entity.GeoCoordinates; objGEEDbContext.Entry(roomMaster).State = System.Data.Entity.EntityState.Modified; objGEEDbContext.SaveChanges(); return(new RoomModel { RoomMaster_ID = roomMaster.RoomMaster_ID }); }
/// <summary> /// This method is used to save the data for user group permission. /// </summary> /// <param name="entity"></param> /// <returns></returns> public int Save(PermissionParentModel entity) { int isSave = 0; GEEDbContext objGEEDbContext = new GEEDbContext(); int menuid = 0; foreach (var item in entity.PermissionChildModelList) { Navmenu_asprole_permisison_UserGroup_mapping objPermission = new Navmenu_asprole_permisison_UserGroup_mapping(); var _pMapping = objGEEDbContext.Navmenu_asprole_permisison_UserGroup_mapping.Where(a => a.Navrolepermisisonmapping_ID == item.Navrolepermisisonmapping_ID && a.UserGroup_ID == entity.Group_Id).SingleOrDefault(); if (_pMapping != null) { bool isPermisssion = item.IsPermission == 1 ? false : true; if (_pMapping.ISDeleted != isPermisssion) { _pMapping.ISDeleted = item.IsPermission == 1 ? false : true; _pMapping.AcitiveEdit = true;//This flag is for user role maaping procedure. _pMapping.ModifiedBy_ID = entity.CreatedBy_ID; entity.ModifiedDate = DateTime.Now; objGEEDbContext.Entry(_pMapping).State = System.Data.Entity.EntityState.Modified; isSave = objGEEDbContext.SaveChanges(); } } else { objPermission.Navrolepermisisonmapping_ID = item.Navrolepermisisonmapping_ID; objPermission.SchoolID = entity.SchoolID; objPermission.CreatedDate = DateTime.Now; objPermission.ISDeleted = item.IsPermission == 1 ? false : true; objPermission.UserGroup_ID = entity.Group_Id; objPermission.CreatedBy_ID = entity.CreatedBy_ID; objPermission.AcitiveEdit = true;//This flag is for user role maaping procedure. objGEEDbContext.Navmenu_asprole_permisison_UserGroup_mapping.Add(objPermission); isSave = objGEEDbContext.SaveChanges(); } if (menuid != item.NavigationMenu_Id) { menuid = item.NavigationMenu_Id; var data = entity.PermissionChildModelList.Where(a => a.NavigationMenu_Id == menuid & a.IsPermission == 1).ToList(); UserGroupNavigationMenuMapping objUserGroupNavigationMenuMapping = new UserGroupNavigationMenuMapping(); var checkDataExists = objGEEDbContext.UserGroupNavigationMenuMappings.Where(a => a.NavigationMenuId == menuid && a.UserGroupId == entity.Group_Id).SingleOrDefault(); if (checkDataExists != null) { checkDataExists.UserGroupId = entity.Group_Id; checkDataExists.NavigationMenuId = menuid; checkDataExists.SchoolID = entity.SchoolID; checkDataExists.GroupID = entity.GroupID; if (data.Count > 0) { checkDataExists.ISDeleted = false; } else { checkDataExists.ISDeleted = true; } checkDataExists.ModifiedBy_ID = entity.CreatedBy_ID; checkDataExists.ModifiedDate = DateTime.Now; objGEEDbContext.Entry(checkDataExists).State = System.Data.Entity.EntityState.Modified; isSave = objGEEDbContext.SaveChanges(); } else { if (data.Count > 0) { objUserGroupNavigationMenuMapping.UserGroupId = entity.Group_Id; objUserGroupNavigationMenuMapping.NavigationMenuId = menuid; objUserGroupNavigationMenuMapping.SchoolID = entity.SchoolID; objUserGroupNavigationMenuMapping.GroupID = entity.GroupID; objUserGroupNavigationMenuMapping.CreatedBy_ID = entity.CreatedBy_ID; objUserGroupNavigationMenuMapping.CreatedDate = DateTime.Now; objGEEDbContext.UserGroupNavigationMenuMappings.Add(objUserGroupNavigationMenuMapping); isSave = objGEEDbContext.SaveChanges(); } } } } using (GEEDbContext context = new GEEDbContext()) { byte ActionID = 1; var UId = new SqlParameter("@CUserId", entity.CreatedBy_ID); var MId = new SqlParameter("@Action", ActionID); context.Database.ExecuteSqlCommand("RoleMappingToAspNetUserRole @CUserId, @Action", UId, MId); } return(isSave); }