//void checkmenu()
//{
// permission NewItem = null;
// var IDS = (from x in context.permissions
// select x).ToList();
// string path = HttpContext.Current.Request.Url.AbsolutePath;
// string loginrole = Roles.GetRolesForUser().FirstOrDefault();
// foreach (GridViewRow row in GvData.Rows)
// {
// if (IDS.Any(x => x.Role == loginrole) && IDS.Any(x => x.PageUrl == path))
// {
// NewItem = (from x in IDS
// where x.Role == loginrole && x.PageUrl == path
// select x).FirstOrDefault();
// if (NewItem == null)
// {
// Response.Redirect("/Pages/Private/DenyAccess.aspx");
// }
// else
// {
// ((LinkButton)row.Cells[0].FindControl("Edit")).Visible = NewItem.CanEdit.Value;
// ((LinkButton)row.Cells[0].FindControl("Lihat")).Visible = NewItem.CanView.Value;
// ((LinkButton)row.Cells[0].FindControl("Delete")).Visible = NewItem.CanDelete.Value;
// BtnAdd.Visible = NewItem.CanAdd.Value;
// }
// }
// }
//}
private void GvData_RowCommand(object sender, GridViewCommandEventArgs e)
{
var IDS = Convert.ToInt32(e.CommandArgument);
switch (e.CommandName)
{
case "Ubah":
SetLayout(ModeForm.EditData);
LoadDetail(IDS);
break;
case "Hapus":
var datas = from x in context.standardtbls
where x.stdId == IDS
select x;
foreach (var item in datas)
{
context.standardtbls.Remove(item);
}
context.SaveChanges();
RefreshGrid();
break;
case "Lihat":
SetLayout(ModeForm.LihatData);
LoadDetail(IDS);
break;
}
}
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.");
}
}
}
public bool UpdatePayment(string orderNo, string StatusPembayaran, string TipePembayaran)
{
try
{
using (var db = new smlpobDB())
{
var selMaster = (from x in db.ordermastertbls
where x.orderNo == orderNo
select x).FirstOrDefault();
if (selMaster != null)
{
selMaster.paymentStatus = StatusPembayaran;
selMaster.statusType = TipePembayaran;
if (StatusPembayaran != "Belum dibayar")
{
selMaster.status = "Barcode Sampel";
selMaster.isPaid = "1";
}
else
{
selMaster.isPaid = "0";
}
db.SaveChanges();
}
}
return(true);
}
catch
{
return(false);
}
}
public bool SimpanDataBatch(batchtbl newData, IEnumerable <string> OrderNos)
{
try
{
HashSet <string> Orders = new HashSet <string>();
OrderNos.ToList().ForEach(x => Orders.Add(x));
using (var context = new smlpobDB())
{
context.batchtbls.Add(newData);
var datas = from x in context.ordermastertbls
where Orders.Contains(x.orderNo)
select x;
foreach (var item in datas)
{
item.batchId = newData.batchId;
item.status = "Proses Lab";
}
context.SaveChanges();
return(true);
}
}
catch (Exception ex)
{
LogHelpers.source = this.GetType().Name;
LogHelpers.message = ex.Message;
LogHelpers.user = "";
LogHelpers.WriteLog();
}
return(false);
}
public bool DeleteData(object Id)
{
if (Id is int FID)
{
var data = from x in db.Accounttbl
where x.AccountNo == FID
select x;
foreach (var item in data)
{
db.Accounttbl.Remove(item);
}
db.SaveChanges();
return(true);
}
return(false);
}
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 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)
{
GetTranslation();
BtnCancel.Click += (a, b) => { DivPayment.Visible = false; PanelGridMasuk.Visible = true; };
BtnSave.Click += (a, b) =>
{
var payId = Convert.ToInt32(HidPaymentID.Value);
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[2];
data.isPaid = "1";
data.paymentStatus = StatusPembayaranCmb.SelectedValue.ToString();
data.statusType = TipePembayaranCmb.SelectedValue.ToString();
data.status = Status.OrderStatus[1];
}
payment.status = "Diterima";
db.SaveChanges();
PanelGridMasuk.Visible = true;
DivPayment.Visible = false;
RefreshGrid();
SendMailToCS(payment, data);
}
}
};
GvData.RowDataBound += GvData_RowDataBound;
GvData.RowCommand += GvData_RowCommand;
if (!IsPostBack)
{
StatusPembayaranCmb.Items.Clear();
StatusPembayaranCmb.Items.Add(new ListItem(Status.PaymentStatus[2], Status.PaymentStatus[2]));
StatusPembayaranCmb.Items.Add(new ListItem("DP", "DP"));
TipePembayaranCmb.Items.Clear();
TipePembayaranCmb.Items.Add(new ListItem("Penelitian", "Penelitian"));
TipePembayaranCmb.Items.Add(new ListItem("PNBP", "PNBP"));
TipePembayaranCmb.Items.Add(new ListItem("Khusus", "Khusus"));
RefreshGrid();
}
this.GvData.DataBound += (object o, EventArgs ev) =>
{
GvData.HeaderRow.TableSection = TableRowSection.TableHeader;
};
}
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;
}
}
public long Increment(string NameSet)
{
lock (locker)
{
try
{
using (var db = new smlpobDB())
{
var data = (from x in db.Autonumbertbl
where x.NameSet == NameSet
select x).FirstOrDefault();
if (data != null)
{
var last = data.LastCounter + 1;
data.LastCounter = last;
db.SaveChanges();
return(last);
}
else
{
var newItem = new Autonumbertbl()
{
LastCounter = 1, NameSet = NameSet
};
db.Autonumbertbl.Add(newItem);
db.SaveChanges();
return(newItem.LastCounter);
}
}
}
catch
{
return(0);
}
}
}
void ChangeOrderMasterStatus()
{
using (var db = new smlpobDB()) {
var isNotCompleted = db.orderanalysisdetailtbls.Any(x => x.orderNo == txtOrderNo.Text && x.status != "Diproses");
if (!isNotCompleted)
{
var master = db.ordermastertbls.Where(x => x.orderNo == txtOrderNo.Text).FirstOrDefault();
if (master != null)
{
master.status = Status.OrderStatus[5];
db.SaveChanges();
}
}
}
}
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");
}
}
}
protected void BtnApprove_Click(object sender, EventArgs e)
{
using (var db = new smlpobDB())
{
var data = (from x in db.ordermastertbls
where x.orderNo == lblorder.Text
select x).FirstOrDefault();
if (data != null)
{
data.status = "LHP Keluar";
db.SaveChanges();
Response.Redirect("CustomerServiceBeranda.aspx");
}
else
{
CommonWeb.Alert(this, "Gagal approve, terjadi kesalahan system.");
}
}
}
private void ChangeReceiveStatus()
{
try
{
bool IsSucceed = false;
using (var db = new smlpobDB())
{
foreach (GridViewRow dr in GvData.Rows)
{
var NoBalitTanah = dr.Cells[2].Text.Trim();
var item = db.ordersampletbls.Where(x => x.noBalittanah == NoBalitTanah && x.orderNo == lblorder.Text).FirstOrDefault();
var chkVal = (dr.FindControl("ChkReceived") as CheckBox).Checked;
if (item != null)
{
item.isReceived = chkVal ? "1" : "0";
db.SaveChanges();
}
}
IsSucceed = true;
}
if (IsSucceed)
{
CommonWeb.Alert(this, "Perubahan status penerimaan sampel berhasil.");
Response.Redirect("CustomerServiceBeranda.aspx");
}
else
{
CommonWeb.Alert(this, "Gagal mengubah status penerimaan sampel");
}
}
catch (Exception ex)
{
LogHelpers.source = this.GetType().ToString();
LogHelpers.message = "Error Set Penerimaan Sampel:" + ex.Message;
LogHelpers.user = CommonWeb.GetCurrentUser();
LogHelpers.WriteLog();
}
}
public static void WriteLog()
{
try
{
using (var context = new smlpobDB())
{
var log = new Logtbl()
{
Source = source,
Description = message,
CreaBy = user,
CreaDate = DatetimeHelper.GetDatetimeNow()
};
context.Logtbl.Add(log);
context.SaveChanges();
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
protected void BtnApprove_Click(object sender, EventArgs e)
{
using (var db = new smlpobDB())
{
var data = (from x in db.ordermastertbls
where x.orderNo == lblorder.Text
select x).FirstOrDefault();
if (data != null)
{
data.status = Status.OrderStatus[7];
db.SaveChanges();
var context = GlobalHost.ConnectionManager.GetHubContext <NotificationHub>();
context.Clients.All.PushNotification("All", "Pesanan no " + lblorder.Text + " telah disetujui", "https://silpo.id");
Response.Redirect("Dash_ManagerTeknis.aspx");
}
else
{
CommonWeb.Alert(this, "Gagal approve, terjadi kesalahan system.");
}
}
}
protected async void BtnDaftar_Click(object sender, EventArgs e)
{
try
{
if (!string.IsNullOrEmpty(txtemail.Text))
{
var seldata = context.customertbls.Where(x => x.customerEmail == txtemail.Text).ToList();
if (seldata != null && seldata.Count > 0)
{
CommonWeb.Alert(this, "Email ini sudah terdaftar");
}
else
{
try
{
//register to asp membership first!
MembershipUser user = Membership.CreateUser(txtemail.Text, txtpassword.Text, txtemail.Text);
//account
string pwd = Crypto.Encrypt(txtpassword.Text);
var NewItem = new accounttbl()
{
username = txtemail.Text,
password = pwd,
roleName = "pelanggan",
creaBy = "registration system",
creaDate = DatetimeHelper.GetDatetimeNow(),
isEmailVerified = "0"
};
//customers
var IDS = txtemail.Text;
var idacc = (from x in context.accounttbls
where x.username == IDS
select x.accountNo).FirstOrDefault();
var NewItem2 = new customertbl()
{
customerName = txtusername.Text,
customerEmail = txtemail.Text,
companyName = txtcompanyname.Text,
companyAddress = txtaddress.Text,
companyPhone = txtphone.Text,
companyEmail = txtcompanyemail.Text,
accountNo = idacc,
creaBy = "registration system",
creaDate = DatetimeHelper.GetDatetimeNow()
};
context.accounttbls.Add(NewItem);
context.customertbls.Add(NewItem2);
context.SaveChanges();
var roleFromAccountTable = registerControls.GetRole(txtemail.Text);
string role = roleFromAccountTable;
Roles.AddUserToRole(txtemail.Text, role);
//kirim email
var subject = "Aktivasi Akun untuk Sistem Informasi Pelayanan Online Balitanah";
var mainMessage = "Silahkan klik link berikut untuk mengaktivasi akun anda:";
var message = mainMessage + $"<br> <a href='{ConfigurationManager.AppSettings["RootWebUrl"]}/Pages/Public/Activation.aspx?userId={txtemail.Text}'>Aktivasi Akun</a>";
var msgPhone = mainMessage + $" { ConfigurationManager.AppSettings["RootWebUrl"]}/Pages/Public/Activation.aspx?userId={txtemail.Text}";
var ret = EmailService.SendEmail(subject, message, txtemail.Text);
await SmsService.SendSms(msgPhone, txtphone.Text);
//var userAdded = Membership.GetUser(txtemail.Text);
//if (userAdded != null)
//{
// userAdded.IsApproved = true;
// userAdded.UnlockUser();
// Membership.UpdateUser(userAdded);
//}
Response.Redirect("RegisterDone.aspx", false);
Context.ApplicationInstance.CompleteRequest();
}
catch (Exception ex)
{
TxtStatus.Text = "Gagal menyimpan data registrasi, silakan isi dengan lengkap data-data yang diperlukan.";
LogHelpers.source = this.GetType().ToString();
LogHelpers.message = "fail to register user:"******"Gagal menyimpan data registrasi, silakan isi dengan lengkap data-data yang diperlukan.";
}
}
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 void GvData_RowCommand(object sender, GridViewCommandEventArgs e)
{
var IDS = e.CommandArgument.ToString();
switch (e.CommandName)
{
case "lihat":
Response.Redirect("CustomerServiceDetail.aspx?value=" + IDS + "&State=" + FormState + "&Mode=" + e.CommandName);
break;
case "terima-sampel":
Response.Redirect("CustomerServiceDetail.aspx?value=" + IDS + "&State=" + FormState + "&Mode=" + e.CommandName);
break;
case "proses-lab":
using (var db = new smlpobDB())
{
var valdata = (from w in db.ordersampletbls
where w.orderNo == IDS
select w.isReceived).FirstOrDefault();
if (valdata == "1")
{
var data = (from x in db.ordermastertbls
where x.orderNo == IDS
select x).FirstOrDefault();
if (data != null)
{
data.status = Status.OrderStatus[2];
data.isOnLab = "1";
db.SaveChanges();
GoSearch();
CommonWeb.Alert(this, "Data sudah diproses ke lab.");
}
}
else
{
CommonWeb.Alert(this, "Proses ke Lab gagal. Harap terima sampel terlebih dahulu");
}
}
//Response.Redirect("CustomerServiceDetail.aspx?value=" + IDS + "&State=" + FormState + "&Mode=" + e.CommandName);
break;
case "kirim-notif":
//Send notif tuk customer
using (var db = new smlpobDB())
{
var data = (from x in db.ordermastertbls.Include(c => c.customertbl)
where x.orderNo == IDS
select x).FirstOrDefault();
if (data != null)
{
if (!string.IsNullOrEmpty(data.customertbl.customerEmail))
{
EmailService.SendEmail($"LHP dengan No: {data.orderNo} Sudah Dapat Diambil di BalitTanah", $"Yth. Bpk/Ibu {data.customertbl.customerName}, <br/>LHP dengan No: {data.orderNo} Sudah Dapat Diambil di BalitTanah. Silakan kunjungi situs web kami untuk melihat status order Anda pada tautan berikut : {ConfigurationManager.AppSettings["RootWebUrl"]} <br/> Terima Kasih <br/> Hormat Kami, <br/>Balai Penelitian Tanah", data.customertbl.customerEmail, true);
SmsService.SendSms($"Yth. Bpk/Ibu {data.customertbl.customerName}, <br/>LHP dengan No: {data.orderNo} Sudah Dapat Diambil di BalitTanah. Silakan kunjungi situs web kami untuk melihat status order Anda pada tautan berikut : {ConfigurationManager.AppSettings["RootWebUrl"]} <br/> Terima Kasih <br/> Hormat Kami, <br/>Balai Penelitian Tanah", data.customertbl.companyPhone).GetAwaiter().GetResult();
CommonWeb.Alert(this, "Notifikasi sudah dikirim ke customer.");
}
}
}
break;
case "cetak-barcode":
Response.Redirect("CetakBarcodeSampel.aspx?value=" + IDS + "&State=" + FormState + "&Mode=" + e.CommandName);
break;
case "ambil-lhp":
using (var db = new smlpobDB())
{
var data = (from x in db.ordermastertbls.Include(c => c.customertbl)
where x.orderNo == IDS
select x).FirstOrDefault();
if (data != null)
{
data.status = Status.OrderStatus[8];
db.SaveChanges();
CommonWeb.Alert(this, "Update status LHP berhasil.");
GoSearch();
}
}
break;
}
}