private async void BtnSimpan_Click(object sender, EventArgs e)
{
try
{
var db = new smlpobDB();
var newDetail = db.orderanalysisdetailtbls.Where(x => x.sampleNo == txtNoBalitTanah.Text && x.elementId.ToString() == CmbParameter.SelectedValue).FirstOrDefault();
if (FileUploadManual.HasFile && newDetail != null)
{
string nameFile = "manual_" + CommonWeb.GetCurrentUser()
+ "_" + DateTime.Now.ToString("ddMMMyyyy")
+ "_" + shortid.ShortId.Generate(true, false)
+ Path.GetExtension(FileUploadManual.FileName);
await CloudStorage.BlobPostAsync(FileUploadManual.FileBytes, nameFile);
newDetail.fileName = nameFile;
newDetail.fileAttachmentUrl = ConfigurationManager.AppSettings["DefaultBlobRootUrl"] + nameFile;
}
else
{
CommonWeb.Alert(this, "Silakan lampirkan file perhitungan terlebih dahulu.");
return;
}
if (FileUploadAlat.HasFile && newDetail != null)
{
string nameFile = "alat_" + CommonWeb.GetCurrentUser()
+ "_" + DateTime.Now.ToString("ddMMMyyyy")
+ "_" + shortid.ShortId.Generate(true, false)
+ Path.GetExtension(FileUploadAlat.FileName);
await CloudStorage.BlobPostAsync(FileUploadAlat.FileBytes, nameFile);
newDetail.LabToolFileName = nameFile;
newDetail.LabToolAttachmentUrl = ConfigurationManager.AppSettings["DefaultBlobRootUrl"] + nameFile;
}
if (newDetail != null)
{
newDetail.modDate = DateTime.Now;
newDetail.modBy = CommonWeb.GetCurrentUser();
newDetail.status = "Diproses";
await db.SaveChangesAsync();
ChangeOrderMasterStatus();
LoadData(txtNoBalitTanah.Text);
CommonWeb.Alert(this, "Data telah tersimpan");
}
else
{
CommonWeb.Alert(this, "Gagal menyimpan, terjadi kesalahan.");
}
}
catch (Exception ex)
{
LogHelpers.source = this.GetType().ToString();
LogHelpers.message = "failed to post input parameter:" + ex.Message;
LogHelpers.user = CommonWeb.GetCurrentUser();
LogHelpers.WriteLog();
}
}
protected async void BtnSave_Click(object sender, EventArgs e)
{
try
{
var UploadFolder = HttpContext.Current.Server.MapPath("/Uploads");
string nameFile = userId + "_" + DateTime.Now.ToString("ddMMMyyyy") + Path.GetExtension(FileUpload1.FileName);
//var fileName = Guid.NewGuid().ToString().Replace("-", "_") + Path.GetExtension(FileUpload1.FileName);
var fullName = UploadFolder + "\\" + nameFile;
if (FileUpload1.HasFile)
{
await CloudStorage.BlobPostAsync(FileUpload1.FileBytes, nameFile);
var newDetail = new orderanalysisdetailtbl()
{
};
newDetail.fileName = nameFile;
newDetail.fileAttachmentUrl = ConfigurationManager.AppSettings["DefaultBlobRootUrl"] + nameFile;
newDetail.modDate = DateTime.Now;
newDetail.modBy = CommonWeb.GetCurrentUser();
newDetail.orderDetailNo = Convert.ToInt32(txtOrderDetailNo.Text);
var NewItem = new parameterstbl()
{
};
NewItem.string0 = txtBerat.Text;
NewItem.string1 = txtFP.Text;
NewItem.modDate = DateTime.Now;
context.parameterstbls.Add(NewItem);
using (var context = new smlpobDB())
{
context.orderanalysisdetailtbls.Attach(newDetail);
context.Entry(newDetail).Property(x => x.fileAttachmentUrl).IsModified = true;
context.Entry(newDetail).Property(x => x.fileName).IsModified = true;
await context.SaveChangesAsync();
}
context.SaveChanges();
await CloudStorage.BlobPostAsync(FileUpload1.FileBytes, nameFile);
TxtStatus.Text = "Berhasil";
//FileUpload1.SaveAs(fullName);
}
}
catch (Exception ex)
{
TxtStatus.Text = "gagal save --> " + ex.Message;
}
}
async void Simpan()
{
if (!FileUpload1.HasFile)
{
CommonWeb.Alert(this, "Silakan pilih file yang mau di upload terlebih dahulu");
}
else
{
using (var db = new smlpobDB())
{
var batchData = (from x in db.batchtbls
where x.batchId == BatchID
select x).FirstOrDefault();
if (batchData != null)
{
string nameFile = "batch_" + CommonWeb.GetCurrentUser()
+ "_" + DateTime.Now.ToString("ddMMMyyyy")
+ "_" + shortid.ShortId.Generate(true, false)
+ Path.GetExtension(FileUpload1.FileName);
await CloudStorage.BlobPostAsync(FileUpload1.FileBytes, nameFile);
batchData.filename = nameFile;
batchData.fileurl = ConfigurationManager.AppSettings["DefaultBlobRootUrl"] + nameFile;
batchData.status = "Selesai";
}
var orderNos = (from x in db.ordermastertbls
where x.batchId == BatchID
select x).ToList();
foreach (var item in orderNos)
{
item.status = Status.OrderStatus[4];
var analysis = from x in db.orderanalysisdetailtbls
where x.orderNo == item.orderNo
select x;
foreach (var item2 in analysis)
{
item2.status = "Diproses";
}
}
db.SaveChanges();
Response.Redirect("AnalisBeranda.aspx");
}
}
}
private async void DoUpload()
{
if (FileUpload1.HasFile)
{
/*
* var FilePath = Server.MapPath("~/Uploads");
* if (!Directory.Exists(FilePath))
* {
* Directory.CreateDirectory(FilePath);
* }
* var ItemName = Guid.NewGuid().ToString().Replace("-", "_") + Path.GetExtension(FileUpload1.FileName);
* var FileName = FilePath + "\\" + ItemName;
* FileUpload1.SaveAs(FileName);
*/
string nameFile = "LHP_" + CommonWeb.GetCurrentUser() + "_" + DateTime.Now.ToString("ddMMMyyyy") + "_" + shortid.ShortId.Generate(true, false) + Path.GetExtension(FileUpload1.FileName);
await CloudStorage.BlobPostAsync(FileUpload1.FileBytes, nameFile);
var FileUrl = ConfigurationManager.AppSettings["DefaultBlobRootUrl"] + nameFile;
string orderNo = txtNoOrder.Text;
var rett = orderControls.MasterData(orderNo);
var dataOrder = rett.Result;
var data = new ordermastertbl
{
orderNo = dataOrder.orderNo,
customerNo = dataOrder.customerNo,
comodityNo = dataOrder.comodityNo,
analysisType = dataOrder.analysisType,
sampleTotal = dataOrder.sampleTotal,
priceTotal = dataOrder.priceTotal,
statusType = dataOrder.statusType,
status = dataOrder.status,
paymentStatus = dataOrder.paymentStatus,
ppn = dataOrder.ppn,
receiptDate = dataOrder.receiptDate,
isPaid = dataOrder.isPaid,
paymentDate = dataOrder.paymentDate,
pic = dataOrder.pic,
isOnLab = dataOrder.isOnLab,
ApprPenyelia = dataOrder.ApprPenyelia,
ApprEvaluator = dataOrder.ApprEvaluator,
ApprManagerTeknis = dataOrder.ApprManagerTeknis,
LHPAttachmentUrl = FileUrl,
LHPFileName = nameFile,
EvaluationFileUrl = dataOrder.EvaluationFileUrl,
EvaluationFileName = dataOrder.EvaluationFileName
};
var ret = orderControls.UpdateData(orderNo, data);
if (ret.Result)
{
this.orderNo = Request.QueryString["orderNo"];
LoadHeaderInfo(this.orderNo);
LoadGridSample(this.orderNo);
CommonWeb.Alert(this, "File berhasil diupload");
Response.Redirect("DaftarPesanan.aspx");
}
else
{
CommonWeb.Alert(this, "Gagal upload file");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
var Filter = Request.QueryString["Filter"];
if (Filter == "Filter1")
{
BtnLanjut.Visible = true;
BtnHitungUlang.Visible = true;
BtnDownloadZip.Visible = true;
BtnUploadZip.Visible = true;
DivUploadLampiran.Visible = true;
DivDownloadLampiran.Visible = true;
BtnQR.Visible = true;
}
else
{
BtnLanjut.Visible = false;
BtnHitungUlang.Visible = false;
BtnUploadZip.Visible = false;
DivUploadLampiran.Visible = false;
BtnQR.Visible = false;
}
orderNo = Request.QueryString["orderNo"];
LoadHeaderInfo(orderNo);
LoadGridSample(orderNo);
}
BtnDownload.Click += BtnDownload_Click;
BtnDownloadKalkulasi.Click += BtnDownloadKalkulasi_Click;
BtnTutup.Click += BtnTutup_Click;
GvData.RowCommand += GvData3_RowCommand;
GvParameter.RowCommand += GvParameter_RowCommand;
BtnUpload.Click += (a, b) => { DoUpload(); };
BtnUploadKalkulasi.Click += async(a, b) => {
if (FileUploadKalkulasi.HasFile)
{
/*
* var FilePath = Server.MapPath("~/Uploads");
* if (!Directory.Exists(FilePath))
* {
* Directory.CreateDirectory(FilePath);
* }
* var ItemName = Guid.NewGuid().ToString().Replace("-", "_") + Path.GetExtension(FileUpload1.FileName);
* var FileName = FilePath + "\\" + ItemName;
* FileUpload1.SaveAs(FileName);
*/
string nameFile = "LampiranLHP_" + CommonWeb.GetCurrentUser() + "_" + DateTime.Now.ToString("ddMMMyyyy") + "_" + shortid.ShortId.Generate(true, false) + Path.GetExtension(FileUploadKalkulasi.FileName);
await CloudStorage.BlobPostAsync(FileUploadKalkulasi.FileBytes, nameFile);
var FileUrl = ConfigurationManager.AppSettings["DefaultBlobRootUrl"] + nameFile;
string id = txtNoOrder.Text;
var rett = orderControls.MasterData(id);
var datas = rett.Result;
var data = new ordermastertbl
{
orderNo = datas.orderNo,
customerNo = datas.customerNo,
comodityNo = datas.comodityNo,
analysisType = datas.analysisType,
sampleTotal = datas.sampleTotal,
priceTotal = datas.priceTotal,
statusType = datas.statusType,
status = datas.status,
paymentStatus = datas.paymentStatus,
ppn = datas.ppn,
receiptDate = datas.receiptDate,
isPaid = datas.isPaid,
paymentDate = datas.paymentDate,
pic = datas.pic,
isOnLab = datas.isOnLab,
ApprPenyelia = datas.ApprPenyelia,
ApprEvaluator = datas.ApprEvaluator,
ApprManagerTeknis = datas.ApprManagerTeknis,
LHPAttachmentUrl = datas.LHPAttachmentUrl,
LHPFileName = datas.LHPFileName,
EvaluationFileUrl = datas.EvaluationFileUrl,
EvaluationFileName = datas.EvaluationFileName,
CalculationFileUrl = FileUrl,
CalculationFilename = nameFile
};
var ret = orderControls.UpdateData(id, data);
if (ret.Result)
{
orderNo = Request.QueryString["orderNo"];
LoadHeaderInfo(orderNo);
LoadGridSample(orderNo);
CommonWeb.Alert(this, "File lampiran berhasil diupload");
//Response.Redirect("DaftarPesanan.aspx");
}
else
{
CommonWeb.Alert(this, "Gagal upload file");
}
}
};
this.GvData.DataBound += (object o, EventArgs ev) =>
{
GvData.HeaderRow.TableSection = TableRowSection.TableHeader;
};
}
protected void Page_Load(object sender, EventArgs e)
{
BtnUpload.Click += async(a, b) => {
if (!FileUpload1.HasFile)
{
CommonWeb.Alert(this, "Silakan pilih file bukti pembayaran terlebih dahulu.");
return;
}
//upload file
//var pathTarget = Server.MapPath("~/Document/Payment");
//var tempFile = shortid.ShortId.Generate(true, false, 10)+Path.GetExtension(FileUpload1.FileName);
//var fileName = pathTarget + "//" + tempFile;
string nameFile = "payment_" + CommonWeb.GetCurrentUser()
+ "_" + DateTime.Now.ToString("ddMMMyyyy")
+ "_" + shortid.ShortId.Generate(true, false)
+ Path.GetExtension(FileUpload1.FileName);
await CloudStorage.BlobPostAsync(FileUpload1.FileBytes, nameFile);
var fileurl = ConfigurationManager.AppSettings["DefaultBlobRootUrl"] + nameFile;
HidUrlBukti.Value = fileurl;
ImgLampiran.Src = fileurl;
ImgLampiran.Visible = true;
};
BtnCancel.Click += (a, b) => { Response.Redirect("CustomerBeranda.aspx"); };
BtnSave.Click += async(a, b) =>
{
if (string.IsNullOrEmpty(HidUrlBukti.Value))
{
CommonWeb.Alert(this, "Silakan upload bukti pembayaran terlebih dahulu.");
return;
}
var LampiranUrl = "";
if (FileUploadLampiran.HasFile)
{
string nameFile = "lampiran_bayar_" + CommonWeb.GetCurrentUser()
+ "_" + DateTime.Now.ToString("ddMMMyyyy")
+ "_" + shortid.ShortId.Generate(true, false)
+ Path.GetExtension(FileUploadLampiran.FileName);
await CloudStorage.BlobPostAsync(FileUploadLampiran.FileBytes, nameFile);
var urllampiran = ConfigurationManager.AppSettings["DefaultBlobRootUrl"] + nameFile;
LampiranUrl = urllampiran;
}
var fileurl = HidUrlBukti.Value;
using (var db = new smlpobDB())
{
var newItem = new paymenttbl()
{
attachmentUrl = LampiranUrl, accountName = TxtNamaRekening.Text, accountNo = TxtNoRekening.Text, amount = Convert.ToDecimal(TxtJumlahTransfer.Text), bankName = CmbBankPengirim.SelectedValue, name = lblcusname.Text, orderNo = lblnoPesanan.Text, paymentReceiptUrl = fileurl, status = Status.PaymentStatus[1]
};
var orderNo = lblnoPesanan.Text;
if (!string.IsNullOrEmpty(orderNo))
{
var dataOrder = (from x in db.ordermastertbls.Include(c => c.comoditytbl)
where x.orderNo == orderNo
select x).FirstOrDefault();
if (dataOrder != null)
{
if (Convert.ToDecimal(TxtJumlahTransfer.Text) < Convert.ToDecimal(LitTotBiaya.Text))
{
CommonWeb.Alert(this, "Nilai yang ditransfer harus sesuai.");
return;
}
dataOrder.paymentStatus = Status.PaymentStatus[1];
db.paymenttbls.Add(newItem);
await db.SaveChangesAsync();
CommonWeb.Alert(this, "Pembayaran di proses");
BtnSave.Visible = false;
}
CommonWeb.Alert(this, "Gagal proses, terjadi kesalahan");
}
}
};
if (!IsPostBack)
{
string[] Banks =
{
"Bank Rakyat Indonesia (BRI)",
"Bank Mandiri",
"Bank Central Asia (BCA)",
"Bank Negara Indonesia (BNI)",
"Bank Tabungan Negara (BTN)",
"Bank CIMB Niaga",
"Bank Panin",
"Bank OCBC NISP",
"Bank Danamon Indonesia",
"Bank Permata",
"Bank Maybank Indonesia",
"Lainnya"
};
CmbBankPengirim.DataSource = Banks;
CmbBankPengirim.DataBind();
GetTranslation();
var orderNo = Request.QueryString["orderNo"];
if (!string.IsNullOrEmpty(orderNo))
{
using (var db = new smlpobDB())
{
var dataOrder = (from x in db.ordermastertbls.Include(c => c.comoditytbl)
where x.orderNo == orderNo
select x).FirstOrDefault();
if (dataOrder != null)
{
lblTanggal.Text = dataOrder.creaDate?.ToString("MM-dd-yyyy");
lblnoPesanan.Text = dataOrder.orderNo;
lblKomoditas.Text = dataOrder.comoditytbl.comodityName;
lbljenisAnalisis.Text = dataOrder.analysisType;
var uname = CommonWeb.GetCurrentUser();
var cust = (from x in db.customertbls
where x.customerEmail == uname
select x).FirstOrDefault();
if (cust != null)
{
lblcusname.Text = cust.customerName;
lblInstansi.Text = cust.companyName;
}
var dataDetail = from x in db.orderanalysisdetailtbls
where x.orderNo == orderNo
select new { x.elementId };
var totalParam = dataDetail.Distinct().Count();
LitJmlParamUji.Text = totalParam.ToString("n0");
LitJmlSampel.Text = dataOrder.sampleTotal?.ToString("n0");
LitTotBiaya.Text = dataOrder.priceTotal?.ToString("n0");
}
}
}
else
{
CommonWeb.Alert(this, "Tidak ada order no - tidak ada order yang bisa di bayar");
}
}
}
