public ActionResult Edit(int id)
{
RequestFormViewModel viewModel =
_requestManagementService.CreateFormViewModelFor(id);
return(View(viewModel));
}
public ActionResult Create()
{
RequestFormViewModel viewModel =
_requestManagementService.CreateFormViewModel();
return(View(viewModel));
}
protected void LoadViewModel(RequestFormViewModel viewModel)
{
viewModel.BudgetLocations = _agencyManagementService.GetAll();
viewModel.ExecutiveSponsors = (viewModel.Request != null &&
viewModel.Request.ExecutiveSponsorPersonId.HasValue)
? _personManagementService.GetActiveStaffWithAgency(
viewModel.Request.ExecutiveSponsorPersonId.Value)
: _personManagementService.GetActiveStaffWithAgency();
viewModel.ITDivisions = _orgManagementService.GetByAgency(13);
viewModel.ProjectManagers = (viewModel.Request != null &&
viewModel.Request.ProjectManagerId.HasValue)
? _personManagementService.GetActiveStaff(
viewModel.Request.ProjectManagerId.Value)
: _personManagementService.GetActiveStaff();
viewModel.RequestStatuses = _requestStatusManagementService.GetAll();
viewModel.RequestTypes = _requestTypeManagementService.GetAll();
viewModel.UserLeads = (viewModel.Request != null &&
viewModel.Request.UserLeadPersonId.HasValue)
? _personManagementService.GetActiveStaffWithAgency(
viewModel.Request.UserLeadPersonId.Value)
: _personManagementService.GetActiveStaffWithAgency();
viewModel.WrmsSystems = _wrmsSystemManagementService.GetActiveSystems();
if (viewModel.Request != null && viewModel.Request.Id > 0)
{
viewModel.TotalRequestHours = _timeEntryManagementService.GetTotalHours(viewModel.Request.Id);
}
}
public ActionResult Edit(Request request)
{
try
{
if (ViewData.ModelState.IsValid)
{
request.LastUpdateTimeStamp = DateTime.Now;
request.LastUpdateUser = GetCurrentUser().Id;
ActionConfirmation updateConfirmation =
_requestManagementService.UpdateWith(request, request.Id);
if (updateConfirmation.WasSuccessful)
{
TempData[ControllerEnums.GlobalViewDataProperty.PageMessage.ToString()] =
updateConfirmation.Message;
//return RedirectToAction("Index");
return(RedirectToAction("Search"));
}
}
}
catch (PreconditionException pce)
{
TempData[ControllerEnums.GlobalViewDataProperty.PageMessage.ToString()] =
pce.Message;
}
RequestFormViewModel viewModel =
_requestManagementService.CreateFormViewModelFor(request);
return(View(viewModel));
}
public void CannotUpdateInvalidRequestFromForm()
{
// Establish Context
var requestFromForm = new Request();
var viewModelToExpect = new RequestFormViewModel();
var testUser = new Person();
testUser.SetAssignedIdTo(1);
_authenticationProvider.Expect(r => r.GetLoggedInUser()).Return("user1");
_personManagementService.Expect(r => r.GetByUserName("user1")).Return(testUser);
_requestManagementService.Expect(r => r.UpdateWith(requestFromForm, 0))
.Return(ActionConfirmation.CreateFailureConfirmation("not updated"));
_requestManagementService.Expect(r => r.CreateFormViewModelFor(requestFromForm))
.Return(viewModelToExpect);
// Act
ViewResult result =
_requestsController.Edit(requestFromForm).AssertViewRendered();
// Assert
result.ViewData.Model.ShouldNotBeNull();
(result.ViewData.Model as RequestFormViewModel).ShouldNotBeNull();
}
public RequestFormViewModel CreateFormViewModel()
{
var viewModel = new RequestFormViewModel();
LoadViewModel(viewModel);
return(viewModel);
}
public RequestFormViewModel GetRequestFormById(int id)
{
var documentUploadViewModel = new RequestFormViewModel();
var kycdetails = _context.Database.SqlQuery <RequestFormViewModel>("GetKYCDetailsForRequestForm @KycId", new SqlParameter("KycId", id)).FirstOrDefault();
var KycAddressDetailsList = _context.Trans_KYCAddresses.Where(x => x.KYCID == kycdetails.KycId).ToList();
documentUploadViewModel = ToViewModelDocUpload(kycdetails, KycAddressDetailsList);
return(documentUploadViewModel);
}
public RequestFormViewModel CreateFormViewModelFor(Request request)
{
var viewModel = new RequestFormViewModel {
Request = request
};
LoadViewModel(viewModel);
return(viewModel);
}
// GET: RequestForm
public ActionResult RequestForm()
{
ButtonVisiblity("Index");
BindList();
Session["documentsub"] = null;
RequestFormViewModel kycVM = new RequestFormViewModel();
KYCAddressesVM addressvm = new KYCAddressesVM();
kycVM.Trans_KYCAddresses.Add(addressvm);
kycVM.TransactionId = _requestFormService.GetMaxTransactionId();
kycVM.KYCDate = DateTime.Now.ToShortDateString();
return(View(kycVM));
}
public void CanCreateFormViewModel()
{
// Establish Context
var viewModelToExpect = new RequestFormViewModel();
// Act
RequestFormViewModel viewModelRetrieved =
_requestManagementService.CreateFormViewModel();
// Assert
viewModelRetrieved.ShouldNotBeNull();
viewModelRetrieved.Request.ShouldBeNull();
}
public void CanCreateFormViewModel()
{
// Establish Context
var viewModelToExpect = new RequestFormViewModel();
// Act
RequestFormViewModel viewModelRetrieved =
_requestManagementService.CreateFormViewModel();
// Assert
viewModelRetrieved.ShouldNotBeNull();
viewModelRetrieved.Request.ShouldBeNull();
}
public RequestFormViewModel ToViewModelDocUpload(RequestFormViewModel model, List <Trans_KYCAddresses> KycAddressDetailsList)
{
List <KYCAddressesVM> AddressDetailsList = new List <KYCAddressesVM>();
foreach (var c in KycAddressDetailsList)
{
var TrnViewModel = new KYCAddressesVM();
TrnViewModel.ID = c.ID;
TrnViewModel.KYCID = c.KYCID;
TrnViewModel.AddressCategory = c.AddressCategory;
TrnViewModel.ResidenceCode = c.ResidenceCode;
TrnViewModel.BuildingHouseName = c.BuildingHouseName;
TrnViewModel.Road = c.Road;
TrnViewModel.BuildingPlotNo = c.BuildingPlotNo;
TrnViewModel.RoomBlockNo = c.RoomBlockNo;
TrnViewModel.NearestLandmark = c.NearestLandmark;
TrnViewModel.Distance_km = c.Distance_km;
TrnViewModel.PinCode = (int)c.PinCode;
TrnViewModel.ResidenceCode = c.ResidenceCode;
AddressDetailsList.Add(TrnViewModel);
}
model.Trans_KYCAddresses = AddressDetailsList;
var docuploaddetails = (from a in _context.Trn_DocUploadDetails
join b in _context.Mst_DocumentType on a.DocumentTypeId equals b.Id
join c in _context.tblDocumentMasters on a.DocumentId equals c.DocumentID
where a.KycId == model.KycId && a.Status != "Rejected"
select new DocumentUploadDetailsVM()
{
ID = a.Id,
DocumentTypeId = a.DocumentTypeId,
DocumentTypeName = b.Name,
DocumentName = c.DocumentName,
DocumentId = a.DocumentId,
ExpiryDate = a.ExpiryDate,
FileName = a.FileName,
FileExtension = a.ContentType,
KycId = a.KycId,
Status = a.Status,
VerifiedBy = a.VerifiedBy,
SpecifyOther = a.SpecifyOther,
NameonDocument = a.NameonDocument,
ReasonForRejection = a.ReasonForRejection
}).ToList();
model.DocumentUploadList = docuploaddetails;
return(model);
}
public ActionResult ModifyAddress(RequestFormViewModel model)
{
var u = accountService.GetUserInfo();
var r = memberService.ModifyAddress(new MemberModifyDto()
{
MBR_ID = u.MBR_ID,
CONTACT_ZIP_CODE = model.ContactZipCode,
CONTACT_COUNTY = model.ContactCounty,
CONTACT_DIST = model.ContactDist,
CONTACT_ADDR = model.ContactAddr,
});
return(Json(new { result = r.RESULT, message = r.ERRMSG }, JsonRequestBehavior.AllowGet));
}
public void CanInitEdit()
{
// Establish Context
var viewModel = new RequestFormViewModel();
_requestManagementService.Expect(r => r.CreateFormViewModelFor(1))
.Return(viewModel);
// Act
ViewResult result = _requestsController.Edit(1).AssertViewRendered();
// Assert
result.ViewData.Model.ShouldNotBeNull();
(result.ViewData.Model as RequestFormViewModel).ShouldNotBeNull();
}
public ActionResult RequestForm(RequestFormViewModel model)
{
var PSN_BIRTHDAY = new DateTime(int.Parse(model.BirthdayYear), int.Parse(model.BirthdayMonth), int.Parse(model.BirthdayDay), 0, 0, 0, DateTimeKind.Local);
var diff = DateTime.Now.AddYears(-20) - PSN_BIRTHDAY;
if (diff.TotalDays < 0)
{
return(Json(new { result = false, message = "生日有誤，申請會員年齡不得小於20歲" }, JsonRequestBehavior.AllowGet));
}
var u = acct.GetUserInfo();
if (acct.HasCustId(model.Id, u.MBR_ID))
{
return(Json(new { result = false, message = "身分證帳號已存在" }, JsonRequestBehavior.AllowGet));
}
var r1 = service.RealRegisterIdcardApply();
if (!r1.RESULT)
{
return(Json(new { result = false, message = r1.ERRMSG }, JsonRequestBehavior.AllowGet));
}
else
{
var r = member.Modify(new MemberModifyDto()
{
MBR_ID = u.MBR_ID,
MBR_ACCT = u.MBR_ACCT,
CUST_ID = model.Id,
CUST_KIND = "2",
CUST_NAME = model.Name,
EMAIL = u.MBR_ACCT,
CONTACT_ZIP_CODE = model.ContactZipCode,
CONTACT_COUNTY = model.ContactCounty,
CONTACT_DIST = model.ContactDist,
CONTACT_ADDR = model.ContactAddr,
PSN_BIRTHDAY = PSN_BIRTHDAY.ToString("yyyyMMdd"),
PSN_GENDER = model.Gender,
PSN_REG_ZIP_CODE = model.RegZipCode,
PSN_REG_COUNTY = model.RegCounty,
PSN_REG_DIST = model.RegDist,
PSN_REG_ADDR = model.RegAddr,
});
return(Json(new { result = r.RESULT, message = r.ERRMSG }, JsonRequestBehavior.AllowGet));
}
}
public JsonResult CreateEdit(RequestFormViewModel model)
{
try
{
if (model.CustomerID != null)
{
model.DocumentUploadList = (List <DocumentUploadDetailsVM>)Session["documentsub"];
_requestFormService.SaveRecord(model);
}
return(Json(model));
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public void CanInitCreate()
{
// Establish Context
var viewModel = new RequestFormViewModel();
_requestManagementService.Expect(r => r.CreateFormViewModel())
.Return(viewModel);
// Act
ViewResult result = _requestsController.Create().AssertViewRendered();
// Assert
result.ViewData.Model.ShouldNotBeNull();
(result.ViewData.Model as RequestFormViewModel).ShouldNotBeNull();
(result.ViewData.Model as RequestFormViewModel).Request.ShouldBeNull();
}
public void CanCreateFormViewModelForRequest()
{
// Establish Context
var viewModelToExpect = new RequestFormViewModel();
Request request =
RequestInstanceFactory.CreateValidTransientRequest();
_requestRepository.Expect(r => r.Get(1))
.Return(request);
// Act
RequestFormViewModel viewModelRetrieved =
_requestManagementService.CreateFormViewModelFor(1);
// Assert
viewModelRetrieved.ShouldNotBeNull();
viewModelRetrieved.Request.ShouldNotBeNull();
viewModelRetrieved.Request.ShouldEqual(request);
}
public void CanCreateFormViewModelForRequest()
{
// Establish Context
var viewModelToExpect = new RequestFormViewModel();
Request request =
RequestInstanceFactory.CreateValidTransientRequest();
_requestRepository.Expect(r => r.Get(1))
.Return(request);
// Act
RequestFormViewModel viewModelRetrieved =
_requestManagementService.CreateFormViewModelFor(1);
// Assert
viewModelRetrieved.ShouldNotBeNull();
viewModelRetrieved.Request.ShouldNotBeNull();
viewModelRetrieved.Request.ShouldEqual(request);
}
public ActionResult SubmitRequest()
{
// Business rule: a student may only have 3 total requests at one point in time. Check against this first:
if (CanSubmitRequest())
{
var Categories = _context.ItemCategory.ToList();
var viewModel = new RequestFormViewModel
{
RequestCategories = Categories
};
return(View("RequestForm", viewModel));
}
else
{
// add entry to TempData for use in displaying notification (with toastr)
TempData["RequestLimit"] = "Invalid request.";
return(RedirectToAction("Index", "Home"));
}
}
public void CannotUpdateInvalidRequestFromForm()
{
// Establish Context
var requestFromForm = new Request();
var viewModelToExpect = new RequestFormViewModel();
var testUser = new Person();
testUser.SetAssignedIdTo(1);
_authenticationProvider.Expect(r => r.GetLoggedInUser()).Return("user1");
_personManagementService.Expect(r => r.GetByUserName("user1")).Return(testUser);
_requestManagementService.Expect(r => r.UpdateWith(requestFromForm, 0))
.Return(ActionConfirmation.CreateFailureConfirmation("not updated"));
_requestManagementService.Expect(r => r.CreateFormViewModelFor(requestFromForm))
.Return(viewModelToExpect);
// Act
ViewResult result =
_requestsController.Edit(requestFromForm).AssertViewRendered();
// Assert
result.ViewData.Model.ShouldNotBeNull();
(result.ViewData.Model as RequestFormViewModel).ShouldNotBeNull();
}
public void SaveRecord(RequestFormViewModel model)
{
_requestFormRepository.SaveRecord(model);
}
protected void LoadViewModel(RequestFormViewModel viewModel)
{
viewModel.BudgetLocations = _agencyManagementService.GetAll();
viewModel.ExecutiveSponsors = (viewModel.Request != null &&
viewModel.Request.ExecutiveSponsorPersonId.HasValue)
? _personManagementService.GetActiveStaffWithAgency(
viewModel.Request.ExecutiveSponsorPersonId.Value)
: _personManagementService.GetActiveStaffWithAgency();
viewModel.ITDivisions = _orgManagementService.GetByAgency(13);
viewModel.ProjectManagers = (viewModel.Request != null &&
viewModel.Request.ProjectManagerId.HasValue)
? _personManagementService.GetActiveStaff(
viewModel.Request.ProjectManagerId.Value)
: _personManagementService.GetActiveStaff();
viewModel.RequestStatuses = _requestStatusManagementService.GetAll();
viewModel.RequestTypes = _requestTypeManagementService.GetAll();
viewModel.UserLeads = (viewModel.Request != null &&
viewModel.Request.UserLeadPersonId.HasValue)
? _personManagementService.GetActiveStaffWithAgency(
viewModel.Request.UserLeadPersonId.Value)
: _personManagementService.GetActiveStaffWithAgency();
viewModel.WrmsSystems = _wrmsSystemManagementService.GetActiveSystems();
if (viewModel.Request != null && viewModel.Request.Id > 0)
{
viewModel.TotalRequestHours = _timeEntryManagementService.GetTotalHours(viewModel.Request.Id);
}
}
public RequestFormViewModel CreateFormViewModel()
{
var viewModel = new RequestFormViewModel();
LoadViewModel(viewModel);
return viewModel;
}
public void SaveRecord(RequestFormViewModel model)
{
try
{
TGLKYC_BasicDetails tGLKYC_Basic = _context.TGLKYC_BasicDetails.Where(x => x.KYCID == model.KycId).FirstOrDefault();
if (tGLKYC_Basic != null)
{
tGLKYC_Basic.KYCDate = Convert.ToDateTime(model.KYCDate);
tGLKYC_Basic.ApplicationNo = model.ApplicationNo;
tGLKYC_Basic.CustomerID = model.CustomerID;
tGLKYC_Basic.ResidenceCode = model.ResidenceCode;
tGLKYC_Basic.BldgHouseName = model.BldgHouseName;
tGLKYC_Basic.Road = model.Road;
tGLKYC_Basic.BldgPlotNo = model.BldgPlotNo;
tGLKYC_Basic.RoomBlockNo = model.RoomBlockNo;
tGLKYC_Basic.Landmark = model.Landmark;
tGLKYC_Basic.Distance = model.Distance;
tGLKYC_Basic.PinCode = model.PinCode;
tGLKYC_Basic.MobileNo = model.MobileNo;
tGLKYC_Basic.EmailID = model.EmailID;
tGLKYC_Basic.BranchID = Convert.ToInt32(HttpContext.Current.Session["BranchId"]);
tGLKYC_Basic.CmpID = Convert.ToInt32(HttpContext.Current.Session["CompanyId"]);
tGLKYC_Basic.FYID = Convert.ToInt32(HttpContext.Current.Session["FinancialYearId"]);
tGLKYC_Basic.UpdatedDate = DateTime.Now;
tGLKYC_Basic.UpdatedBy = Convert.ToInt32(HttpContext.Current.Session["UserLoginId"]);
tGLKYC_Basic.AddressCategory = "02";
_context.SaveChanges();
foreach (var item in model.Trans_KYCAddresses)
{
Trans_KYCAddresses trans_KYCAddresses = new Trans_KYCAddresses();
trans_KYCAddresses = _context.Trans_KYCAddresses.Where(x => x.KYCID == model.KycId && x.ID == item.ID).FirstOrDefault();
if (trans_KYCAddresses != null)
{
trans_KYCAddresses.AddressCategory = item.AddressCategory;
trans_KYCAddresses.ResidenceCode = item.ResidenceCode;
trans_KYCAddresses.BuildingHouseName = item.BuildingHouseName;
trans_KYCAddresses.Road = item.Road;
trans_KYCAddresses.BuildingPlotNo = item.BuildingPlotNo;
trans_KYCAddresses.RoomBlockNo = item.RoomBlockNo;
trans_KYCAddresses.NearestLandmark = item.NearestLandmark;
trans_KYCAddresses.Distance_km = item.Distance_km;
trans_KYCAddresses.PinCode = item.PinCode;
trans_KYCAddresses.CreatedDate = DateTime.Now;
trans_KYCAddresses.KYCID = tGLKYC_Basic.KYCID;
_context.SaveChanges();
}
}
List <Trn_DocUploadDetails> NewDocUploadDetails = new List <Trn_DocUploadDetails>();
//update the data in Charge Details table
foreach (var p in model.DocumentUploadList)
{
var FindRateobject = _context.Trn_DocUploadDetails.Where(x => x.Id == p.ID && x.KycId == model.KycId).FirstOrDefault();
if (FindRateobject == null)
{
var ratetrnnew = new Trn_DocUploadDetails
{
KycId = model.KycId,
DocumentTypeId = (int)p.DocumentTypeId,
DocumentId = (int)p.DocumentId,
ExpiryDate = p.ExpiryDate,
FileName = p.FileName,
ContentType = p.FileExtension,
UploadFile = p.UploadDocName,
SpecifyOther = p.SpecifyOther,
NameonDocument = p.NameonDocument,
Status = "Pending"
};
_context.Trn_DocUploadDetails.Add(ratetrnnew);
}
else
{
var uploadfile = _context.Trn_DocUploadDetails.Where(x => x.Id == FindRateobject.Id).Select(x => x.UploadFile).FirstOrDefault();
FindRateobject.KycId = model.KycId;
FindRateobject.DocumentTypeId = (int)p.DocumentTypeId;
FindRateobject.DocumentId = (int)p.DocumentId;
FindRateobject.ExpiryDate = p.ExpiryDate;
FindRateobject.FileName = p.FileName;
FindRateobject.ContentType = p.FileExtension;
FindRateobject.UploadFile = uploadfile;
FindRateobject.SpecifyOther = p.SpecifyOther;
FindRateobject.NameonDocument = p.NameonDocument;
}
NewDocUploadDetails.Add(FindRateobject);
}
#region doc details remove
//take the loop of table and check from list if found in list then not remove else remove from table itself
var trnobjlist = _context.Trn_DocUploadDetails.Where(x => x.KycId == model.KycId).ToList();
if (trnobjlist != null)
{
foreach (Trn_DocUploadDetails item in trnobjlist)
{
if (NewDocUploadDetails.Contains(item))
{
continue;
}
else
{
_context.Trn_DocUploadDetails.Remove(item);
}
}
_context.SaveChanges();
}
#endregion product trn remove
var requestform = new Trn_RequestForm
{
KycId = model.KycId,
SanctionId = model.SanctionId,
creationdate = DateTime.Now
};
_context.Trn_RequestForm.Add(requestform);
_context.SaveChanges();
}
}
catch (Exception e)
{
throw e;
}
}
public RequestFormViewModel CreateFormViewModelFor(Request request)
{
var viewModel = new RequestFormViewModel { Request = request };
LoadViewModel(viewModel);
return viewModel;
}
public RequestFormPage()
{
InitializeComponent();
BindingContext = new RequestFormViewModel();
}
