private void DoSaveOrMas() { var data = new ordermastertbl { comodityNo = Convert.ToInt32(DDLComodity.SelectedValue), analysisType = DDLAnalysis.SelectedValue, }; foreach (GridViewRow grow in GvDataLayanan.Rows) { var cekbox = grow.FindControl("CBLLayanan") as CheckBox; if (cekbox.Checked) { } } var ret = ordermastercontrols.AddData(data); if (ret.Result) { ClearFields(); Alert("data berhasil disimpan"); } else { Alert("Gagal menyimpan data"); } }
private void DoSave() { string id = TxtOrderNo.Text; var data = new ordermastertbl { orderNo = id, customerNo = ParseInt(TxtCustomerNo.SelectedValue), comodityNo = ParseInt(TxtComodityNo.SelectedValue), sampleTotal = ParseInt(TxtSampleTotal.Text), priceTotal = Formater.ToNumber(TxtPriceTotal.Text), status = TxtStatus.Text, isPaid = TxtIsPayed.SelectedValue, ApprEvaluator = TxtIsApprove.SelectedValue, creaBy = currentUser, creaDate = DatetimeHelper.GetDatetimeNow() }; if (TxtPic.SelectedValue != "-1") { data.pic = ParseInt(TxtPic.SelectedValue); } var ret = orderControl.AddData(data); if (ret.Result) { ClearFields(); SetLayout(ModeForm.ViewData); Alert("data berhasil disimpan"); } else { Alert("Gagal menyimpan data"); } }
private void DoContinue() { 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 = Status.OrderStatus[4], 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, CalculationFilename = datas.CalculationFilename, CalculationFileUrl = datas.CalculationFileUrl }; var ret = orderControls.UpdateData(id, data); if (ret.Result) { orderNo = Request.QueryString["orderNo"]; LoadHeaderInfo(orderNo); LoadGridSample(orderNo); //can't upload and re-calculate after change status BtnLanjut.Visible = false; BtnQR.Visible = false; BtnHitungUlang.Visible = false; BtnUploadZip.Visible = false; CommonWeb.Alert(this, "Menunggu approval evaluator"); } else { CommonWeb.Alert(this, "Gagal mengubah data"); } }
public async Task <bool> UpdateData(string id, ordermastertbl obj) { try { if (id != obj.orderNo) { return(false); } using (var context = new smlpobDB()) { context.ordermastertbls.Attach(obj); context.Entry(obj).Property(x => x.orderNo).IsModified = true; context.Entry(obj).Property(x => x.customerNo).IsModified = true; context.Entry(obj).Property(x => x.comodityNo).IsModified = true; context.Entry(obj).Property(x => x.analysisType).IsModified = true; context.Entry(obj).Property(x => x.sampleTotal).IsModified = true; context.Entry(obj).Property(x => x.priceTotal).IsModified = true; context.Entry(obj).Property(x => x.statusType).IsModified = true; context.Entry(obj).Property(x => x.status).IsModified = true; context.Entry(obj).Property(x => x.paymentStatus).IsModified = true; context.Entry(obj).Property(x => x.ppn).IsModified = true; //context.Entry(obj).Property(x => x.payment).IsModified = true; context.Entry(obj).Property(x => x.receiptDate).IsModified = true; context.Entry(obj).Property(x => x.isPaid).IsModified = true; context.Entry(obj).Property(x => x.paymentDate).IsModified = true; context.Entry(obj).Property(x => x.pic).IsModified = true; context.Entry(obj).Property(x => x.isOnLab).IsModified = true; context.Entry(obj).Property(x => x.ApprPenyelia).IsModified = true; context.Entry(obj).Property(x => x.ApprEvaluator).IsModified = true; context.Entry(obj).Property(x => x.ApprManagerTeknis).IsModified = true; context.Entry(obj).Property(x => x.LHPAttachmentUrl).IsModified = true; context.Entry(obj).Property(x => x.LHPFileName).IsModified = true; context.Entry(obj).Property(x => x.EvaluationFileName).IsModified = true; context.Entry(obj).Property(x => x.EvaluationFileUrl).IsModified = true; context.Entry(obj).Property(x => x.CalculationFilename).IsModified = true; context.Entry(obj).Property(x => x.CalculationFileUrl).IsModified = true; await context.SaveChangesAsync(); return(true); } } catch (Exception ex) { LogHelpers.source = this.GetType().Name; LogHelpers.message = ex.Message; LogHelpers.user = ""; LogHelpers.WriteLog(); } return(false); }
private void DoHitungUlang() { string id = txtNoOreder.Text; //int x = Int32.Parse(id); 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 = "Hitung ulang", 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 //customerName = txtCustomer.Text, //sampleNo = txtNoSample.Text, //priceTotal = datas }; var ret = orderControls.UpdateData(id, data); if (ret.Result) { Alert("Status telah diubah ke Hitung Ulang"); Response.Redirect("DaftarPesanan.aspx"); } else { Alert("Gagal mengubah data"); } }
private void DoUpdate() { string id = TxtOrderNo.Text; var data = new ordermastertbl { orderNo = TxtOrderNo.Text, customerNo = Convert.ToInt32(DDLCustomerno.SelectedValue), comodityNo = Convert.ToInt32(DDLComodityNo.SelectedValue), sampleTotal = Convert.ToInt32(TxtTotalSample.Text), priceTotal = Convert.ToInt32(TxtPriceTotal.Text), status = TxtStatus.Text, paymentType = TxtTipePayment.Text, isPayed = DDLPayed.SelectedValue, isPayedDate = Convert.ToDateTime(TxtPayedDate.Text), isAppr = TxtAppr.Text, pic = Convert.ToInt32(DDLPIC.SelectedValue), modBy = currentUser, modDate = DatetimeHelper.GetDatetimeNow() }; if (DDLCustomerno.SelectedValue != "-1") { data.customerNo = ParseInt(DDLCustomerno.SelectedValue); } else if (DDLComodityNo.SelectedValue != "-1") { data.comodityNo = ParseInt(DDLComodityNo.SelectedValue); } //else if(DDLPayed.SelectedValue != "-1") //{ // data.isPayed = DDLPayed.SelectedValue; //} else if (DDLPIC.SelectedValue != "-1") { data.pic = ParseInt(DDLPIC.SelectedValue); } var ret = daftarspControl.UpdateData(id, data); if (ret.Result) { ClearFields(); SetLayout(ModeForm.ViewData); Alert("Data berhasil diubah"); } else { Alert("Gagal mengubah data"); } }
private void DoHitungUlang() { 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 = "Hitung ulang", 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 }; var ret = orderControls.UpdateData(id, data); if (ret.Result) { orderNo = Request.QueryString["orderNo"]; LoadHeaderInfo(orderNo); LoadGridSample(orderNo); CommonWeb.Alert(this, "Status telah diubah ke Hitung Ulang"); //Response.Redirect("DaftarPesanan.aspx"); } else { CommonWeb.Alert(this, "Gagal mengubah data"); } }
void SendMailToCS(paymenttbl DataPayment, ordermastertbl DataOrder) { using (var db = new smlpobDB()) { var datas = from x in db.employeetbls where x.position == "customer service" select x; var Subject = $"Order [{DataPayment.orderNo}] Telah dibayar melalui transfer"; foreach (var item in datas) { var Message = $"Kepada bagian pelayanan, <br/>di mohon untuk melanjutkan penerimaan sampel dari {DataPayment.name} dengan No. Order: {DataPayment.orderNo}. Jumlah sampel sebanyak {DataOrder.sampleTotal} buah untuk analisa {DataOrder.analysisType}.<br/>Terima kasih<br/>Lampiran dari customer : <a href src='{DataPayment.attachmentUrl}'>File Lampiran</a>"; EmailService.SendEmail(Subject, Message, item.employeeEmail, true); } } }
private void DoContinue() { string id = txtNoOreder.Text; //int x = Int32.Parse(id); 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 = "Menunggu approval", 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 //customerName = txtCustomer.Text, //sampleNo = txtNoSample.Text, //priceTotal = datas }; }
private void DoContinue() { string id = txtNoOreder.Text; //int x = Int32.Parse(id); var rett = orderControls.MasterData(id); var datas = rett.Result; var data = new ordermastertbl { orderNo = datas.orderNo, customerNo = datas.customerNo, comodityNo = datas.comodityNo, sampleTotal = datas.sampleTotal, priceTotal = datas.priceTotal, status = "Menunggu Approval", paymentStatus = datas.paymentStatus, isPaid = datas.isPaid, paymentDate = datas.paymentDate, ApprPenyelia = datas.ApprPenyelia, pic = datas.pic //customerName = txtCustomer.Text, //sampleNo = txtNoSample.Text, //priceTotal = datas }; var ret = orderControls.UpdateData(id, data); if (ret.Result) { ClearFields(); SetLayout(ModeForm.ViewData); Alert("Menunggu approval evaluator"); } else { Alert("Gagal mengubah data"); } }
public async Task <bool> UpdateData(string id, ordermastertbl obj) { try { if (id != obj.orderNo.ToString()) { return(false); } using (var context = new smlpobDB()) { //context.Entry(obj).State = EntityState.Modified; context.ordermastertbls.Attach(obj); context.Entry(obj).Property(x => x.orderNo).IsModified = true; context.Entry(obj).Property(x => x.customerNo).IsModified = true; context.Entry(obj).Property(x => x.comodityNo).IsModified = true; context.Entry(obj).Property(x => x.sampleTotal).IsModified = true; context.Entry(obj).Property(x => x.priceTotal).IsModified = true; context.Entry(obj).Property(x => x.status).IsModified = true; context.Entry(obj).Property(x => x.paymentType).IsModified = true; context.Entry(obj).Property(x => x.isPayed).IsModified = true; context.Entry(obj).Property(x => x.isPayedDate).IsModified = true; context.Entry(obj).Property(x => x.isAppr).IsModified = true; context.Entry(obj).Property(x => x.pic).IsModified = true; context.Entry(obj).Property(x => x.modBy).IsModified = true; context.Entry(obj).Property(x => x.modDate).IsModified = true; await context.SaveChangesAsync(); } } catch (Exception ex) { LogHelpers.source = this.GetType().Name; LogHelpers.message = ex.Message; LogHelpers.user = ""; LogHelpers.WriteLog(); } return(false); }
public async Task <bool> AddData(ordermastertbl obj) { try { using (var context = new smlpobDB()) { context.ordermastertbls.Add(obj); await context.SaveChangesAsync(); return(true); } } catch (Exception ex) { LogHelpers.source = this.GetType().Name; LogHelpers.message = ex.Message; LogHelpers.user = ""; LogHelpers.WriteLog(); } return(false); }
private void DoSave() { List <ordersampletbl> sampel = new List <ordersampletbl>(); ordermastertbl order = new ordermastertbl(); List <orderpricedetailtbl> parameter = new List <orderpricedetailtbl>(); if (GvData.Rows.Count > 0) { for (int i = 0; i < GvData.Rows.Count; i++) { string[] longlat1 = (GvData.Rows[i].Cells[8].Text).Split(','); sampel.Add(new ordersampletbl { countNumber = i + 1, sampleCode = GvData.Rows[i].Cells[1].Text, noBalittanah = GvData.Rows[i].Cells[2].Text, village = GvData.Rows[i].Cells[3].Text, subDistrict = GvData.Rows[i].Cells[4].Text, district = GvData.Rows[i].Cells[5].Text, province = GvData.Rows[i].Cells[6].Text, landUse = GvData.Rows[i].Cells[7].Text, longitude = longlat1[0], latitude = longlat1[1] }); } } order = new ordermastertbl { customerNo = pcc.GetCustomerNo(currentUser), receiptDate = Formater.ToDate(txtTanggalTerima.Text), comodityNo = int.Parse(txtKomoditasChild.SelectedValue), analysisType = txtJenisAnalisis.SelectedValue, sampleTotal = sampel.Count, priceTotal = Formater.ToNumber(txtJumlahHarga.Text), statusType = "Komersial", paymentStatus = Status.PaymentStatus[0], status = Status.OrderStatus[0], ppn = Formater.ToNumber(txtJumlahHarga.Text) * 10 / 100, isPaid = "0", creaBy = currentUser, creaDate = DatetimeHelper.GetDatetimeNow() }; foreach (GridViewRow gvrow in GvParameter.Rows) { var chkbx = gvrow.FindControl("isChecked") as CheckBox; if (chkbx.Checked) { var element = gvrow.FindControl("txtParameterUji") as Label; var price = gvrow.FindControl("txtTarif") as Label; var qty = gvrow.FindControl("txtJumlahContoh") as TextBox; var total = gvrow.FindControl("txtBiaya") as Label; parameter.Add(new orderpricedetailtbl { elementId = Convert.ToInt32(element), price = Formater.ToNumber(price.Text), quantity = int.Parse(qty.Text), TotalPrice = Formater.ToNumber(total.Text) }); } } var ret = pcc.SaveOrder(order, sampel, parameter); if (ret.Result) { Alert("Terima kasih pesanan anda telah tersimpan"); } else { Alert("Gagal menyimpan data"); } }
private void DoHitungUlang() { 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 = Status.OrderStatus[3], 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 }; var ret = orderControls.UpdateData(id, data); using (var db = new smlpobDB()) { var updatedOrderAnalysis = (from x in db.orderanalysisdetailtbls where x.orderNo == data.orderNo select x).ToList(); if (updatedOrderAnalysis != null) { foreach (var item in updatedOrderAnalysis) { item.status = "Menunggu"; } } db.SaveChanges(); } if (ret.Result) { orderNo = Request.QueryString["orderNo"]; LoadHeaderInfo(orderNo); LoadGridSample(orderNo); CommonWeb.Alert(this, "Status telah diubah ke Hitung Ulang"); //Response.Redirect("DaftarPesanan.aspx"); } else { CommonWeb.Alert(this, "Gagal mengubah data"); } }
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; }; }
public async Task <bool> SaveOrder(ordermastertbl order, List <ordersampletbl> sample, List <orderpricedetailtbl> element) { try { //string id = AutoGenerateOrder(); //order.orderNo = id; List <orderanalysisdetailtbl> detail = new List <orderanalysisdetailtbl>(); foreach (var data1 in sample) { foreach (var data2 in element) { detail.Add(new orderanalysisdetailtbl { orderNo = order.orderNo, sampleNo = data1.noBalittanah, elementId = Convert.ToInt32(data2.elementId), status = "Menunggu", recalculate = "0", creaBy = order.creaBy, creaDate = order.creaDate }); } } using (var context = new smlpobDB()) { context.ordermastertbls.Add(order); foreach (var data in sample) { //data.orderNo = id; data.isReceived = "0"; context.ordersampletbls.Add(data); } foreach (var data in detail) { context.orderanalysisdetailtbls.Add(data); } foreach (var data in element) { //data.orderNo = id; context.orderpricedetailtbls.Add(data); } await context.SaveChangesAsync(); return(true); } } catch (Exception ex) { LogHelpers.source = this.GetType().Name; LogHelpers.message = ex.Message; LogHelpers.user = currentUser; LogHelpers.WriteLog(); } return(false); }
private void DoSave() { if (DataSampel.Count <= 0) { CommonWeb.Alert(this, "Silakan masukan data sampel terlebih dahulu."); return; } if (Formater.ToNumber(LitTotalBiaya.Text) <= 0) { CommonWeb.Alert(this, "Silakan minimal pilih 1 parameter untuk diuji."); return; } List <ordersampletbl> sampel = DataSampel; ordermastertbl order = new ordermastertbl(); List <orderpricedetailtbl> parameter = new List <orderpricedetailtbl>(); var LastNum = CounterGen.Increment("BALITTANAH"); var NewOrderNo = GenerateNoOrder(LastNum); foreach (var item in sampel) { item.orderNo = NewOrderNo; item.noBalittanah = GenerateNoBalitTanah(CounterGen.Increment("SAMPEL"), LastNum); } order = new ordermastertbl { orderNo = NewOrderNo, customerNo = pcc.GetCustomerNo(currentUser), comodityNo = int.Parse(CmbSubKomoditas.SelectedValue), analysisType = CmbJenisAnalisa.SelectedValue, sampleTotal = sampel.Count, priceTotal = Formater.ReturnModCurency(LitTotalBiaya.Text), statusType = "Komersial", paymentStatus = "Belum dibayar", status = "Pesanan Baru", ppn = Formater.ToNumber(LitTotalBiaya.Text) * 10 / 100, receiptDate = Formater.ToDate(TxtTanggalDiterima.Text), isPaid = "0", creaBy = currentUser, creaDate = DatetimeHelper.GetDatetimeNow(), modBy = currentUser, modDate = DatetimeHelper.GetDatetimeNow() }; foreach (GridViewRow gvrow in GvParameter.Rows) { var chkbx = gvrow.FindControl("isChecked") as CheckBox; if (chkbx.Checked) { var element = gvrow.FindControl("txtParameterId") as Label; var price = gvrow.FindControl("txtTarif") as Label; var qty = gvrow.FindControl("txtJumlahContoh") as TextBox; var total = gvrow.FindControl("txtBiaya") as Label; parameter.Add(new orderpricedetailtbl { orderNo = NewOrderNo, elementId = int.Parse(element.Text), price = Formater.ToNumber(price.Text), quantity = int.Parse(qty.Text), TotalPrice = Formater.ToNumber(total.Text) }); } } var ret = pcc.SaveOrder(order, sampel, parameter); if (ret.Result) { CommonWeb.Alert(this, "Berhasil menyimpan."); Response.Redirect("CustomerBeranda.aspx"); } else { CommonWeb.Alert(this, "Terjadi kesalahan saat menyimpan data. Silakan coba kembali nanti."); } }
private void DoUpdate() { try { string id = lblorder.Text; //master var rett = orderControls.MasterData(id); var datas = rett.Result; //detail var detor = orderControls.GetDetailOrder(id); var datadet = detor.Result; int _pic = Convert.ToInt32(DdlPIC.SelectedValue); _idpic = _pic; 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.analysisType == "Kimia" ? "Batch Management":Status.OrderStatus[3], paymentStatus = datas.paymentStatus, ppn = datas.ppn, receiptDate = datas.receiptDate, isPaid = datas.isPaid, paymentDate = datas.paymentDate, pic = _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, creaBy = datas.creaBy, creaDate = datas.creaDate, modBy = datas.modBy, modDate = datas.modDate }; var ret = orderControls.UpdateData(id, data); if (ret.Result) { foreach (var item in datadet) { var data2 = new orderanalysisdetailtbl { orderDetailNo = item.orderDetailNo, orderNo = item.orderNo, sampleNo = item.sampleNo, elementId = item.elementId, parametersNo = item.parametersNo, elementValue = item.elementValue, status = item.status, recalculate = item.recalculate, pic = _idpic, fileAttachmentUrl = item.fileAttachmentUrl, fileName = item.fileName, LabToolAttachmentUrl = item.LabToolAttachmentUrl, LabToolFileName = item.LabToolFileName, creaBy = item.creaBy, creaDate = item.creaDate, modBy = item.modBy, modDate = item.modDate }; var ret2 = orderControls.UpdateDataDetail(item.orderDetailNo, data2); if (ret2.Result) { string msg = "Pic Untuk No Order " + id + " telah dipilih"; CommonWeb.Alert(this, msg); //send mail using (var db = new smlpobDB()) { var usr = db.employeetbls.Where(x => x.employeeNo == _pic).FirstOrDefault(); if (!string.IsNullOrEmpty(usr.employeeEmail)) { Helpers.EmailService.SendEmail("Penugasan Lab", $"Anda mendapat tugas dari manager teknis ({CommonWeb.GetCurrentUserName()}) untuk mengerjakan order no: {datas.orderNo}", usr.employeeEmail, false); //SmsService.SendSms($"Anda mendapat tugas dari manager teknis ({CommonWeb.GetCurrentUserName()}) untuk mengerjakan order no: {datas.orderNo}", usr.employeePhone).GetAwaiter().GetResult(); } } Response.Redirect("../Manager/Dash_ManagerTeknis.aspx"); } else { CommonWeb.Alert(this, "Gagal mengubah data"); } } } else { CommonWeb.Alert(this, "Gagal mengubah data"); } } catch (Exception ex) { LogHelpers.source = this.GetType().ToString(); LogHelpers.message = "Error Set PIC:" + ex.Message; LogHelpers.user = CommonWeb.GetCurrentUser(); LogHelpers.WriteLog(); } }
private void DoUpdate() { try { string id = lblorder.Text; //master var rett = orderControls.MasterData(id); var datas = rett.Result; //detail var detor = orderControls.GetDetailOrder(id); var datadet = detor.Result; int _pic = Convert.ToInt32(DdlPIC.SelectedValue); _idpic = _pic; 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 = "Diproses", paymentStatus = datas.paymentStatus, ppn = datas.ppn, receiptDate = datas.receiptDate, isPaid = datas.isPaid, paymentDate = datas.paymentDate, pic = _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, creaBy = datas.creaBy, creaDate = datas.creaDate, modBy = datas.modBy, modDate = datas.modDate }; var ret = orderControls.UpdateData(id, data); if (ret.Result) { foreach (var item in datadet) { var data2 = new orderanalysisdetailtbl { orderDetailNo = item.orderDetailNo, orderNo = item.orderNo, sampleNo = item.sampleNo, elementId = item.elementId, parametersNo = item.parametersNo, elementValue = item.elementValue, status = item.status, recalculate = item.recalculate, pic = _idpic, fileAttachmentUrl = item.fileAttachmentUrl, fileName = item.fileName, LabToolAttachmentUrl = item.LabToolAttachmentUrl, LabToolFileName = item.LabToolFileName, creaBy = item.creaBy, creaDate = item.creaDate, modBy = item.modBy, modDate = item.modDate }; var ret2 = orderControls.UpdateDataDetail(item.orderDetailNo, data2); if (ret2.Result) { string msg = "Pic Untuk No Order " + id + " telah dipilih"; CommonWeb.Alert(this, msg); Response.Redirect("../Manager/Dash_ManagerTeknis.aspx"); } else { CommonWeb.Alert(this, "Gagal mengubah data"); } } } else { CommonWeb.Alert(this, "Gagal mengubah data"); } } catch (Exception ex) { LogHelpers.source = this.GetType().ToString(); LogHelpers.message = "Error Set PIC:" + ex.Message; LogHelpers.user = CommonWeb.GetCurrentUser(); LogHelpers.WriteLog(); } }