public int Save(SetupBranchViewModel model) { //var user = Userprovider.CustomeUserManager.GetUserDetails(); SetupBranch setupBranchEntity = new SetupBranch(); var data = _ent.SetupBranches.Where(x => x.BranchName == model.BranchName.Trim() && x.HeadOfficeId == model.HeadOfficeId && x.DeletedDate == null).ToList(); if (data.Count > 0) { return(2); } setupBranchEntity.BranchCode = model.BranchName; setupBranchEntity.HeadOfficeId = model.HeadOfficeId ?? 0; setupBranchEntity.BranchName = model.BranchName; setupBranchEntity.ImageName = model.ImageName; setupBranchEntity.ImagePath = model.ImagePath; setupBranchEntity.Location = model.Location; setupBranchEntity.State = model.State; setupBranchEntity.District = model.District; setupBranchEntity.Metropolitan = model.Metropolitan; setupBranchEntity.SubMetropolitan = model.SubMetropolitan; setupBranchEntity.Municipality = model.Municipality; setupBranchEntity.GauPalika = model.GauPalika; setupBranchEntity.WardNo = model.WardNo; setupBranchEntity.EmailId = model.EmailId; setupBranchEntity.Web = model.Web; setupBranchEntity.PhoneNumber = model.PhoneNumber; setupBranchEntity.PanNo = model.PanNo; setupBranchEntity.VatNo = model.VatNo; setupBranchEntity.EstablishDate = model.EstablishDate; setupBranchEntity.RegisteredDate = model.RegisteredDate; if (model.BranchId > 0) { setupBranchEntity.Status = model.Status; setupBranchEntity.UpdatedBy = 1;// user.UserId; setupBranchEntity.BranchId = model.BranchId; setupBranchEntity.UpdatedDate = DateTime.UtcNow; _ent.Entry(setupBranchEntity).State = EntityState.Modified; _ent.Entry(setupBranchEntity).Property(x => x.CreatedBy).IsModified = false; _ent.Entry(setupBranchEntity).Property(x => x.CreatedDate).IsModified = false; } else { setupBranchEntity.Status = true; setupBranchEntity.CreatedBy = 1;// user.UserId; setupBranchEntity.CreatedDate = DateTime.UtcNow; _ent.Entry(setupBranchEntity).State = EntityState.Added; } try { _ent.SaveChanges(); return(1); } catch (Exception ex) { return(0); } }
public int Save(SetupHeadOfficeViewModel model) { SetupHaeadOffice headOfficeEntity = new SetupHaeadOffice(); var data = (_ent.SetupHaeadOffices.Where(h => h.HeadOfficeName == model.HeadOfficeName.Trim() && h.DeletedDate == null)).ToList(); if (data.Count > 0) { return(2); } headOfficeEntity.HeadOfficeCode = model.HeadOfficeCode; headOfficeEntity.HeadOfficeName = model.HeadOfficeName; headOfficeEntity.ImageName = model.ImageName; headOfficeEntity.ImagePath = model.ImagePath; headOfficeEntity.Location = model.Location; headOfficeEntity.State = model.State; headOfficeEntity.District = model.District; headOfficeEntity.Metropolitan = model.Metropolitan; headOfficeEntity.SubMetropolitan = model.SubMetropolitan; headOfficeEntity.Municipality = model.Municipality; headOfficeEntity.GauPalika = model.GauPalika; headOfficeEntity.WardNo = model.WardNo; headOfficeEntity.EmailId = model.EmailId; headOfficeEntity.Web = model.Web; headOfficeEntity.PhoneNumber = model.PhoneNumber; headOfficeEntity.PanNo = model.PanNo; headOfficeEntity.VatNo = model.VatNo; headOfficeEntity.EstablishDate = model.EstablishDate; headOfficeEntity.RegisteredDate = model.RegisteredDate; if (model.HeadOfficeId > 0) { headOfficeEntity.HeadOfficeId = model.HeadOfficeId; headOfficeEntity.Status = model.Status; headOfficeEntity.UpdatedBy = 1; headOfficeEntity.UpdatedDate = DateTime.UtcNow; _ent.Entry(headOfficeEntity).State = EntityState.Modified; _ent.Entry(headOfficeEntity).Property(x => x.CreatedBy).IsModified = false; _ent.Entry(headOfficeEntity).Property(x => x.CreatedDate).IsModified = false; } else { headOfficeEntity.Status = true; headOfficeEntity.CreatedBy = 1; headOfficeEntity.CreatedDate = DateTime.UtcNow; _ent.Entry(headOfficeEntity).State = EntityState.Added; } try { _ent.SaveChanges(); return(1); } catch (Exception) { return(0); } }
public ActionResult Edit([Bind(Include = "id,Name,Supplier,Title,StartDate,EndDate,TimeH,TimeM,AllDay")] Schedule schedule) { if (ModelState.IsValid) { db.Entry(schedule).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(schedule)); }
public int Save(SetupDepartmentViewModel model) { //var user = Userprovider.CustomeUserManager.GetUserDetails(); SetupDepartment setupDepartmentEntity = new SetupDepartment(); setupDepartmentEntity.DepartmentName = model.DepartmentName; var data = _ent.SetupDepartments.Where(x => x.DepartmentName == model.DepartmentName.Trim() && x.DeletedDate == null).ToList(); if (data.Count > 0) { return(2); } if (model.DepartmentId > 0) { setupDepartmentEntity.Status = model.Status; setupDepartmentEntity.UpdatedBy = 1;// user.UserId; setupDepartmentEntity.DepartmentId = model.DepartmentId; setupDepartmentEntity.UpdatedDate = DateTime.UtcNow; _ent.Entry(setupDepartmentEntity).State = EntityState.Modified; _ent.Entry(setupDepartmentEntity).Property(x => x.CreatedBy).IsModified = false; _ent.Entry(setupDepartmentEntity).Property(x => x.CreatedDate).IsModified = false; } else { setupDepartmentEntity.Status = true; setupDepartmentEntity.CreatedBy = 1;// user.UserId; setupDepartmentEntity.CreatedDate = DateTime.UtcNow; _ent.Entry(setupDepartmentEntity).State = EntityState.Added; } try { _ent.SaveChanges(); return(1); } catch (Exception ex) { return(0); } }
public IHttpActionResult Delete(string username) { if (username == null) { return(BadRequest("Not a valid student id")); } using (DMSEntities dbContext = new DMSEntities()) { var student = dbContext.users .Where(s => s.Username == username) .FirstOrDefault(); dbContext.Entry(student).State = System.Data.Entity.EntityState.Deleted; dbContext.SaveChanges(); } return(Ok()); }