public ActionResult DdlPriorityLvl(string source, string empPost, string prospect)
{
TaskInquiryProvider taskInquiryProvider = new TaskInquiryProvider();
var result = taskInquiryProvider.ddlPriorityLevel(source, empPost, prospect);
return(Json(result));
}
public ActionResult ListDetailTask(string idTask)
{
TaskInquiryProvider taskInquiryProvider = new TaskInquiryProvider();
var result = taskInquiryProvider.getDetail(idTask);
return(Json(result));
}
public ActionResult ListDetail(ParamListDetail model)
{
TaskInquiryProvider taskInquiryProvider = new TaskInquiryProvider();
var result = taskInquiryProvider.get(model);
return(Json(result));
}
// GET: TaskInquiry
public ActionResult Index(string emp_no)
{
try
{
TaskInquiryProvider taskInquiryProvider = new TaskInquiryProvider();
Boolean isSucceed = true;
var model = new IndexViewModel();
model.ddlRegion = taskInquiryProvider.ddlRegion().ToList();
model.ddlBranch = taskInquiryProvider.ddlBranch().ToList();
model.ddlEmpPosition = taskInquiryProvider.ddlEmpPosition().ToList();
model.ddlStsProspek = taskInquiryProvider.ddlStsProspek().ToList();
model.ddlPriorityLevel = taskInquiryProvider.ddlPriorityLevel("All", "All", "All").ToList();
model.ddlStatusDukcapil = taskInquiryProvider.ddlStatusDukcapil().ToList();
model.ddlSourceData = taskInquiryProvider.ddlSourceData().ToList();
var base64EncodedBytes = System.Convert.FromBase64String(emp_no);
var empNo = System.Text.Encoding.UTF8.GetString(base64EncodedBytes);
model.empNo = empNo;
isSucceed = taskInquiryProvider.validasiUser(model.empNo);
model.empName = taskInquiryProvider.getUser(model.empNo);
if (isSucceed)
{
ViewData["empNames"] = model.empName;
return(View(model));
}
else
{
return(View("~/Views/Shared/Error.cshtml"));
}
}
catch (Exception ex)
{
return(View("~/Views/Shared/Error.cshtml"));
}
}
public IActionResult ValidasiDownload(string pEmpNo)
{
TaskInquiryProvider taskInquiryProvider = new TaskInquiryProvider();
Boolean isSucceed = true;
isSucceed = taskInquiryProvider.validasiDownload(pEmpNo);
return(Json(isSucceed));
}
public IActionResult DecriptUser(string Id, string userName)
{
TaskInquiryProvider taskInquiryProvider = new TaskInquiryProvider();
Boolean isSucceed = true;
var idDecript = Id + "|" + userName;
var idDecriptEncrypt = System.Text.Encoding.UTF8.GetBytes(idDecript);
var idDecriptEncrypt64 = Convert.ToBase64String(idDecriptEncrypt);
var result = idDecriptEncrypt64;
return(Json(result));
}
// GET: TaskInquiry/Details/5
public ActionResult Views(string Id)
{
try
{
var base64EncodedBytes = System.Convert.FromBase64String(Id);
var idDecrt = System.Text.Encoding.UTF8.GetString(base64EncodedBytes);
string[] paramList = idDecrt.Split("|");
int id = Convert.ToInt32(paramList[0].ToString());
ViewData["empNames"] = paramList[1].ToString();
TaskInquiryProvider taskInquiryProvider = new TaskInquiryProvider();
CreateEditViewModel model = new CreateEditViewModel();
var data = taskInquiryProvider.getView(id);
model.TaskID = data.Value.TaskID;
model.JenisTask = data.Value.JenisTask;
model.CustID = data.Value.CustID;
model.CustomerName = data.Value.CustomerName;
model.DistributedDate = data.Value.DistributedDate;
model.StartedDate = data.Value.StartedDate;
model.StatusDukcapil = data.Value.StatusDukcapil;
model.FieldPersonName = data.Value.FieldPersonName;
model.EmpPosition = data.Value.EmpPosition;
model.StatusProspek = data.Value.StatusProspek;
model.PriorityLevel = data.Value.PriorityLevel;
model.AplikasiIA = data.Value.AplikasiIA;
model.AplicationID = data.Value.AplicationID;
model.SourceData = data.Value.SourceData;
model.SourceData = data.Value.SourceData;
model.NIK = data.Value.NIK;
//---
model.TempatLahir = data.Value.TempatLahir;
model.TglLahir = data.Value.TglLahir;
model.AlamatLeg = data.Value.AlamatLeg;
model.ProvLeg = data.Value.ProvLeg;
model.KabLeg = data.Value.KabLeg;
model.KecLeg = data.Value.KecLeg;
model.KelLeg = data.Value.KelLeg;
model.RTLeg = data.Value.RTLeg;
model.RWLeg = data.Value.RWLeg;
model.AlamatRes = data.Value.AlamatRes;
model.ProvRes = data.Value.ProvRes;
model.KabRes = data.Value.KabRes;
model.KecRes = data.Value.KecRes;
model.KelRes = data.Value.KelRes;
model.RTRes = data.Value.RTRes;
model.RWRes = data.Value.RWRes;
model.KodePosRes = data.Value.KodePosRes;
model.SubZipcodeRes = data.Value.SubZipcodeRes;
model.Product = data.Value.Product;
model.ItemType = data.Value.ItemType;
model.ItemYear = data.Value.ItemYear;
model.OtrPrice = data.Value.OtrPrice;
model.DP = data.Value.DP;
model.LTV = data.Value.LTV;
model.Tenor = data.Value.Tenor;
model.Plafond = data.Value.Plafond;
model.MonthInstallment = data.Value.MonthInstallment;
model.Notes = data.Value.Notes;
model.KodePosLeg = data.Value.KodePosLeg;
model.SubZipcodeLeg = data.Value.SubZipcodeLeg;
return(View("CreateEdit", model));
}
catch (Exception ex)
{
return(View("~/Views/Shared/Error.cshtml"));
}
}
public IActionResult ExcelDetail(int pID, string pEmpNo)
{
using (var workbook = new XLWorkbook())
{
TaskInquiryProvider taskInquiryProvider = new TaskInquiryProvider();
var worksheet = workbook.Worksheets.Add("TASK INQUIRY");
var currentRow = 1;
worksheet.Cell(currentRow, 1).Value = "No";
worksheet.Cell(currentRow, 2).Value = "Branch Name";
worksheet.Cell(currentRow, 3).Value = "Region";
worksheet.Cell(currentRow, 4).Value = "Task ID";
worksheet.Cell(currentRow, 5).Value = "Jenis Task";
worksheet.Cell(currentRow, 6).Value = "Cust ID";
worksheet.Cell(currentRow, 7).Value = "Customer Name";
worksheet.Cell(currentRow, 8).Value = "Distributed Date";
worksheet.Cell(currentRow, 9).Value = "Started Date";
worksheet.Cell(currentRow, 10).Value = "Emp Position";
worksheet.Cell(currentRow, 11).Value = "SOA";
worksheet.Cell(currentRow, 12).Value = "Referantor 1";
worksheet.Cell(currentRow, 13).Value = "Regional_id";
worksheet.Cell(currentRow, 14).Value = "Product";
worksheet.Cell(currentRow, 15).Value = "Cab_Id";
worksheet.Cell(currentRow, 16).Value = "Nik Ktp";
worksheet.Cell(currentRow, 17).Value = "Tempat Lahir";
worksheet.Cell(currentRow, 18).Value = "Tanggal Lahir";
worksheet.Cell(currentRow, 19).Value = "Rw (Legal)";
worksheet.Cell(currentRow, 20).Value = "Provinsi (Legal)";
worksheet.Cell(currentRow, 21).Value = "Kabupaten (Legal)";
worksheet.Cell(currentRow, 22).Value = "Kecamatan (Legal)";
worksheet.Cell(currentRow, 23).Value = "Kelurahan (Legal)";
/////////////////////////////////////////////////////
worksheet.Cell(currentRow, 24).Value = "Kode Pos (Legal)";
worksheet.Cell(currentRow, 25).Value = "SubZipcode (Legal)";
/////////////////////////////////////////////////////
worksheet.Cell(currentRow, 26).Value = "Alamat (Survey)";
worksheet.Cell(currentRow, 27).Value = "Rt (Survey)";
worksheet.Cell(currentRow, 28).Value = "Rw (Survey)";
worksheet.Cell(currentRow, 29).Value = "Provinsi (Survey)";
worksheet.Cell(currentRow, 30).Value = "Kabupaten (Survey)";
worksheet.Cell(currentRow, 31).Value = "Kecamatan (Survey)";
worksheet.Cell(currentRow, 32).Value = "Kelurahan (Survey)";
/////////////////////////////////////////////////////
worksheet.Cell(currentRow, 33).Value = "Kode Pos (Survey)";
worksheet.Cell(currentRow, 34).Value = "SubZipcode (Survey)";
/////////////////////////////////////////////////////
worksheet.Cell(currentRow, 35).Value = "No_Mesin";
worksheet.Cell(currentRow, 36).Value = "No_Rangka";
worksheet.Cell(currentRow, 37).Value = "Item_Type";
worksheet.Cell(currentRow, 38).Value = "Item_Description";
worksheet.Cell(currentRow, 39).Value = "Mobile1";
worksheet.Cell(currentRow, 40).Value = "Mobile2";
worksheet.Cell(currentRow, 41).Value = "Phone1";
worksheet.Cell(currentRow, 42).Value = "Phone2";
worksheet.Cell(currentRow, 43).Value = "Office_Phone1";
worksheet.Cell(currentRow, 44).Value = "Office_Phone2";
worksheet.Cell(currentRow, 45).Value = "Otr_Price";
worksheet.Cell(currentRow, 46).Value = "Item_Year";
worksheet.Cell(currentRow, 47).Value = "Monthly_Income";
worksheet.Cell(currentRow, 48).Value = "Monthly_Installament";
worksheet.Cell(currentRow, 49).Value = "Down Payment Pengajuan";
worksheet.Cell(currentRow, 50).Value = "LTV Pengajuan";
///////////////////////////////////////////////////////
worksheet.Cell(currentRow, 51).Value = "Tenor Pengajuan";
///////////////////////////////////////////////////////
worksheet.Cell(currentRow, 52).Value = "Plafond Max";
worksheet.Cell(currentRow, 53).Value = "Pekerjaan";
worksheet.Cell(currentRow, 54).Value = "Sisa_Tenor";
worksheet.Cell(currentRow, 55).Value = "Realease_Date_Bpkb";
worksheet.Cell(currentRow, 56).Value = "Max_Past_Due_Dt";
worksheet.Cell(currentRow, 57).Value = "Religion";
worksheet.Cell(currentRow, 58).Value = "Customer_Rating";
worksheet.Cell(currentRow, 59).Value = "Tanggal_Jatuh_Tempo";
worksheet.Cell(currentRow, 60).Value = "Maturity_Dt";
worksheet.Cell(currentRow, 61).Value = "Status Call";
worksheet.Cell(currentRow, 62).Value = "Answer Call";
worksheet.Cell(currentRow, 63).Value = "Status Prospek";
worksheet.Cell(currentRow, 64).Value = "Reason Not Prospek";
worksheet.Cell(currentRow, 65).Value = "Notes";
var result = taskInquiryProvider.ListDownloadDetail(pID, pEmpNo);
foreach (var item in result)
{
currentRow++;
worksheet.Cell(currentRow, 1).Value = item.Number;
worksheet.Cell(currentRow, 2).Value = item.BranchName;
worksheet.Cell(currentRow, 3).Value = "'" + item.Region;
worksheet.Cell(currentRow, 4).Value = item.TaskID;
worksheet.Cell(currentRow, 5).Value = item.JenisTask;
worksheet.Cell(currentRow, 6).Value = "'" + item.CustID;
worksheet.Cell(currentRow, 7).Value = item.CustomerName;
try
{
worksheet.Cell(currentRow, 8).Value = "'" + Convert.ToDateTime(item.DistributedDate).ToString("dd/MM/yyyy HH:mm:ss.mmm");
}
catch
{
worksheet.Cell(currentRow, 8).Value = "'" + item.DistributedDate;
}
try
{
worksheet.Cell(currentRow, 9).Value = "'" + Convert.ToDateTime(item.StartedDate).ToString("dd/MM/yyyy HH:mm:ss.mmm");
}
catch
{
worksheet.Cell(currentRow, 9).Value = "'" + item.StartedDate;
}
worksheet.Cell(currentRow, 10).Value = item.EmpPosition;
worksheet.Cell(currentRow, 11).Value = item.soa;
worksheet.Cell(currentRow, 12).Value = "'" + item.Referentor1;
worksheet.Cell(currentRow, 13).Value = "'" + item.RegionalId;
worksheet.Cell(currentRow, 14).Value = item.Product;
worksheet.Cell(currentRow, 15).Value = "'" + item.CabId;
worksheet.Cell(currentRow, 16).Value = "'" + item.NIK;
worksheet.Cell(currentRow, 17).Value = item.TempatLahir;
try
{
worksheet.Cell(currentRow, 18).Value = "'" + Convert.ToDateTime(item.TglLahir).ToString("dd/MM/yyyy");
}
catch
{
worksheet.Cell(currentRow, 18).Value = "'" + item.TglLahir;
}
worksheet.Cell(currentRow, 19).Value = "'" + item.RWLeg;
worksheet.Cell(currentRow, 20).Value = item.ProvLeg;
worksheet.Cell(currentRow, 21).Value = item.KabLeg;
worksheet.Cell(currentRow, 22).Value = item.KecLeg;
worksheet.Cell(currentRow, 23).Value = item.KelLeg;
worksheet.Cell(currentRow, 24).Value = "'" + item.KodeposLeg;
worksheet.Cell(currentRow, 25).Value = "'" + item.SubZipcodeLeg;
worksheet.Cell(currentRow, 26).Value = item.AlamatRes;
worksheet.Cell(currentRow, 27).Value = "'" + item.RTRes;
worksheet.Cell(currentRow, 28).Value = "'" + item.RWRes;
worksheet.Cell(currentRow, 29).Value = item.ProvRes;
worksheet.Cell(currentRow, 30).Value = item.KabRes;
worksheet.Cell(currentRow, 31).Value = item.KecRes;
worksheet.Cell(currentRow, 32).Value = item.KelRes;
worksheet.Cell(currentRow, 33).Value = "'" + item.KodeposRes;
worksheet.Cell(currentRow, 34).Value = "'" + item.SubZipcodeRes;
worksheet.Cell(currentRow, 35).Value = item.NoMesin;
worksheet.Cell(currentRow, 36).Value = item.NoRangka;
worksheet.Cell(currentRow, 37).Value = item.ItemType;
worksheet.Cell(currentRow, 38).Value = item.ItemDescription;
worksheet.Cell(currentRow, 39).Value = "'" + item.Mobile1;
worksheet.Cell(currentRow, 40).Value = "'" + item.Mobile2;
worksheet.Cell(currentRow, 41).Value = "'" + item.Phone1;
worksheet.Cell(currentRow, 42).Value = "'" + item.Phone2;
worksheet.Cell(currentRow, 43).Value = "'" + item.OfficePhone1;
worksheet.Cell(currentRow, 44).Value = "'" + item.OfficePhone2;
worksheet.Cell(currentRow, 45).Value = item.OtrPrice;
worksheet.Cell(currentRow, 46).Value = item.ItemYear;
worksheet.Cell(currentRow, 47).Value = item.MonthlyIncome;
worksheet.Cell(currentRow, 48).Value = item.MonthInstallment;
worksheet.Cell(currentRow, 49).Value = item.DP;
worksheet.Cell(currentRow, 50).Value = item.LTV;
worksheet.Cell(currentRow, 51).Value = "'" + item.TenorId;
worksheet.Cell(currentRow, 52).Value = item.Plafond;
worksheet.Cell(currentRow, 53).Value = item.Pekerjaan;
worksheet.Cell(currentRow, 54).Value = item.SisaTenor;
try
{
worksheet.Cell(currentRow, 55).Value = "'" + Convert.ToDateTime(item.ReleaseDateBpkb).ToString("dd/MM/yyyy");
}
catch
{
worksheet.Cell(currentRow, 55).Value = "'" + item.ReleaseDateBpkb;
}
worksheet.Cell(currentRow, 56).Value = "'" + item.MaxPastDueDt;
worksheet.Cell(currentRow, 57).Value = item.Religion;
worksheet.Cell(currentRow, 58).Value = item.CustomerRating;
try
{
worksheet.Cell(currentRow, 59).Value = "'" + Convert.ToDateTime(item.TanggalJatuhTempo).ToString("dd/MM/yyyy");
}
catch
{
worksheet.Cell(currentRow, 59).Value = "'" + item.TanggalJatuhTempo;
}
try
{
worksheet.Cell(currentRow, 60).Value = "'" + Convert.ToDateTime(item.MaturityDt).ToString("dd/MM/yyyy");
}
catch
{
worksheet.Cell(currentRow, 60).Value = "'" + item.MaturityDt;
}
worksheet.Cell(currentRow, 61).Value = item.StatusCall;
worksheet.Cell(currentRow, 62).Value = item.AnswerCall;
worksheet.Cell(currentRow, 63).Value = item.StatusProspek;
worksheet.Cell(currentRow, 64).Value = item.ReasonNotProspek;
worksheet.Cell(currentRow, 65).Value = item.Notes;
}
var type = taskInquiryProvider.validasiUserType(pEmpNo);
using (var stream = new MemoryStream())
{
workbook.SaveAs(stream);
var content = stream.ToArray();
return(File(
content,
"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
pEmpNo + "_" + type + "_" + DateTime.Now.ToString("yyyyMMdd") + ".xlsx"));
}
}
}
