public ActionResult Index() { WorkPermitViewModel model = new WorkPermitViewModel(); model.WorkPermitViewModelList = pro.GetList(); return(View(model)); }
public ActionResult InsertUpdateWorkPermit(int?id) { WorkPermitViewModel model = new WorkPermitViewModel(); if (id > 0) { model = pro.GeWorkpermitById(id ?? 0); } return(View(model)); }
public void If_save_called_and_selected_exist_should_persist_record() { //Arrange var permitRepository = A.Fake <IWorkPermitRepository>(); var attachmentRepository = A.Fake <IAttachmentRepository>(); var viewModel = new MainViewModel(permitRepository, attachmentRepository); var selectedItem = new WorkPermitViewModel(null, null); viewModel.SelectedPermit = selectedItem; //Act viewModel.SavePermit(); //Assert A.CallTo(() => permitRepository.Save(A <WorkPermit> .Ignored)).MustHaveHappened(); }
public WorkPermitViewModel GeWorkpermitById(int id) { WorkPermitViewModel model = ent.WorkPermits.Select(x => new WorkPermitViewModel() { DeletedDate = x.DeletedDate, DeletedBy = x.DeletedBy, UpdatedDate = x.UpdatedDate, UpDatedBy = x.UpDatedBy, NameOfApplicant = x.NameOfApplicant, GA_Id = x.GA_Id, PA_Id = x.PA_Id, WorkPermitTypeId = x.WorkPermitTypeId, Council_sRegistrationNumber = x.Council_sRegistrationNumber, CouncilRegistrationDate = x.CouncilRegistrationDate, CouncilRegistrationDateNp = x.CouncilRegistrationDateNp, Country = x.Country, PassportNumber = x.PassportNumber, VisaDuration = x.VisaDuration, ApplicationDesingation = x.ApplicationDesingation, DecisionDate = x.DecisionDate, DecisionDateNp = x.DecisionDateNp, VisaType = x.VisaType, Remarks = x.Remarks, WorkPermitId = x.WorkPermitId, CreatedDate = DateTime.Now, CreatedBy = x.CreatedBy }).Where(x => x.WorkPermitId == id).FirstOrDefault(); model.WpaFamilyViewModelList = ent.WpaFamilies.Where(x => x.WorkPermitId == id).Select(x => new WpaFamilyViewModel() { WorkPermitId = x.WorkPermitId, WPAFamilyId = x.WPAFamilyId, Name = x.Name, Country = x.Country, PassportNO = x.PassportNO, VisaType = x.VisaType, VisaDuration = x.VisaDuration, DicisionDate = x.DicisionDate, Relation = x.Relation, remark = x.remark, DicisionDateNp = x.DicisionDateNp, }).ToList(); return(model); }
public ActionResult InsertUpdateWorkPermit(WorkPermitViewModel model) { try { var result = pro.InsertUpdateWorkPermit(model); if (result == true) { TempData["SuccessMsg"] = "सफल भयो"; return(RedirectToAction("Index")); } } catch { TempData["Msg"] = "असफल भयो "; return(View()); } return(View()); }
public ActionResult Details(int id) { WorkPermitViewModel abc = pro.GeWorkpermitById(id); return(PartialView(abc)); }
public bool InsertUpdateWorkPermit(WorkPermitViewModel model) { using (SamajkalyanEntities ent = new SamajkalyanEntities()) { try { var workPermitRow = ent.WorkPermits.Where(x => x.WorkPermitId == model.WorkPermitId).FirstOrDefault(); //_context.Database.Connection.Open(); //_context.Database.Connection.BeginTransaction(); if (workPermitRow == null) { workPermitRow = new WorkPermit(); } ; // workPermitRow.WorkPermitId = model.WorkPermitId; workPermitRow.GA_Id = model.GA_Id; workPermitRow.PA_Id = model.PA_Id; workPermitRow.WorkPermitTypeId = model.WorkPermitTypeId; workPermitRow.NameOfApplicant = model.NameOfApplicant; workPermitRow.Council_sRegistrationNumber = model.Council_sRegistrationNumber; workPermitRow.CouncilRegistrationDate = model.CouncilRegistrationDate; workPermitRow.CouncilRegistrationDateNp = model.CouncilRegistrationDateNp; workPermitRow.Country = model.Country; workPermitRow.PassportNumber = model.PassportNumber; workPermitRow.VisaDuration = model.VisaDuration; workPermitRow.ApplicationDesingation = model.ApplicationDesingation; workPermitRow.DecisionDate = model.DecisionDate; workPermitRow.VisaType = model.VisaType; workPermitRow.Remarks = model.Remarks; workPermitRow.CreatedBy = model.CreatedBy; workPermitRow.CreatedDate = model.CreatedDate; //deploymentRow.Status = true; if (model.WorkPermitId == 0) { // generalAgreementRow.Status = false; ent.WorkPermits.Add(workPermitRow); ent.SaveChanges(); } else { // deploymentRow.Status = dmodel.Status ?? false; workPermitRow.UpDatedBy = model.UpDatedBy; workPermitRow.UpdatedDate = model.UpdatedDate; ent.WorkPermits.Attach(workPermitRow); ent.Entry(workPermitRow).State = EntityState.Modified; ent.SaveChanges(); } if (model.WorkPermitId <= 0) { model.WorkPermitId = ent.Database.SqlQuery <WorkPermitViewModel>("select * from WorkPermit where WorkPermitId=(select max (WorkPermitId) from WorkPermit )").ToList().FirstOrDefault().WorkPermitId; //employeeRow.EmpId=employeeRow.EmpId != 0 ? employeeRow.EmpId : empModel.EmpId; } #region WP_FAmily using (var tempContext = new SamajkalyanEntities()) { var deletelist = tempContext.WpaFamilies.Where(x => x.WorkPermitId == model.WorkPermitId).ToList(); if (deletelist.Count > 0) { foreach (var item in deletelist) { if (model.WpaFamilyViewModelList == null) { model.WpaFamilyViewModelList = new List <WpaFamilyViewModel>(); } var isExists = model.WpaFamilyViewModelList.Where(x => x.WPAFamilyId == item.WPAFamilyId).FirstOrDefault(); if (isExists == null) { tempContext.WpaFamilies.Remove(item); tempContext.SaveChanges(); } } } } if (model.WpaFamilyViewModelList != null) { foreach (var item in model.WpaFamilyViewModelList) { WpaFamily newRow = new WpaFamily(); newRow.WorkPermitId = model.WorkPermitId; newRow.WPAFamilyId = item.WPAFamilyId; newRow.Name = item.Name; newRow.Country = item.Country; newRow.PassportNO = item.PassportNO; newRow.VisaDuration = item.VisaDuration; newRow.VisaType = item.VisaType; newRow.DicisionDate = item.DeletdDate; newRow.DicisionDateNp = item.DicisionDateNp; newRow.Relation = item.Relation; newRow.remark = item.remark; //newRow.NoOfDep = item.NoOfDep; if (item.WPAFamilyId == 0) { ent.WpaFamilies.Add(newRow); ent.SaveChanges(); } else { ent.WpaFamilies.Attach(newRow); ent.Entry(newRow).State = EntityState.Modified; ent.SaveChanges(); } } } #endregion } catch (Exception ex) { return(false); } } return(true); }