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