public ActionResult Insert(MZone viewModel, FormCollection formCollection)
{
MZone zone = new MZone();
TransferFormValuesTo(zone, viewModel);
zone.SetAssignedIdTo(viewModel.Id);
zone.CreatedDate = DateTime.Now;
zone.CreatedBy = User.Identity.Name;
zone.DataStatus = EnumDataStatus.New.ToString();
_mZoneRepository.Save(zone);
try
{
_mZoneRepository.DbContext.CommitChanges();
}
catch (Exception e)
{
_mZoneRepository.DbContext.RollbackTransaction();
return(Content(e.GetBaseException().Message));
}
return(Content("success"));
}
private void TransferFormValuesTo(MZone zone, MZone viewModel)
{
zone.ZoneName = viewModel.ZoneName;
zone.ZoneCity = viewModel.ZoneCity;
zone.ZoneDesc = viewModel.ZoneDesc;
zone.ZoneStatus = viewModel.ZoneStatus;
}
public virtual ActionResult GetList()
{
var zones = _mZoneRepository.GetAll();
StringBuilder sb = new StringBuilder();
MZone mZone = new MZone();
sb.AppendFormat("{0}:{1}", string.Empty, "-Pilih Wilayah-");
for (int i = 0; i < zones.Count; i++)
{
mZone = zones[i];
sb.AppendFormat(";{0}:{1}", mZone.Id, mZone.ZoneName);
}
return(Content(sb.ToString()));
}
public ActionResult Delete(MZone viewModel, FormCollection formCollection)
{
MZone mZone = _mZoneRepository.Get(viewModel.Id);
if (mZone != null)
{
_mZoneRepository.Delete(mZone);
}
try
{
_mZoneRepository.DbContext.CommitChanges();
}
catch (Exception e)
{
_mZoneRepository.DbContext.RollbackTransaction();
return(Content(e.GetBaseException().Message));
}
return(Content("success"));
}
public ActionResult Update(MZone viewModel, FormCollection formCollection)
{
MZone mZone = _mZoneRepository.Get(viewModel.Id);
TransferFormValuesTo(mZone, viewModel);
mZone.ModifiedDate = DateTime.Now;
mZone.ModifiedBy = User.Identity.Name;
mZone.DataStatus = EnumDataStatus.Updated.ToString();
_mZoneRepository.Update(mZone);
try
{
_mZoneRepository.DbContext.CommitChanges();
}
catch (Exception e)
{
_mZoneRepository.DbContext.RollbackTransaction();
return(Content(e.GetBaseException().Message));
}
return(Content("success"));
}
public static SurveyFormViewModel CreateSurveyFormViewModel(ITLoanSurveyRepository tLoanSurveyRepository, IMEmployeeRepository mEmployeeRepository, IMZoneRepository mZoneRepository, IMPartnerRepository mPartnerRepository, IMDepartmentRepository mDepartmentRepository, string loanSurveyId)
{
SurveyFormViewModel viewModel = new SurveyFormViewModel();
viewModel.CanEditId = true;
TLoanSurvey loanSurvey = null;
TLoanUnit loanUnit = null;
RefPerson person = new RefPerson();
RefAddress address = new RefAddress();
if (!string.IsNullOrEmpty(loanSurveyId))
{
loanSurvey = tLoanSurveyRepository.Get(loanSurveyId);
person = loanSurvey.LoanId.PersonId;
address = loanSurvey.LoanId.AddressId;
if (loanSurvey.LoanId.LoanUnits.Count > 0)
{
loanUnit = loanSurvey.LoanId.LoanUnits[0];
}
else
{
loanUnit = new TLoanUnit();
}
viewModel.CanEditId = true;
}
if (loanSurvey == null)
{
TLoan loan = new TLoan();
loanUnit = new TLoanUnit();
MCustomer customer = new MCustomer();
loanSurvey = new TLoanSurvey();
MZone zone = new MZone();
MPartner partner = new MPartner();
loanSurvey.LoanId = loan;
loanSurvey.LoanId.CustomerId = customer;
loanSurvey.LoanId.CustomerId.PersonId = person;
loanSurvey.LoanId.CustomerId.AddressId = address;
loanSurvey.LoanId.ZoneId = zone;
loanSurvey.LoanId.PartnerId = partner;
MEmployee emp = new MEmployee();
loan.SalesmanId = emp;
loan.SurveyorId = emp;
loan.CollectorId = emp;
loan.TLSId = emp;
}
viewModel.LoanSurvey = loanSurvey;
viewModel.LoanUnit = loanUnit;
//set asset
SetAssetCheck(loanSurvey.SurveyNeighborAsset, viewModel);
//fill gender
var values = from EnumGender e in Enum.GetValues(typeof(EnumGender))
select new { ID = e, Name = CommonHelper.GetStringValue(e) };
viewModel.GenderList = new SelectList(values, "Id", "Name", person.PersonGender);
//get education list
var edus = from EnumEducation e in Enum.GetValues(typeof(EnumEducation))
select new { ID = e, Name = CommonHelper.GetStringValue(e) };
viewModel.EducationList = new SelectList(edus, "Id", "Name", person.PersonLastEducation);
//get married status list
var merrieds = from EnumMarriedStatus e in Enum.GetValues(typeof(EnumMarriedStatus))
select new { ID = e, Name = CommonHelper.GetStringValue(e) };
viewModel.MarriedStatusList = new SelectList(merrieds, "Id", "Name", person.PersonMarriedStatus);
//get religions list
var religions = from EnumReligion e in Enum.GetValues(typeof(EnumReligion))
select new { ID = e, Name = CommonHelper.GetStringValue(e) };
viewModel.ReligionList = new SelectList(religions, "Id", "Name", person.PersonReligion);
//get house owner status list
var houses = from EnumHouseOwner e in Enum.GetValues(typeof(EnumHouseOwner))
select new { ID = e, Name = CommonHelper.GetStringValue(e) };
viewModel.HouseOwnerList = new SelectList(houses, "Id", "Name", address.AddressStatusOwner);
viewModel.GuarantorHouseOwnerList = new SelectList(houses, "Id", "Name", person.PersonGuarantorHouseOwnerStatus);
//get neighbor character list
var neighbors = from EnumNeighborChar e in Enum.GetValues(typeof(EnumNeighborChar))
select new { ID = e, Name = CommonHelper.GetStringValue(e) };
viewModel.NeighborCharList = new SelectList(neighbors, "Id", "Name", loanSurvey.SurveyNeighbor);
//get house type list
var housetypes = from EnumHouseType e in Enum.GetValues(typeof(EnumHouseType))
select new { ID = e, Name = CommonHelper.GetStringValue(e) };
viewModel.HouseTypeList = new SelectList(housetypes, "Id", "Name", loanSurvey.SurveyHouseType);
//get known customer list
var knowcustomers = from EnumKnowCustomer e in Enum.GetValues(typeof(EnumKnowCustomer))
select new { ID = e, Name = CommonHelper.GetStringValue(e) };
viewModel.KnowCustomerList = new SelectList(knowcustomers, "Id", "Name", loanSurvey.LoanId.LoanIsSalesmanKnownCustomer);
MEmployee employee = new MEmployee();
var listSaEmployee = mEmployeeRepository.GetEmployeeByDept(EnumDepartment.SA.ToString());
listSaEmployee.Insert(0, employee);
var salesman = from emp in listSaEmployee
select new { Id = emp.Id, Name = emp.PersonId != null ? emp.PersonId.PersonName : "-Pilih Salesman-" };
viewModel.SalesmanList = new SelectList(salesman, "Id", "Id", loanSurvey.LoanId.SalesmanId != null ? loanSurvey.LoanId.SalesmanId.Id : string.Empty);
var listSuEmployee = mEmployeeRepository.GetEmployeeByDept(EnumDepartment.SU.ToString());
listSuEmployee.Insert(0, employee);
var surveyor = from emp in listSuEmployee
select new { Id = emp.Id, Name = emp.PersonId != null ? emp.PersonId.PersonName : "-Pilih Surveyor-" };
viewModel.SurveyorList = new SelectList(surveyor, "Id", "Id", loanSurvey.LoanId.SurveyorId != null ? loanSurvey.LoanId.SurveyorId.Id : string.Empty);
var listColEmployee = mEmployeeRepository.GetEmployeeByDept(EnumDepartment.COL.ToString());
listColEmployee.Insert(0, employee);
var collector = from emp in listColEmployee
select new { Id = emp.Id, Name = emp.PersonId != null ? emp.PersonId.PersonName : "-Pilih Kolektor-" };
viewModel.CollectorList = new SelectList(collector, "Id", "Id", loanSurvey.LoanId.CollectorId != null ? loanSurvey.LoanId.CollectorId.Id : string.Empty);
var listTlsEmployee = mEmployeeRepository.GetEmployeeByDept(EnumDepartment.TLS.ToString());
listTlsEmployee.Insert(0, employee);
var tls = from emp in listTlsEmployee
select new { Id = emp.Id, Name = emp.PersonId != null ? emp.PersonId.PersonName : "-Pilih Team Leader-" };
viewModel.TLSList = new SelectList(tls, "Id", "Id", loanSurvey.LoanId.TLSId != null ? loanSurvey.LoanId.TLSId.Id : string.Empty);
var listZone = mZoneRepository.GetAll();
MZone z = new MZone();
z.ZoneName = "-Pilih Wilayah-";
listZone.Insert(0, z);
var zones = from zo in listZone
select new { Id = zo.Id, Name = zo.ZoneName };
viewModel.ZoneList = new SelectList(zones, "Id", "Name", loanSurvey.LoanId.ZoneId != null ? loanSurvey.LoanId.ZoneId.Id : string.Empty);
var listPartner = mPartnerRepository.GetAll();
MPartner p = new MPartner();
p.PartnerName = "-Pilih Toko-";
listPartner.Insert(0, p);
var partners = from prtner in listPartner
select new { Id = prtner.Id, Name = prtner.PartnerName };
viewModel.PartnerList = new SelectList(partners, "Id", "Name", loanSurvey.LoanId.PartnerId != null ? loanSurvey.LoanId.PartnerId.Id : string.Empty);
const string separator = "|";
string[] photos = new string[0];//= loanSurvey.LoanId.LoanDesc.Split(separator.ToCharArray(), StringSplitOptions.RemoveEmptyEntries);
if (!string.IsNullOrEmpty(loanSurvey.LoanId.LoanDesc))
{
photos = loanSurvey.LoanId.LoanDesc.Split(separator.ToCharArray(), StringSplitOptions.RemoveEmptyEntries);
}
viewModel.Photo1 = "~/Content/Images/no_photo104_on.jpg";
viewModel.Photo2 = "~/Content/Images/no_photo104_on.jpg";
if (photos.Count() > 0)
{
viewModel.Photo1 = photos[0];
}
if (photos.Count() > 1)
{
viewModel.Photo2 = photos[1];
}
return(viewModel);
}
public static LoanViewModel Create(EnumLoanStatus?loanStatus, IMEmployeeRepository mEmployeeRepository, IMZoneRepository mZoneRepository)
{
var viewModel = new LoanViewModel();
viewModel.ShowInstallmentSubGrid = false;
viewModel.ShowLegend = true;
if (loanStatus != null)
{
switch (loanStatus)
{
case EnumLoanStatus.OK:
viewModel.ShowInstallmentSubGrid = true;
break;
case EnumLoanStatus.Cancel:
viewModel.ShowLegend = false;
break;
case EnumLoanStatus.Reject:
viewModel.ShowLegend = false;
break;
case EnumLoanStatus.LatePay:
viewModel.ShowLegend = false;
viewModel.ShowInstallmentSubGrid = true;
break;
case EnumLoanStatus.Paid:
viewModel.ShowLegend = false;
viewModel.ShowInstallmentSubGrid = true;
break;
}
}
MEmployee employee = new MEmployee();
var listSaEmployee = mEmployeeRepository.GetEmployeeByDept(EnumDepartment.SA.ToString());
listSaEmployee.Insert(0, employee);
var salesman = from emp in listSaEmployee
select new { Id = emp.Id, Name = emp.PersonId != null ? emp.PersonId.PersonName : "-Semua Salesman-" };
viewModel.SalesmanList = new SelectList(salesman, "Id", "Id", string.Empty);
var listSuEmployee = mEmployeeRepository.GetEmployeeByDept(EnumDepartment.SU.ToString());
listSuEmployee.Insert(0, employee);
var surveyor = from emp in listSuEmployee
select new { Id = emp.Id, Name = emp.PersonId != null ? emp.PersonId.PersonName : "-Semua Surveyor-" };
viewModel.SurveyorList = new SelectList(surveyor, "Id", "Id", string.Empty);
var listColEmployee = mEmployeeRepository.GetEmployeeByDept(EnumDepartment.COL.ToString());
listColEmployee.Insert(0, employee);
var collector = from emp in listColEmployee
select new { Id = emp.Id, Name = emp.PersonId != null ? emp.PersonId.PersonName : "-Semua Kolektor-" };
viewModel.CollectorList = new SelectList(collector, "Id", "Id", string.Empty);
var listTlsEmployee = mEmployeeRepository.GetEmployeeByDept(EnumDepartment.TLS.ToString());
listTlsEmployee.Insert(0, employee);
var tls = from emp in listTlsEmployee
select new { Id = emp.Id, Name = emp.PersonId != null ? emp.PersonId.PersonName : "-Semua Team Leader-" };
viewModel.TLSList = new SelectList(tls, "Id", "Id", string.Empty);
var listZone = mZoneRepository.GetAll();
MZone z = new MZone();
z.ZoneName = "-Semua Wilayah-";
listZone.Insert(0, z);
var zones = from zo in listZone
select new { Id = zo.Id, Name = zo.ZoneName };
viewModel.ZoneList = new SelectList(zones, "Id", "Name", string.Empty);
return(viewModel);
}
