protected void BtnReject_Click(object sender, EventArgs e)
{
using (var db = new smlpobDB())
{
var data = (from x in db.ordermastertbls.Include(c => c.employeetbl)
where x.orderNo == lblorder.Text
select x).FirstOrDefault();
if (data != null)
{
data.status = "Hitung ulang";
db.SaveChanges();
//send to penyelia
var email = data.employeetbl.employeeEmail;
//var phoneNo = data.employeetbl.employeePhone;
if (!string.IsNullOrEmpty(email) && !string.IsNullOrEmpty(TxtKeterangan.Text))
{
EmailService.SendEmail("Order No:" + lblorder.Text + " di Reject oleh Manager Teknis", $"Order No {lblorder.Text} di reject, dan perlu di hitung ulang dengan alasan {TxtKeterangan.Text}", email, true);
//SmsService.SendSms( $"Order No {lblorder.Text} di reject, dan perlu di hitung ulang dengan alasan {TxtKeterangan.Text}", phoneNo).GetAwaiter().GetResult();
Response.Redirect("Dash_ManagerTeknis.aspx");
}
else
{
CommonWeb.Alert(this, "Mohon isi keterangan.");
}
}
else
{
CommonWeb.Alert(this, "Gagal reject, terjadi kesalahan system.");
}
}
}
// Action Field
protected void ActionButton(object sender, EventArgs e)
{
try
{
var btn = sender as Button;
var command = btn.CommandName;
switch (command)
{
case "save":
DoSave();
break;
case "cancel":
if (!string.IsNullOrEmpty(Request.QueryString["orderno"]))
{
var orderstr = Request.QueryString["orderno"];
Response.Redirect("CustomerRincian.aspx?orderNo=" + orderstr);
}
break;
}
}
catch (Exception ex)
{
CommonWeb.Alert(this, "Terjadi Kesalahan");
}
}
private void GvData_RowCommand(object sender, GridViewCommandEventArgs e)
{
var IDS = e.CommandArgument.ToString();
switch (e.CommandName)
{
case "lihat":
Response.Redirect("ManagerDetailOrder.aspx?value=" + IDS + "&State=" + FormState);
break;
case "rincian":
Response.Redirect("ManagerDetailOrder.aspx?value=" + IDS + "&State=" + FormState);
break;
case "download":
using (var db = new smlpobDB())
{
var data = (from x in db.ordermastertbls where x.orderNo == IDS select x).FirstOrDefault();
if (data != null && !string.IsNullOrEmpty(data.LHPAttachmentUrl))
{
Response.Redirect(data.LHPAttachmentUrl);
}
else
{
CommonWeb.Alert(this, "File LHP tidak ditemukan.");
}
}
break;
case "approval":
Response.Redirect("ManagerDetailOrder.aspx?value=" + IDS + "&State=" + FormState);
break;
}
}
private void btnSimpan_Click(object sender, EventArgs e)
{
if (orderControls.UpdatePayment(txtNoOrder.Text, StatusPembayaranCmb.SelectedValue.ToString(), TipePembayaranCmb.SelectedValue.ToString()))
{
var context = GlobalHost.ConnectionManager.GetHubContext <NotificationHub>();
context.Clients.All.PushNotification("All", "Pesanan no " + txtNoOrder.Text + " sudah membayar", "https://silpo.id");
string[] rolesArray;
RolePrincipal r = (RolePrincipal)User;
rolesArray = r.GetRoles();
if (StatusPembayaranCmb.SelectedValue.ToString() == Status.PaymentStatus[0])
{
CommonWeb.Alert(this, "Pembayaran sudah terupdate");
}
else
{
Response.Redirect("KasirMasuk.aspx");
CommonWeb.Alert(this, "Pembayaran selesai, diteruskan ke bagian pelayanan untuk memberi label sampel.");
}
}
else
{
CommonWeb.Alert(this, "Gagal update");
}
}
protected void ActionButton(object sender, EventArgs e)
{
try
{
var btn = sender as Button;
var command = btn.CommandName;
switch (command)
{
case "Kembali":
Response.Redirect("CustomerBeranda.aspx");
break;
case "Cetak":
string filepath = GenerateLP();
//cetak lembar permohonan
Response.Redirect("CustomerCetakPermohonan.aspx?path=" + filepath);
break;
case "KajiUlang":
Response.Redirect("FormKajiUlang.aspx?orderNo=" + txtNoOrder.Text);
break;
}
}
catch (Exception ex)
{
CommonWeb.Alert(this, "Terjadi Kesalahan");
}
}
void RefreshGrid(string param = "")
{
var myLab = CommonWeb.GetUserLab();
var ret = listGridMaster.GetDataProses(myLab);
var datas = ret.Result;
foreach (var dat in datas)
{
if (dat.isPaid == "1")
{
dat.isPaid = "Sudah Dibayar";
}
else
{
dat.isPaid = "Belum Dibayar";
}
}
GvData.DataSource = datas;
GvData.DataBind();
if (GvData.Rows.Count > 0)
{
GvData.UseAccessibleHeader = true;
GvData.HeaderRow.TableSection = TableRowSection.TableHeader;
}
}
public ActionResult AddBikeInfo(BikeInfo bikeInfo)
{
//计算总价
var price = bikeInfo.Price;
var count = bikeInfo.Counts;
var total = price * count;
if (Session["loginUser"] != null)
{
UserInfo user = Session["loginUser"] as UserInfo;
//调用生成UID的方法
bikeInfo.UID = CommonWeb.AutoNumber();
bikeInfo.AdminUser = user == null?"未登录": user.Name;
bikeInfo.DelFlag = noDel;
bikeInfo.SubTime = DateTime.Now;
bikeInfo.ModifyOn = DateTime.Now;
bikeInfo.TotalPrice = total;
if (ModelState.IsValid)
{
bikeInfoService.Add(bikeInfo);
return(Content("ok"));
}
}
return(Content("error"));
}
void SimpanData()
{
var LastNum = CounterGen.Increment("BATCHNO");
var NewBatchNo = GenerateNoBatch(LastNum);
var curDate = DateTime.Now;
var newBatch = new batchtbl()
{
status = "Proses", batchId = NewBatchNo, creaBy = CommonWeb.GetCurrentUser(), creaDate = curDate, modBy = CommonWeb.GetCurrentUser(), modDate = curDate, pic_analis = Convert.ToInt32(CmbPIC.SelectedValue), pic_penyelia = CommonWeb.GetCurrentEmployeeNo()
};
var listOrderNo = new List <string>();
foreach (GridViewRow row in GvData.Rows)
{
var chk = row.FindControl("ChkPilih") as CheckBox;
if (chk != null && chk.Checked)
{
var orderNo = row.Cells[1].Text;
listOrderNo.Add(orderNo);
}
}
if (listOrderNo.Count > 0)
{
var res = orderControls.SimpanDataBatch(newBatch, listOrderNo);
if (res)
{
Response.Redirect("DaftarPesanan.aspx");
}
}
else
{
CommonWeb.Alert(this, "Silakan pilih order terlebih dahulu");
}
}
bool IsAuthorized()
{
if (!string.IsNullOrEmpty(Roles))
{
using (var db = new smlpobDB())
{
var uname = CommonWeb.GetCurrentUser();
var MyRole = (from x in db.accounttbls
where x.username == uname
select x).ToList();
if (MyRole != null)
{
foreach (var item in Roles.Split(';'))
{
foreach (var my in MyRole)
{
if (item == my.roleName)
{
return(true);
}
}
}
}
}
return(false);
}
else
{
return(true);
}
}
void LoadGridSample(string NoBalitTanah = "")
{
using (var db = new smlpobDB())
{
var myLab = CommonWeb.GetUserLab();
var dataSample = OrderSampleControls.GetDataByStatus(Status.OrderStatus[3], myLab); //db.ordersampletbls.Include(c => c.ordermastertbl).Where(x => x.ordermastertbl.status == "Proses Lab").ToList();
if (!string.IsNullOrEmpty(NoBalitTanah) && dataSample != null)
{
dataSample = dataSample.Where(x => x.noBalittanah == NoBalitTanah).ToList();
}
foreach (var data in dataSample)
{
if (data.isReceived == "1")
{
data.isReceived = "Sudah";
}
else
{
data.isReceived = "Belum";
}
}
GvData.DataSource = dataSample;
GvData.DataBind();
}
if (GvData.Rows.Count > 0)
{
GvData.UseAccessibleHeader = true;
GvData.HeaderRow.TableSection = TableRowSection.TableHeader;
}
}
void BindData()
{
var empNo = CommonWeb.GetCurrentEmployeeNo();
var datas = orderControls.GetOrdersForBatch(empNo);
GvData.DataSource = datas;
GvData.DataBind();
}
protected void ActionButton(object sender, EventArgs e)
{
try
{
var btn = sender as Button;
var command = btn.CommandName;
switch (command)
{
case "Kembali":
DoKembali();
break;
case "Approve":
DoContinue();
break;
case "Reject":
using (var db = new smlpobDB())
{
var data = (from x in db.ordermastertbls.Include(c => c.employeetbl)
where x.orderNo == txtNoOrder.Text
select x).FirstOrDefault();
if (data != null)
{
data.status = "Hitung ulang";
db.SaveChanges();
//send to penyelia
var email = data.employeetbl.employeeEmail;
//var PhoneNo = data.employeetbl.employeePhone;
if (!string.IsNullOrEmpty(email) && !string.IsNullOrEmpty(TxtKeterangan.Text))
{
EmailService.SendEmail("Order No:" + txtNoOrder.Text + $" di Reject oleh Evaluator ({CommonWeb.GetCurrentUser()})", $"Order No {txtNoOrder.Text} di reject, dan perlu di hitung ulang dengan alasan {TxtKeterangan.Text}", email, true);
//SmsService.SendSms( $"Order No {txtNoOrder.Text} di reject, dan perlu di hitung ulang dengan alasan {TxtKeterangan.Text}", PhoneNo).GetAwaiter().GetResult();
}
else
{
CommonWeb.Alert(this, "Mohon isi keterangan.");
}
}
else
{
CommonWeb.Alert(this, "Gagal reject, terjadi kesalahan system.");
}
Response.Redirect("EvaluasiHasil.aspx");
}
break;
}
}
catch (Exception ex)
{
LogHelpers.source = this.GetType().ToString();
LogHelpers.message = "Terjadi kesalahan:" + ex.Message;
LogHelpers.user = CommonWeb.GetCurrentUser();
LogHelpers.WriteLog();
}
}
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();
}
}
void LoadData()
{
ListGridMaster listGridMaster = new ListGridMaster();
if (FilterType == "ByUser")
{
var ret = listGridMaster.GetData();
var datas = ret.Result.Where(x => x.creaBy == CommonWeb.GetCurrentUser()).Count();
lblTotal.Text = datas.ToString();
var ret3 = listGridMaster.GetData();
var datas3 = ret3.Result.Where(x => x.creaBy == CommonWeb.GetCurrentUser() && (x.status == "Pilih Penyelia" || x.status == "Proses Lab" ||
x.status == "Verifikasi Penyelia" || x.status == "Evaluasi Hasil" || x.status == "Hitung ulang" || x.status == "Menunggu Approval")).Count();
lblOrderProses.Text = datas3.ToString();
var ret4 = listGridMaster.GetData();
var datas4 = ret4.Result.Where(x => x.creaBy == CommonWeb.GetCurrentUser() && (x.status == "LHP Keluar" || x.status == "LHP Sudah Diambil")).Count();
lblOrderDone.Text = datas4.ToString();
}
else
{
var myLab = CommonWeb.GetUserLab();
if (!string.IsNullOrEmpty(myLab))
{
var ret = listGridMaster.GetData();
var datas = ret.Result.Where(x => x.analysisType == myLab).Count();
lblTotal.Text = datas.ToString();
var ret3 = listGridMaster.GetData();
var datas3 = ret3.Result.Where(x => (x.status == "Pilih Penyelia" || x.status == "Proses Lab" || x.status == "Barcode Sampel" ||
x.status == "Verifikasi Penyelia" || x.status == "Evaluasi Hasil" || x.status == "Hitung ulang" || x.status == "Menunggu Approval") && x.analysisType == myLab).Count();
lblOrderProses.Text = datas3.ToString();
var ret4 = listGridMaster.GetData();
var datas4 = ret4.Result.Where(x => (x.status == "LHP Keluar" || x.status == "LHP Sudah Diambil") && x.analysisType == myLab).Count();
lblOrderDone.Text = datas4.ToString();
}
else
{
var ret = listGridMaster.GetData();
var datas = ret.Result.Count();
lblTotal.Text = datas.ToString();
var ret3 = listGridMaster.GetData();
var datas3 = ret3.Result.Where(x => x.status == "Pilih Penyelia" || x.status == "Proses Lab" || x.status == "Barcode Sampel" ||
x.status == "Verifikasi Penyelia" || x.status == "Evaluasi Hasil" || x.status == "Hitung ulang" || x.status == "Menunggu Approval").Count();
lblOrderProses.Text = datas3.ToString();
var ret4 = listGridMaster.GetData();
var datas4 = ret4.Result.Where(x => x.status == "LHP Keluar" || x.status == "LHP Sudah Diambil").Count();
lblOrderDone.Text = datas4.ToString();
}
}
}
public BasePage()
{
if (userId == 0)
{
if (Request.Cookies[CommonStr.USERID] != null && !string.IsNullOrEmpty(Request.Cookies[CommonStr.USERID].ToString()))
{
string strDesKey = Cache["UserPwdKey"] == null ? string.Empty : Cache["UserPwdKey"].ToString();
if (string.IsNullOrEmpty(strDesKey))
{
strDesKey = new MAS_SYSTEMCONFIG().GetValueByKey("UserPwdKey");
}
if (string.IsNullOrEmpty(strDesKey))
{
strDesKey = "mxr2016@" + DateTime.Now.Year;
}
string strUserId = Encryption.DecryptDES(Request.Cookies[CommonStr.Password].ToString(), strDesKey);
userId = ConvertHelper.ToInt32(strUserId);
if (userId <= 0)
{
CommonWeb.Alert(this, "登录失效，请重新登录");
return;
}
DataTable dtUser = new MAS_ADMIN_ACCOUNT().getUserLogin(userId);
if (dtUser == null || dtUser.Rows.Count <= 0)
{
CommonWeb.Alert(this, "登录失效，请重新登录");
return;
}
Session.Add(Common.CommonStr.USERID, dtUser.Rows[0]["MAS_ADMIN_ID"]);
Session.Add(Common.CommonStr.USERNAME, dtUser.Rows[0]["MAS_ADMIN_NAME"]);
Session.Add(Common.CommonStr.NICKNAME, dtUser.Rows[0]["MAS_ADMIN_NICKNAME"]);
Session.Add(Common.CommonStr.Password, Encryption.EncryptDES(dtUser.Rows[0]["MAS_ADMIN_ID"].ToString(), strDesKey));
HttpCookie cookie = new HttpCookie(Common.CommonStr.COOKIE);
cookie.Values.Add(Common.CommonStr.USERID, dtUser.Rows[0]["MAS_ADMIN_ID"].ToString());
cookie.Values.Add(Common.CommonStr.USERNAME, dtUser.Rows[0]["MAS_ADMIN_NAME"].ToString());
cookie.Values.Add(CommonStr.Password, Encryption.EncryptDES(dtUser.Rows[0]["MAS_ADMIN_ID"].ToString(), strDesKey));
Response.AppendCookie(cookie);
}
else
{
CommonWeb.Alert(this, "登录失效，请重新登录");
}
//context.Session.Add(Common.CommonStr.USERID, dt.Rows[0]["MAS_ADMIN_ID"]);
//context.Session.Add(Common.CommonStr.USERNAME, dt.Rows[0]["MAS_ADMIN_NAME"]);
//context.Session.Add(Common.CommonStr.NICKNAME, dt.Rows[0]["MAS_ADMIN_NICKNAME"]);
//HttpCookie cookie = new HttpCookie(Common.CommonStr.COOKIE);
//cookie.Values.Add(Common.CommonStr.USERID, dt.Rows[0]["MAS_ADMIN_ID"].ToString());
//cookie.Values.Add(Common.CommonStr.USERNAME, dt.Rows[0]["MAS_ADMIN_NAME"].ToString());
////cookie.Values.Add(Common.CommonStr.NICKNAME, context.Server.HtmlEncode(dt.Rows[0]["MAS_ADMIN_NICKNAME"].ToString()));
//context.Response.AppendCookie(cookie);
}
}
// Action Field
protected void ActionButton(object sender, EventArgs e)
{
try
{
var btn = sender as Button;
var command = btn.CommandName;
switch (command)
{
case "add":
ShowZone(0);
TxtNoSampel.Text = "";
TxtNoBalitTanah.Text = "";
break;
case "cancel":
Response.Redirect("CustomerBeranda.aspx");
break;
case "proses":
ShowZone(2);
break;
case "add-sampel":
if (string.IsNullOrEmpty(TxtNoBalitTanah.Text))
{
AddSampel();
}
else
{
AddSampel(true);
}
break;
case "cancel-sampel":
ShowZone(1);
break;
case "sop":
ShowZone(3);
break;
case "close":
ShowZone(4);
break;
case "back":
ShowZone(5);
break;
}
}
catch (Exception ex)
{
CommonWeb.Alert(this, "Terjadi Kesalahan");
}
}
private void GvData_RowCommand(object sender, GridViewCommandEventArgs e)
{
switch (e.CommandName)
{
case "Terima":
{
var payId = Convert.ToInt32(e.CommandArgument);
PanelGridMasuk.Visible = false;
DivPayment.Visible = true;
HidPaymentID.Value = payId.ToString();
}
break;
case "Tolak":
{
var payId = Convert.ToInt32(e.CommandArgument);
using (var db = new smlpobDB())
{
var payment = (from x in db.paymenttbls
where x.paymentId == payId
select x).FirstOrDefault();
if (payment != null)
{
var data = (from x in db.ordermastertbls
where x.orderNo == payment.orderNo
select x).FirstOrDefault();
if (data != null)
{
data.paymentStatus = Status.PaymentStatus[0];
}
payment.status = "Ditolak";
db.SaveChanges();
RefreshGrid();
}
}
}
break;
case "Lihat":
var url = e.CommandArgument.ToString();
Response.Write("<script>window.open ('" + url + "','_blank');</script>");
break;
case "Download":
var DownloadUrl = e.CommandArgument.ToString();
if (string.IsNullOrEmpty(DownloadUrl))
{
CommonWeb.Alert(this, "Tidak ada lampiran");
}
else
{
Response.Write("<script>window.open ('" + DownloadUrl + "','_blank');</script>");
}
break;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (!IsAuthorized())
{
CommonWeb.Alert(this.Parent.Page, "Anda tidak memiliki akses ke halaman ini.");
Response.Redirect("/pages/public/NotAuthorized.aspx");
}
}
}
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");
}
}
protected void Page_Load(object sender, EventArgs e)
{
GvData.RowDataBound += GvData_RowDataBound;
if (!IsPostBack)
{
GetTranslation();
CounterGen = new NumberCounter();
CmbPIC.DataTextField = "employeeName";
CmbPIC.DataValueField = "employeeNo";
var myLab = CommonWeb.GetUserLab();
var picData = orderControls.GetPICAnalyst(myLab);
CmbPIC.DataSource = picData;
CmbPIC.DataBind();
var batchIdStr = Request.QueryString["batchId"];
if (!string.IsNullOrEmpty(batchIdStr))
{
LitTitleBatch.Text = "Lihat Batch";
LitTitleBatch.Text = LanguageHelper.GetTranslation("detailbatch");
TxtNoBatch.Text = batchIdStr;
var data = orderControls.GetBatchFromId(batchIdStr);
if (data != null)
{
GvData.DataSource = orderControls.GetOrdersFromBatchId(batchIdStr);
GvData.DataBind();
}
BtnSimpan.Visible = false;
GvData.Columns[0].Visible = false;
int counter = 0;
foreach (var x in picData)
{
if (x.employeeNo == data.pic_analis.Value)
{
CmbPIC.SelectedIndex = counter;
}
counter++;
}
CmbPIC.Enabled = false;
}
else
{
LitTitleBatch.Text = "Buat Batch";
LitTitleBatch.Text = LanguageHelper.GetTranslation("createbatch");
TxtNoBatch.Text = GenerateNoBatch();
BindData();
}
}
BtnBack.Click += (a, b) => { Response.Redirect("DaftarPesanan.aspx"); };
BtnSimpan.Click += (a, b) => { SimpanData(); };
}
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;
}
}
void Cetak()
{
try
{
var orderNo = Request.QueryString["value"];
if (!string.IsNullOrEmpty(orderNo))
{
List <BarcodeItem> Barcode = new List <BarcodeItem>();
int RowNum = 0;
foreach (GridViewRow dr in GvData.Rows)
{
var txtJml = dr.FindControl("TxtJml") as TextBox;
var RepeatCount = int.Parse(txtJml.Text);
for (int i = 0; i < RepeatCount; i++)
{
DropDownList cmb = dr.FindControl("CmbPrinter") as DropDownList;
var printName = "All";
if (cmb != null)
{
printName = cmb.SelectedValue;
}
RowNum++;
Barcode.Add(new BarcodeItem()
{
Barcode = dr.Cells[2].Text, PrinterName = printName
});
}
}
if (Barcode.Count > 0)
{
//DefaultHubManager hd = new DefaultHubManager(GlobalHost.DependencyResolver);
//var hub = hd.ResolveHub("BarcodeHub") as BarcodeHub;
var context = GlobalHost.ConnectionManager.GetHubContext <BarcodeHub>();
var Printers = Barcode.Select(x => x.PrinterName).Distinct().ToList();
foreach (var printer in Printers)
{
var datas = (from x in Barcode
where x.PrinterName == printer
select new string(x.Barcode.ToCharArray())).ToList();
context.Clients.All.PrintBarcode(printer, datas);
}
//var hub = GlobalHost.ConnectionManager.GetHubContext<BarcodeHub>() as BarcodeHub;
//hub.PrintBarcode("All", Barcode);
CommonWeb.Alert(this, "Data barcode di Cetak");
}
}
}
catch (Exception ex)
{
CommonWeb.Alert(this, "Gagal cetak barcode:" + ex.Message + " - " + ex.StackTrace);
}
}
void LoadData(string orderNo)
{
try
{
var qr = new ZXing.BarcodeWriter();
var options = new QrCodeEncodingOptions
{
DisableECI = true,
CharacterSet = "UTF-8",
Width = 100,
Height = 100,
};
qr.Options = options;
qr.Format = ZXing.BarcodeFormat.QR_CODE;
var fName = Path.GetTempPath() + "/" + Guid.NewGuid().ToString().Replace("-", "_") + ".jpg";
string FilePath = @"file:\" + fName;
var result = new Bitmap(qr.Write(orderNo));
result.Save(fName, ImageFormat.Jpeg);
//setup report
reportViewer.LocalReport.EnableExternalImages = true;
reportViewer.ProcessingMode = ProcessingMode.Local;
reportViewer.LocalReport.ReportPath = Server.MapPath("~/Reports") + "/QRcode.rdlc";
using (var db = new smlpobDB())
{
var orderData = (from x in db.ordermastertbls
where x.orderNo == orderNo
select x).FirstOrDefault();
if (orderData != null)
{
ReportParameter ImageQRParam = new ReportParameter();
ImageQRParam.Name = "ImageQR";
ImageQRParam.Values.Add(FilePath);
reportViewer.LocalReport.SetParameters(new ReportParameter[] { ImageQRParam });
}
}
}
catch (Exception ex)
{
CommonWeb.Alert(this, "Terjadi kesalahan, silahkan coba kembali.");
LogHelpers.source = this.GetType().ToString();
LogHelpers.message = "Failed to print QR code with the following error:" + ex.Message;
LogHelpers.user = CommonWeb.GetCurrentUser();
LogHelpers.WriteLog();
}
}
private void BtnUpload_Click(object sender, EventArgs e)
{
if (FileUpload1.HasFile)
{
DivInfo.Visible = false;
DivWarning.Visible = false;
var ext = Path.GetExtension(FileUpload1.FileName).ToLower();
var tempPath = Path.GetTempFileName() + ext;
FileUpload1.SaveAs(tempPath);
HashSet <String> exts = new HashSet <string> {
".bmp", ".png", ".jpg", ".gif", ".png"
};
if (exts.Contains(ext))
{
ImageQR.ImageUrl = "/handlers/imageloader.ashx?ImgPath=" + tempPath;
var qr = new ZXing.BarcodeReader();
var options = new DecodingOptions
{
CharacterSet = "UTF-8",
};
qr.Options = options;
Bitmap bmp = (Bitmap)Bitmap.FromFile(tempPath);
var res = qr.Decode(bmp);
if (res != null && !string.IsNullOrEmpty(res.Text))
{
try
{
var decrypt = Crypto.Decrypt(res.Text);
LoadHeaderInfo(decrypt.Trim());
}
catch
{
CommonWeb.Alert(this, "Qr dapat dibaca tapi tidak valid.");
}
}
else
{
CommonWeb.Alert(this, "Qr tidak dapat dibaca, atau gambar tidak valid.");
}
}
else
{
CommonWeb.Alert(this, "Silakan upload file dengan tipe gambar");
}
}
else
{
CommonWeb.Alert(this, "Silakan pilih foto QR LHP terlebih dahulu.");
}
}
private async void RefreshGrid(string Filter = "Filter1")
{
Session["Filter"] = Filter;
var myLab = CommonWeb.GetUserLab();
if (Filter == "Filter1")
{
var ret = await orderControls.GetDataPenyelia(myLab);
var datas = ret;
if (datas != null)
{
GridvData.DataSource = datas;
GridvData.DataBind();
}
}
else if (Filter == "Filter2")
{
var ret = await orderControls.GetDataSelesai(myLab);
var datas = ret;
if (datas != null)
{
GridvData.DataSource = datas;
GridvData.DataBind();
}
}
else if (Filter == "Filter3")
{
var ret = await orderControls.GetBatchData();
var datas = ret;
if (datas != null)
{
GvBatch.DataSource = datas;
GvBatch.DataBind();
}
}
if (GridvData.Rows.Count > 0 && (Filter == "Filter1" || Filter == "Filter2"))
{
GridvData.UseAccessibleHeader = true;
GridvData.HeaderRow.TableSection = TableRowSection.TableHeader;
}
else if (GvBatch.Rows.Count > 0 && Filter == "Filter3")
{
GvBatch.UseAccessibleHeader = true;
GvBatch.HeaderRow.TableSection = TableRowSection.TableHeader;
}
}
private void RefreshGrid()
{
var ret = orderControls.GetDataByCreatedByAndComodity(CommonWeb.GetCurrentUser(), int.Parse(CmbKomoditas.SelectedValue));
var datas = ret.Result;
GridData.DataSource = datas;
GridData.DataBind();
if (GridData.Rows.Count > 0)
{
GridData.UseAccessibleHeader = true;
GridData.HeaderRow.TableSection = TableRowSection.TableHeader;
}
}
private void RefreshGridAll()
{
var ret = orderControls.GetDataByCreatedBy(CommonWeb.GetCurrentUser());
var datas = ret.Result;
GridData.DataSource = datas;
GridData.DataBind();
if (GridData.Rows.Count > 0)
{
GridData.UseAccessibleHeader = true;
GridData.HeaderRow.TableSection = TableRowSection.TableHeader;
}
}
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");
}
}
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 void RefreshGridData()
{
var myLab = CommonWeb.GetUserLab();
var retPenyelia = listGridMaster.GetDataGroupByCustomer(myLab);
var dataPenyelia = retPenyelia.Result;
GvCustomer.DataSource = dataPenyelia;
GvCustomer.DataBind();
lborder.Visible = false;
lblSampel.Visible = false;
GvPesanan.Visible = false;
GvData.Visible = false;
divParamUji.Visible = false;
btnBalikDah.Visible = false;
}
