public ActionResult _PopulateBranchFromFile(HttpPostedFileBase file, int IdBranchHeader)
{
bool bolImported = false;
int intBarisMulaiData = 0;
int intKolomMulaiData = 0;
try
{
intBarisMulaiData = Convert.ToInt16(ConfigurationManager.AppSettings["BarisDataXLS_Branch"]);
}
catch (Exception ex)
{ }
try
{
intKolomMulaiData = Convert.ToInt16(ConfigurationManager.AppSettings["KolomDataXLS_Branch"]);
}
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(6, 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
trxBranchOfficeHeaderForm myDataForm = new trxBranchOfficeHeaderForm();
//populate grid data
List <trxBranchOffice> myDataList = new List <trxBranchOffice>();
HttpResponseMessage responseMessage = client.GetAsync(urlBranchTMP + "/GetByGuidHeader/" + gdPointer.ToString()).Result;
if (responseMessage.IsSuccessStatusCode)
{
var responseData = responseMessage.Content.ReadAsStringAsync().Result;
myDataList = JsonConvert.DeserializeObject <List <trxBranchOffice> >(responseData);
}
myDataForm.BranchOfficeColls = myDataList;
myDataForm.IdBranchHeader = IdBranchHeader;
myDataForm.GuidHeader = gdPointer;
myDataForm.IdRekanan = (Guid)tokenContainer.IdRekananContact;
ViewBag.GuidHeader = gdPointer;
return(View("AddEditBranchHeader", myDataForm));
}
return(View("Error"));
}
public trxBranchOfficeHeaderForm GetByGuidHeader(System.Guid GuidHeader)
{
trxBranchOfficeHeaderForm myDataForm = new trxBranchOfficeHeaderForm();
trxBranchOfficeHeader myData = _repBranchHeader.GetByGuidHeader(GuidHeader);
myDataForm.InjectFrom(myData);
IEnumerable <trxBranchOffice> myDataList = _repBranch.GetByGuidHeader(GuidHeader);
myDataForm.BranchOfficeColls = myDataList;
return(myDataForm);
}
public async Task <ActionResult> AddEditBranchHeader(trxBranchOfficeHeaderForm myDataForm)
{
string strXLSPointer = myDataForm.GuidHeader.ToString();
string strReqToExecTransData = string.Empty;
trxBranchOfficeHeader myData = new trxBranchOfficeHeader();
myData.InjectFrom(myDataForm);
//pindahkan data temporary import XLS ke fix table berdasarkan XLS pointer guid
if (strXLSPointer != string.Empty)
{
strReqToExecTransData = string.Format("{0}/ExecTransBranch/{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.IdBranchHeader > 0)
{
HttpResponseMessage responseMessage = await client.PutAsJsonAsync(url + "/" + myData.IdBranchHeader, myData);
if (responseMessage.IsSuccessStatusCode)
{
return(RedirectToAction("GetByRekananTab", "TrxDocMandatoryDetail"));
}
return(RedirectToAction("Error"));
}
else
{
myData.CreatedDate = DateTime.Today;
myData.CreatedUser = tokenContainer.UserId.ToString();
HttpResponseMessage responseMessage = await client.PostAsJsonAsync(url, myData);
if (responseMessage.IsSuccessStatusCode)
{
return(RedirectToAction("GetByRekananTab", "TrxDocMandatoryDetail"));
}
return(RedirectToAction("Error"));
}
}
