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