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