public async Task <bool> UpdateData(string id, orderanalysisdetailtbl obj)
{
try
{
if (id != obj.orderDetailNo.ToString())
{
return(false);
}
using (var context = new smlpobDB())
{
context.orderanalysisdetailtbls.Attach(obj);
context.Entry(obj).Property(x => x.status).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 DoUpdate()
{
string id = TxtOrderDetailNo.Text;
var data = new orderanalysisdetailtbl
{
orderDetailNo = ParseInt(id),
orderNo = TxtOrderNo.SelectedValue,
sampleNo = TxtSampleNo.SelectedValue,
elementId = Convert.ToInt32(TxtElementCode),
parametersNo = ParseInt(TxtParametersNo.Text),
elementValue = TxtElementValue.Text,
status = TxtStatus.SelectedValue,
recalculate = TxtRecalculate.SelectedValue,
modBy = currentUser,
modDate = DatetimeHelper.GetDatetimeNow()
};
if (TxtPic.SelectedValue != "-1")
{
data.pic = ParseInt(TxtPic.SelectedValue);
}
var ret = detailControl.UpdateData(id.ToString(), data);
if (ret.Result)
{
ClearFields();
SetLayout(ModeForm.ViewData);
Alert("Data berhasil diubah");
}
else
{
Alert("Gagal mengubah data");
}
}
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;
}
}
private void DoUpdate()
{
try
{
string idd = TxtDetailNo.Text.ToString();
int id = ParseInt(TxtorderNo.Text);
var det = ordtl.DetailData(idd);
var wholedata = det.Result;
var updatests = GetStatus(idd.ToString());
var data = new orderanalysisdetailtbl
{
orderDetailNo = wholedata.orderDetailNo,
orderNo = wholedata.orderNo,
sampleNo = wholedata.sampleNo,
elementId = wholedata.elementId,
parametersNo = wholedata.parametersNo,
elementValue = wholedata.elementValue,
status = updatests,
pic = wholedata.pic,
creaBy = wholedata.creaBy,
creaDate = wholedata.creaDate,
modBy = wholedata.modBy,
modDate = DatetimeHelper.GetDatetimeNow()
};
var ret = ordtl.UpdateData(idd.ToString(), data);
if (ret.Result)
{
Alert("Tugas Telah Diambil");
}
else
{
Alert("Terjadi Kesalahan, Gagal mengambil tugas");
}
}
catch (Exception er)
{
System.Diagnostics.Debug.WriteLine(er);
}
}
private void DoSaveOrTail()
{
var data = new orderanalysisdetailtbl
{
sampleNo = TxtNoSample.Text,
elementId = Convert.ToInt32(GvDataLayanan.FindControl("CBLLayanan")),
};
var ret = orderdetailcontrols.AddData(data);
if (ret.Result)
{
ClearFields();
Alert("data berhasil disimpan");
}
else
{
Alert("Gagal menyimpan data");
}
}
public async Task <bool> AddData(orderanalysisdetailtbl obj)
{
try
{
using (var context = new smlpobDB())
{
context.orderanalysisdetailtbls.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 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();
}
}
