// POST: paymenttbls/Create
// To protect from overposting attacks, please enable the specific properties you want to bind to, for
// more details see https://go.microsoft.com/fwlink/?LinkId=317598.
// GET: paymenttbls/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
paymenttbl paymenttbl = db.paymenttbl.Find(id);
if (paymenttbl == null)
{
return(HttpNotFound());
}
return(View(paymenttbl));
}
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);
}
}
}
public ActionResult DeleteCheck(RequestPay model)
{
paymenttbl paymenttbl = new paymenttbl();
paymenttbl.payid = model.payid;
paymenttbl.mid = model.mid;
paymenttbl.name = model.name;
paymenttbl.phone = model.phone;
paymenttbl.addr = model.addr;
paymenttbl.pay = model.payid;
paymenttbl.paydate = model.paydate;
paymenttbl.memo = model.memo;
db.Entry(paymenttbl).State = System.Data.Entity.EntityState.Deleted;
db.paymenttbl.Remove(paymenttbl);
db.SaveChanges();
var data = db.paymenttbl.Where(x => x.payid.Equals(paymenttbl.payid)).Select(x => new RequestPay
{
payid = x.payid,
mid = x.mid,
name = x.name,
phone = x.phone,
addr = x.addr,
pay = x.payid,
paydate = x.paydate,
memo = x.memo
}).OrderBy(x => x.payid).ToPagedList(1, l_pageSize);
var viewModel = new paymenttblsViewModel
{
RequestPay = data,
PageIndex = 1
};
return(View("Index", viewModel));
}
protected void Page_Load(object sender, EventArgs e)
{
BtnUpload.Click += async(a, b) => {
if (!FileUpload1.HasFile)
{
CommonWeb.Alert(this, "Silakan pilih file bukti pembayaran terlebih dahulu.");
return;
}
//upload file
//var pathTarget = Server.MapPath("~/Document/Payment");
//var tempFile = shortid.ShortId.Generate(true, false, 10)+Path.GetExtension(FileUpload1.FileName);
//var fileName = pathTarget + "//" + tempFile;
string nameFile = "payment_" + 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;
HidUrlBukti.Value = fileurl;
ImgLampiran.Src = fileurl;
ImgLampiran.Visible = true;
};
BtnCancel.Click += (a, b) => { Response.Redirect("CustomerBeranda.aspx"); };
BtnSave.Click += async(a, b) =>
{
if (string.IsNullOrEmpty(HidUrlBukti.Value))
{
CommonWeb.Alert(this, "Silakan upload bukti pembayaran terlebih dahulu.");
return;
}
var LampiranUrl = "";
if (FileUploadLampiran.HasFile)
{
string nameFile = "lampiran_bayar_" + CommonWeb.GetCurrentUser()
+ "_" + DateTime.Now.ToString("ddMMMyyyy")
+ "_" + shortid.ShortId.Generate(true, false)
+ Path.GetExtension(FileUploadLampiran.FileName);
await CloudStorage.BlobPostAsync(FileUploadLampiran.FileBytes, nameFile);
var urllampiran = ConfigurationManager.AppSettings["DefaultBlobRootUrl"] + nameFile;
LampiranUrl = urllampiran;
}
var fileurl = HidUrlBukti.Value;
using (var db = new smlpobDB())
{
var newItem = new paymenttbl()
{
attachmentUrl = LampiranUrl, accountName = TxtNamaRekening.Text, accountNo = TxtNoRekening.Text, amount = Convert.ToDecimal(TxtJumlahTransfer.Text), bankName = CmbBankPengirim.SelectedValue, name = lblcusname.Text, orderNo = lblnoPesanan.Text, paymentReceiptUrl = fileurl, status = Status.PaymentStatus[1]
};
var orderNo = lblnoPesanan.Text;
if (!string.IsNullOrEmpty(orderNo))
{
var dataOrder = (from x in db.ordermastertbls.Include(c => c.comoditytbl)
where x.orderNo == orderNo
select x).FirstOrDefault();
if (dataOrder != null)
{
if (Convert.ToDecimal(TxtJumlahTransfer.Text) < Convert.ToDecimal(LitTotBiaya.Text))
{
CommonWeb.Alert(this, "Nilai yang ditransfer harus sesuai.");
return;
}
dataOrder.paymentStatus = Status.PaymentStatus[1];
db.paymenttbls.Add(newItem);
await db.SaveChangesAsync();
CommonWeb.Alert(this, "Pembayaran di proses");
BtnSave.Visible = false;
}
CommonWeb.Alert(this, "Gagal proses, terjadi kesalahan");
}
}
};
if (!IsPostBack)
{
string[] Banks =
{
"Bank Rakyat Indonesia (BRI)",
"Bank Mandiri",
"Bank Central Asia (BCA)",
"Bank Negara Indonesia (BNI)",
"Bank Tabungan Negara (BTN)",
"Bank CIMB Niaga",
"Bank Panin",
"Bank OCBC NISP",
"Bank Danamon Indonesia",
"Bank Permata",
"Bank Maybank Indonesia",
"Lainnya"
};
CmbBankPengirim.DataSource = Banks;
CmbBankPengirim.DataBind();
GetTranslation();
var orderNo = Request.QueryString["orderNo"];
if (!string.IsNullOrEmpty(orderNo))
{
using (var db = new smlpobDB())
{
var dataOrder = (from x in db.ordermastertbls.Include(c => c.comoditytbl)
where x.orderNo == orderNo
select x).FirstOrDefault();
if (dataOrder != null)
{
lblTanggal.Text = dataOrder.creaDate?.ToString("MM-dd-yyyy");
lblnoPesanan.Text = dataOrder.orderNo;
lblKomoditas.Text = dataOrder.comoditytbl.comodityName;
lbljenisAnalisis.Text = dataOrder.analysisType;
var uname = CommonWeb.GetCurrentUser();
var cust = (from x in db.customertbls
where x.customerEmail == uname
select x).FirstOrDefault();
if (cust != null)
{
lblcusname.Text = cust.customerName;
lblInstansi.Text = cust.companyName;
}
var dataDetail = from x in db.orderanalysisdetailtbls
where x.orderNo == orderNo
select new { x.elementId };
var totalParam = dataDetail.Distinct().Count();
LitJmlParamUji.Text = totalParam.ToString("n0");
LitJmlSampel.Text = dataOrder.sampleTotal?.ToString("n0");
LitTotBiaya.Text = dataOrder.priceTotal?.ToString("n0");
}
}
}
else
{
CommonWeb.Alert(this, "Tidak ada order no - tidak ada order yang bisa di bayar");
}
}
}
