public ActionResult _PopulatePekerjaanFromFile(HttpPostedFileBase file, int IdPekerjaanHeader)
{
bool bolImported = false;
int intBarisMulaiData = 0;
int intKolomMulaiData = 0;
try
{
intBarisMulaiData = Convert.ToInt16(ConfigurationManager.AppSettings["BarisDataXLS_Pek"]);
}
catch (Exception ex)
{ }
try
{
intKolomMulaiData = Convert.ToInt16(ConfigurationManager.AppSettings["KolomDataXLS_Pek"]);
}
catch (Exception ex)
{ }
Guid gdPointer = Guid.NewGuid();
if (Request.Files["file"].ContentLength > 0)
{
string fileExtension = System.IO.Path.GetExtension(Request.Files["file"].FileName);
string strFileName = gdPointer.ToString() + fileExtension;
string fileLocation = Server.MapPath("~/Content/FileUpload/") + strFileName;
if (System.IO.File.Exists(fileLocation))
{
System.IO.File.Delete(fileLocation);
}
Request.Files["file"].SaveAs(fileLocation);
bolImported = ImportXLSHelper.ImportXLS(4, gdPointer, (Guid)tokenContainer.IdRekananContact, intBarisMulaiData, intKolomMulaiData, strFileName, fileExtension, fileLocation);
ViewBag.Message = string.Format("Proses import {0}", "Berhasil");
//populate form header and grid from temp table
trxDetailPekerjaanHeaderForm myDataForm = new trxDetailPekerjaanHeaderForm();
//populate grid data
List <trxDetailPekerjaan> myDataList = new List <trxDetailPekerjaan>();
HttpResponseMessage responseMessage = client.GetAsync(urlDetailTMP + "/GetByGuidHeader/" + gdPointer.ToString()).Result;
if (responseMessage.IsSuccessStatusCode)
{
var responseData = responseMessage.Content.ReadAsStringAsync().Result;
myDataList = JsonConvert.DeserializeObject <List <trxDetailPekerjaan> >(responseData);
}
myDataForm.PekerjaanColls = myDataList;
myDataForm.IdPekerjaanHeader = IdPekerjaanHeader;
myDataForm.GuidHeader = gdPointer;
myDataForm.IdRekanan = (Guid)tokenContainer.IdRekananContact;
ViewBag.GuidHeader = gdPointer;
return(View("AddEditPekerjaanHeader", myDataForm));
}
return(View("Error"));
}
public trxDetailPekerjaanHeaderForm GetByGuidHeader(System.Guid GuidHeader)
{
trxDetailPekerjaanHeaderForm myDataForm = new trxDetailPekerjaanHeaderForm();
trxDetailPekerjaanHeader myData = _repDetailPek.GetByGuidHeader(GuidHeader);
myDataForm.InjectFrom(myData);
IEnumerable <trxDetailPekerjaan> myDataList = _repDetail.GetByGuidHeader(GuidHeader);
myDataForm.PekerjaanColls = myDataList;
return(myDataForm);
}
public trxDetailPekerjaanHeaderForm GetByGuidHeaderAS_1M(System.Guid GuidHeader)
{
trxDetailPekerjaanHeaderForm myDataForm = new trxDetailPekerjaanHeaderForm();
trxDetailPekerjaanHeader myData = _repDetailPek.GetByGuidHeader(GuidHeader);
myDataForm.InjectFrom(myData);
IEnumerable <trxDetailPekerjaanAS_1M> myDataList = _repDetailAS_1M.GetByGuidHeader(GuidHeader);
myDataForm.PekerjaanAS_1MColls = myDataList;
myDataForm.SubRegionColls = _repSubRegion.Get();
myDataForm.TypeOfSegmentasi5Colls = _repSegmen.Get();
return(myDataForm);
}
public async Task <ActionResult> AddEditPekerjaanHeader(Guid GuidHeader)
{
trxDetailPekerjaanHeaderForm myDataForm = new trxDetailPekerjaanHeaderForm();
if ((int)tokenContainer.IdTypeOfRekanan == 4 || (int)tokenContainer.IdTypeOfRekanan == 5)
{
if (GuidHeader != null && GuidHeader != Guid.Empty)
{
HttpResponseMessage responseMessage = await client.GetAsync(url + "/GetByGuidHeaderAS_1M/" + GuidHeader.ToString());
if (responseMessage.IsSuccessStatusCode)
{
var responseData = responseMessage.Content.ReadAsStringAsync().Result;
myDataForm = JsonConvert.DeserializeObject <trxDetailPekerjaanHeaderForm>(responseData);
ViewBag.GuidHeader = GuidHeader;
ViewBag.JudulDaftarTenaga = "Data Pekerjaan Asuransi Bulanan";
return(View("AddEditPekerjaanAS_1MHeader", myDataForm));
}
}
else
{
myDataForm.IdPekerjaanHeader = -1;
ViewBag.GuidHeader = Guid.Empty;
return(View("AddEditPekerjaanAS_1MHeader", myDataForm));
}
}
else
{
if (GuidHeader != null && GuidHeader != Guid.Empty)
{
HttpResponseMessage responseMessage = await client.GetAsync(url + "/GetByGuidHeader/" + GuidHeader.ToString());
if (responseMessage.IsSuccessStatusCode)
{
var responseData = responseMessage.Content.ReadAsStringAsync().Result;
myDataForm = JsonConvert.DeserializeObject <trxDetailPekerjaanHeaderForm>(responseData);
ViewBag.GuidHeader = GuidHeader;
ViewBag.JudulDaftarTenaga = "Data Tenaga Ahli Tetap";
return(View("AddEditPekerjaanHeader", myDataForm));
}
}
else
{
myDataForm.IdPekerjaanHeader = -1;
ViewBag.GuidHeader = Guid.Empty;
return(View("AddEditPekerjaanHeader", myDataForm));
}
}
return(View("Error"));
}
public async Task <ActionResult> _AddEditPekerjaanAS_1MHeader(Guid GuidHeader)
{
trxDetailPekerjaanHeaderForm myDataForm = new trxDetailPekerjaanHeaderForm();
if (GuidHeader != null && GuidHeader != Guid.Empty)
{
HttpResponseMessage responseMessage = await client.GetAsync(url + "/GetByGuidHeaderAS_1M/" + GuidHeader.ToString());
if (responseMessage.IsSuccessStatusCode)
{
var responseData = responseMessage.Content.ReadAsStringAsync().Result;
myDataForm = JsonConvert.DeserializeObject <trxDetailPekerjaanHeaderForm>(responseData);
ViewBag.GuidHeader = GuidHeader;
//ViewBag.JudulDaftarTenaga = "Data Pekerjaan Asuransi Bulanan";
return(PartialView("_AddEditPekerjaanAS_1MHeader", myDataForm));
}
}
return(View("Error"));
}
//public IEnumerable<trxDetailPekerjaanAS_1MTMP> GetByGuidHeader(System.Guid GuidHeader)
public trxDetailPekerjaanHeaderForm GetByGuidHeader(System.Guid GuidHeader)
{
trxDetailPekerjaanHeaderForm myDataForm = new trxDetailPekerjaanHeaderForm();
List <trxDetailPekerjaanAS_1M> DetailPekByGuidHeaderNew = new List <trxDetailPekerjaanAS_1M>();
IEnumerable <trxDetailPekerjaanAS_1MTMP> DetailPekByGuidHeader;
DetailPekByGuidHeader = _repDetailPek.GetByGuidHeader(GuidHeader);
foreach (trxDetailPekerjaanAS_1MTMP item in DetailPekByGuidHeader)
{
trxDetailPekerjaanAS_1M newItem = new trxDetailPekerjaanAS_1M();
newItem.InjectFrom(item);
DetailPekByGuidHeaderNew.Add(newItem);
}
myDataForm.PekerjaanAS_1MColls = DetailPekByGuidHeaderNew;
myDataForm.SubRegionColls = _repSubRegion.Get();
myDataForm.TypeOfSegmentasi5Colls = _repSegmen.Get();
return(myDataForm);
//IEnumerable<trxDetailPekerjaanAS_1MTMP> DetailPekByGuidHeader;
//DetailPekByGuidHeader = _repDetailPek.GetByGuidHeader(GuidHeader);
//return DetailPekByGuidHeader;
}
public async Task <ActionResult> AddEditPekerjaanHeader(trxDetailPekerjaanHeaderForm myDataForm)
{
string strXLSPointer = myDataForm.GuidHeader.ToString();
string strReqToExecTransData = string.Empty;
trxDetailPekerjaanHeader myData = new trxDetailPekerjaanHeader();
myData.InjectFrom(myDataForm);
//pindahkan data temporary import XLS ke fix table berdasarkan XLS pointer guid
if (strXLSPointer != string.Empty)
{
if ((int)tokenContainer.IdTypeOfRekanan == 4 || (int)tokenContainer.IdTypeOfRekanan == 5)
{
strReqToExecTransData = string.Format("{0}/ExecTransDataPekAS_1M/{1}", url, strXLSPointer);
}
else
{
strReqToExecTransData = string.Format("{0}/ExecTransDataPek/{1}", url, strXLSPointer);
}
HttpResponseMessage responseMessageXLS = await client.GetAsync(strReqToExecTransData);
if (!responseMessageXLS.IsSuccessStatusCode)
{
return(RedirectToAction("Error"));
}
}
myData.JudulDokumen = string.Format("Diupload tanggal : {0}", DateTime.Now.ToString("yyyy-MM-dd HH:mm"));
if (myData.IdPekerjaanHeader > 0)
{
HttpResponseMessage responseMessage = await client.PutAsJsonAsync(url + "/" + myData.IdPekerjaanHeader, myData);
if (responseMessage.IsSuccessStatusCode)
{
if ((int)tokenContainer.SupervisorId > 0)
{
return(RedirectToAction("RekananDetailedInfo", new RouteValueDictionary(
new
{
controller = "MstRekanan",
action = "RekananDetailedInfo",
IdRekanan = tokenContainer.IdRekananContact.ToString()
,
IdTypeOfRekanan = (int)tokenContainer.IdTypeOfRekanan
})));
}
else
{
return(RedirectToAction("GetByRekanan", "TrxDetailPekerjaanHeader"));
}
}
return(RedirectToAction("Error"));
}
else
{
//myData.IdRekanan = (Guid)tokenContainer.IdRekananContact;
myData.CreatedDate = DateTime.Today;
myData.CreatedUser = tokenContainer.UserId.ToString();
HttpResponseMessage responseMessage = await client.PostAsJsonAsync(url, myData);
if (responseMessage.IsSuccessStatusCode)
{
if ((int)tokenContainer.SupervisorId > 0)
{
return(RedirectToAction("RekananDetailedInfo", new RouteValueDictionary(
new
{
controller = "MstRekanan",
action = "RekananDetailedInfo",
IdRekanan = tokenContainer.IdRekananContact.ToString()
,
IdTypeOfRekanan = (int)tokenContainer.IdTypeOfRekanan
})));
}
else
{
return(RedirectToAction("GetByRekanan", "TrxDetailPekerjaanHeader"));
}
}
return(RedirectToAction("Error"));
}
}
