public async Task <bool> UpdateData(string id, Elementservicestbl obj)
{
try
{
if (id != obj.ElementCode)
{
return(false);
}
using (var context = new smlpobDB())
{
context.Elementservicestbl.Attach(obj);
context.Entry(obj).Property(x => x.AnalysisTypeName).IsModified = true;
context.Entry(obj).Property(x => x.ServiceGroup).IsModified = true;
context.Entry(obj).Property(x => x.ServiceRate).IsModified = true;
context.Entry(obj).Property(x => x.ServiceStatus).IsModified = true;
context.Entry(obj).Property(x => x.ModBy).IsModified = true;
context.Entry(obj).Property(x => x.ModDate).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);
}
public async Task <bool> UpdateData(string id, employeetbl obj)
{
try
{
if (id != obj.employeeNo.ToString())
{
return(false);
}
using (var context = new smlpobDB())
{
context.employeetbls.Attach(obj);
context.Entry(obj).Property(x => x.employeeName).IsModified = true;
context.Entry(obj).Property(x => x.position).IsModified = true;
context.Entry(obj).Property(x => x.employeeEmail).IsModified = true;
context.Entry(obj).Property(x => x.derivativeToEmployee).IsModified = true;
context.Entry(obj).Property(x => x.accountNo).IsModified = true;
context.Entry(obj).Property(x => x.modBy).IsModified = true;
context.Entry(obj).Property(x => x.modDate).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);
}
public async Task <bool> UpdateData(string id, Comoditytbl obj)
{
try
{
if (id != obj.ComodityNo.ToString())
{
return(false);
}
using (var context = new smlpobDB())
{
context.Comoditytbl.Attach(obj);
context.Entry(obj).Property(x => x.ComodityName).IsModified = true;
context.Entry(obj).Property(x => x.DerivativeTo).IsModified = true;
context.Entry(obj).Property(x => x.Description).IsModified = true;
context.Entry(obj).Property(x => x.ModBy).IsModified = true;
context.Entry(obj).Property(x => x.ModDate).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);
}
public async Task <bool> AddData(standarddetailtbl obj)
{
try
{
using (var context = new smlpobDB())
{
var isExsist = (from x in context.standarddetailtbls
where x.elementId == obj.elementId &&
x.stdId == obj.stdId
select x).SingleOrDefault();
if (isExsist != null)
{
return(false);
}
context.standarddetailtbls.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);
}
public async Task <bool> AddData(Accounttbl obj)
{
try
{
using (var context = new smlpobDB())
{
var isExist = (from x in context.Accounttbl
where x.Username == obj.Username
select x).SingleOrDefault();
if (isExist != null)
{
return(false);
}
context.Accounttbl.Add(obj);
await context.SaveChangesAsync();
//Membership.CreateUser(obj.username, Crypto.Decrypt(obj.password), obj.username);
//Roles.AddUserToRole(obj.username, obj.roleName);
return(true);
}
}
catch (Exception ex)
{
LogHelpers.source = this.GetType().Name;
LogHelpers.message = ex.InnerException.ToString();
LogHelpers.user = "";
LogHelpers.WriteLog();
}
return(false);
}
public async Task <bool> DeleteData(string id)
{
int no = 0;
int.TryParse(id, out no);
try
{
using (var context = new smlpobDB())
{
var datas = from x in context.Customertbl
where x.CustomerNo == no
select x;
foreach (var item in datas)
{
context.Customertbl.Remove(item);
}
await context.SaveChangesAsync();
return(true);
}
}
catch (Exception ex)
{
LogHelpers.source = this.GetType().Name;
LogHelpers.message = ex.Message;
LogHelpers.user = currentUser;
LogHelpers.WriteLog();
}
return(false);
}
public async Task <bool> UpdateData(string id, Accounttbl obj)
{
try
{
if (id != obj.AccountNo.ToString())
{
return(false);
}
using (var context = new smlpobDB())
{
context.Accounttbl.Attach(obj);
context.Entry(obj).Property(x => x.Username).IsModified = true;
context.Entry(obj).Property(x => x.Password).IsModified = true;
context.Entry(obj).Property(x => x.RoleName).IsModified = true;
context.Entry(obj).Property(x => x.ModBy).IsModified = true;
context.Entry(obj).Property(x => x.ModDate).IsModified = true;
await context.SaveChangesAsync();
//MembershipUser ms = Membership.GetUser(obj.username);
//ms.ChangePassword(ms.ResetPassword(), Crypto.Decrypt(obj.password));
return(true);
}
}
catch (Exception ex)
{
LogHelpers.source = this.GetType().Name;
LogHelpers.message = ex.InnerException.ToString();
LogHelpers.user = "";
LogHelpers.WriteLog();
}
return(false);
}
public async Task <bool> UpdateDataDetail(int id, Orderanalysisdetailtbl obj)
{
try
{
if (id != obj.OrderDetailNo)
{
return(false);
}
using (var context = new smlpobDB())
{
context.Orderanalysisdetailtbl.Attach(obj);
context.Entry(obj).Property(x => x.OrderDetailNo).IsModified = true;
context.Entry(obj).Property(x => x.OrderNo).IsModified = true;
context.Entry(obj).Property(x => x.SampleNo).IsModified = true;
context.Entry(obj).Property(x => x.ElementId).IsModified = true;
context.Entry(obj).Property(x => x.ParametersNo).IsModified = true;
context.Entry(obj).Property(x => x.ElementValue).IsModified = true;
context.Entry(obj).Property(x => x.Status).IsModified = true;
context.Entry(obj).Property(x => x.Pic).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);
}
public async Task <bool> DeleteData(string id)
{
try
{
using (var context = new smlpobDB())
{
var datas = from x in context.orderanalysisdetailtbls
where x.orderNo == id
select x;
foreach (var item in datas)
{
context.orderanalysisdetailtbls.Remove(item);
}
await context.SaveChangesAsync();
return(true);
}
}
catch (Exception ex)
{
LogHelpers.source = this.GetType().Name;
LogHelpers.message = ex.Message;
LogHelpers.user = "";
LogHelpers.WriteLog();
}
return(false);
}
public async Task <bool> UpdateStatus(string id, string status)
{
try
{
using (var context = new smlpobDB())
{
var isExist = await context.ordermastertbls.FindAsync(id);
if (isExist == null)
{
return(false);
}
var obj = isExist;
obj.status = status;
context.ordermastertbls.Attach(obj);
context.Entry(obj).Property(x => x.status).IsModified = true;
context.Entry(obj).Property(x => x.modBy).IsModified = true;
context.Entry(obj).Property(x => x.modDate).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);
}
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 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();
}
}
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 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);
}
public async Task <bool> UpdateData(string id, Accounttbl obj)
{
try
{
if (id != obj.Username)
{
return(false);
}
using (var context = new smlpobDB())
{
context.Accounttbl.Attach(obj);
context.Entry(obj).Property(x => x.AccountNo).IsModified = true;
context.Entry(obj).Property(x => x.Username).IsModified = true;
context.Entry(obj).Property(x => x.Password).IsModified = true;
context.Entry(obj).Property(x => x.RoleName).IsModified = true;
context.Entry(obj).Property(x => x.IsEmailVerified).IsModified = true;
await context.SaveChangesAsync();
/*
* MembershipUser user = Membership.GetUser(obj.username);
* if (user != null)
* {
* user.IsApproved = true;
*
* user.UnlockUser();
* Membership.UpdateUser(user);
* }*/
return(true);
}
}
catch (Exception ex)
{
LogHelpers.source = this.GetType().Name;
LogHelpers.message = ex.Message;
LogHelpers.user = "";
LogHelpers.WriteLog();
}
return(false);
}
public async Task <bool> UpdateData(string id, ordersampletbl obj)
{
try
{
if (id != obj.noBalittanah)
{
return(false);
}
using (var context = new smlpobDB())
{
context.ordersampletbls.Attach(obj);
context.Entry(obj).Property(x => x.orderNo).IsModified = true;
context.Entry(obj).Property(x => x.sampleCode).IsModified = true;
context.Entry(obj).Property(x => x.countNumber).IsModified = true;
context.Entry(obj).Property(x => x.sampleDescription).IsModified = true;
context.Entry(obj).Property(x => x.samplingDate).IsModified = true;
context.Entry(obj).Property(x => x.village).IsModified = true;
context.Entry(obj).Property(x => x.subDistrict).IsModified = true;
context.Entry(obj).Property(x => x.district).IsModified = true;
context.Entry(obj).Property(x => x.province).IsModified = true;
context.Entry(obj).Property(x => x.longitude).IsModified = true;
context.Entry(obj).Property(x => x.latitude).IsModified = true;
context.Entry(obj).Property(x => x.landUse).IsModified = true;
context.Entry(obj).Property(x => x.isReceived).IsModified = true;
context.Entry(obj).Property(x => x.modBy).IsModified = true;
context.Entry(obj).Property(x => x.modDate).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);
}
public async Task <bool> AddData2(customertbl obj)
{
try
{
using (var context = new smlpobDB())
{
context.customertbls.Add(obj);
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> DeleteData(string id)
{
int no = 0;
int.TryParse(id, out no);
try
{
using (var context = new smlpobDB())
{
var emails = new HashSet <string>();
var datas = from x in context.Customertbl
where x.CustomerNo == no
select x;
foreach (var item in datas)
{
context.Customertbl.Remove(item);
emails.Add(item.CustomerEmail);
//Membership.DeleteUser(item.customerEmail);
}
var dataAcc = (from x in context.Accounttbl
where emails.Contains(x.Username)
select x).ToList();
foreach (var item in dataAcc)
{
context.Accounttbl.Remove(item);
}
await context.SaveChangesAsync();
return(true);
}
}
catch (Exception ex)
{
LogHelpers.source = this.GetType().Name;
LogHelpers.message = ex.Message;
LogHelpers.user = "";
LogHelpers.WriteLog();
}
return(false);
}
public async Task <bool> UpdateData(string id, standarddetailtbl obj)
{
try
{
if (id != obj.stdId.ToString())
{
return(false);
}
using (var context = new smlpobDB())
{
var isExsist = (from x in context.standarddetailtbls
where x.elementId == obj.elementId &&
x.stdId == obj.stdId
select x).SingleOrDefault();
if (isExsist != null)
{
return(false);
}
context.standarddetailtbls.Attach(obj);
context.Entry(obj).Property(x => x.stdId).IsModified = true;
context.Entry(obj).Property(x => x.elementId).IsModified = true;
context.Entry(obj).Property(x => x.modBy).IsModified = true;
context.Entry(obj).Property(x => x.modDate).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);
}
public async Task <bool> UpdateData(string id, Parameterstbl obj)
{
try
{
if (id != obj.ParametersNo.ToString())
{
return(false);
}
using (var context = new smlpobDB())
{
context.Parameterstbl.Attach(obj);
context.Entry(obj).Property(x => x.String0).IsModified = true;
context.Entry(obj).Property(x => x.String1).IsModified = true;
context.Entry(obj).Property(x => x.String2).IsModified = true;
context.Entry(obj).Property(x => x.String3).IsModified = true;
context.Entry(obj).Property(x => x.String4).IsModified = true;
context.Entry(obj).Property(x => x.String5).IsModified = true;
context.Entry(obj).Property(x => x.String6).IsModified = true;
context.Entry(obj).Property(x => x.String7).IsModified = true;
context.Entry(obj).Property(x => x.String8).IsModified = true;
context.Entry(obj).Property(x => x.String9).IsModified = true;
context.Entry(obj).Property(x => x.ModBy).IsModified = true;
context.Entry(obj).Property(x => x.ModDate).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);
}
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> UpdateData(string id, reviewingtbl obj)
{
try
{
if (id != obj.reviewingNo.ToString())
{
return(false);
}
using (var context = new smlpobDB())
{
context.reviewingtbls.Attach(obj);
context.Entry(obj).Property(x => x.orderNo).IsModified = true;
context.Entry(obj).Property(x => x.elementCodeList).IsModified = true;
context.Entry(obj).Property(x => x.reviewingDate).IsModified = true;
context.Entry(obj).Property(x => x.isLabUtilitySurfficient).IsModified = true;
context.Entry(obj).Property(x => x.isHumanResourceSurfficient).IsModified = true;
context.Entry(obj).Property(x => x.isChemicalMaterialSurfficent).IsModified = true;
context.Entry(obj).Property(x => x.isVolumeCorrect).IsModified = true;
context.Entry(obj).Property(x => x.workdays).IsModified = true;
context.Entry(obj).Property(x => x.isMethode).IsModified = true;
context.Entry(obj).Property(x => x.isQualityStandard).IsModified = true;
context.Entry(obj).Property(x => x.modBy).IsModified = true;
context.Entry(obj).Property(x => x.modDate).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);
}
public async Task <bool> AddData(Roletbl obj)
{
try
{
using (var context = new smlpobDB())
{
context.Roletbl.Add(obj);
await context.SaveChangesAsync();
//Roles.CreateRole(obj.roleName);
return(true);
}
}
catch (Exception ex)
{
LogHelpers.source = this.GetType().Name;
LogHelpers.message = ex.Message;
LogHelpers.user = "";
LogHelpers.WriteLog();
}
return(false);
}
public async Task <bool> UpdateData(string id, Ordermastertbl obj)
{
try
{
if (id != obj.OrderNo)
{
return(false);
}
using (var context = new smlpobDB())
{
context.Ordermastertbl.Attach(obj);
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.IsPaid).IsModified = true;
context.Entry(obj).Property(x => x.ApprPenyelia).IsModified = true;
context.Entry(obj).Property(x => x.ModBy).IsModified = true;
context.Entry(obj).Property(x => x.ModDate).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);
}
public async Task <bool> UpdateData(string id, Customertbl obj)
{
try
{
if (id != obj.CustomerNo.ToString())
{
return(false);
}
using (var context = new smlpobDB())
{
context.Customertbl.Attach(obj);
context.Entry(obj).Property(x => x.CustomerName).IsModified = true;
context.Entry(obj).Property(x => x.CustomerEmail).IsModified = true;
context.Entry(obj).Property(x => x.CompanyName).IsModified = true;
context.Entry(obj).Property(x => x.CompanyAddress).IsModified = true;
context.Entry(obj).Property(x => x.CompanyPhone).IsModified = true;
context.Entry(obj).Property(x => x.CompanyEmail).IsModified = true;
context.Entry(obj).Property(x => x.AccountNo).IsModified = true;
context.Entry(obj).Property(x => x.ModBy).IsModified = true;
context.Entry(obj).Property(x => x.ModDate).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);
}
public async Task <bool> DeleteData(string id)
{
int no = 0;
int.TryParse(id, out no);
try
{
using (var context = new smlpobDB())
{
var name = (from x in context.Accounttbl
where x.AccountNo == no
select x.Username).SingleOrDefault();
var datas = from x in context.Accounttbl
where x.AccountNo == no
select x;
foreach (var item in datas)
{
context.Accounttbl.Remove(item);
}
await context.SaveChangesAsync();
//Membership.DeleteUser(name);
return(true);
}
}
catch (Exception ex)
{
LogHelpers.source = this.GetType().Name;
LogHelpers.message = ex.InnerException.ToString();
LogHelpers.user = "";
LogHelpers.WriteLog();
}
return(false);
}
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");
}
}
}
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.Ordermastertbl.Add(order);
foreach (var data in sample)
{
//data.orderNo = id;
data.IsReceived = "0";
context.Ordersampletbl.Add(data);
}
foreach (var data in detail)
{
context.Orderanalysisdetailtbl.Add(data);
}
foreach (var data in element)
{
//data.orderNo = id;
context.Orderpricedetailtbl.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);
}
public string AutoGenerateSample(string komoditas, string analisis)
{
try
{
int no = int.Parse(komoditas);
string cmdt = "";
using (var context = new smlpobDB())
{
var kmd = (from x in context.Comoditytbl
where x.ComodityNo == no
select x.ComodityName).AsNoTracking().SingleOrDefault();
cmdt = kmd;
}
string id = "";
string kodeKomoditas = "";
string kodeAnalisis = "";
// kode komoditas
if (cmdt.Contains("Pupuk Organik"))
{
kodeKomoditas = "Po.";
}
else if (cmdt.Contains("Pupuk Anorganik"))
{
kodeKomoditas = "Pa.";
}
else if (cmdt.Contains("Tanah"))
{
kodeKomoditas = "Th.";
}
else if (cmdt.Contains("Air"))
{
kodeKomoditas = "A.";
}
else if (cmdt.Contains("Tanaman"))
{
kodeKomoditas = "Tn.";
}
// kode analisis
if (analisis.Contains("Kimia"))
{
kodeAnalisis = "K.";
}
else if (analisis.Contains("Biologi"))
{
kodeAnalisis = "B.";
}
else if (analisis.Contains("Fisika"))
{
kodeAnalisis = "F.";
}
using (var context = new smlpobDB())
{
var data = (from x in context.Ordersampletbl
.OrderByDescending(x => x.NoBalittanah)
where x.NoBalittanah.Contains(kodeKomoditas) &&
x.NoBalittanah.Contains(kodeAnalisis)
select x.NoBalittanah).AsNoTracking().SingleOrDefault();
if (data != null)
{
string[] strSplit = data.Split('.');
int noUrut1 = int.Parse(strSplit[2]);
int noUrut2 = int.Parse(strSplit[5]);
string newNoUrut1 = (noUrut1 + 1).ToString();
string newNoUrut2 = (noUrut2 + 1).ToString();
id = DatetimeHelper.GetYearNow() + "." + DatetimeHelper.GetMonthNow() + "." + newNoUrut1 +
"." + kodeAnalisis + kodeKomoditas + newNoUrut2;
}
else
{
id = DatetimeHelper.GetYearNow() + "." + DatetimeHelper.GetMonthNow() + "." + "1" +
"." + kodeAnalisis + kodeKomoditas + "1";
}
var sample = new Ordersampletbl
{
NoBalittanah = id,
SampleCode = "",
};
context.Ordersampletbl.Add(sample);
context.SaveChangesAsync();
return(id);
}
}
catch (Exception ex)
{
LogHelpers.source = this.GetType().Name;
LogHelpers.message = ex.Message;
LogHelpers.user = currentUser;
LogHelpers.WriteLog();
}
return(null);
}