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> 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> 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);
}
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> UpdateDataDetail(int id, orderanalysisdetailtbl obj)
{
try
{
if (id != obj.orderDetailNo)
{
return(false);
}
using (var context = new smlpobDB())
{
context.orderanalysisdetailtbls.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> UpdateData(string id, Orderanalysisdetailtbl obj)
{
try
{
if (id != obj.OrderDetailNo.ToString())
{
return(false);
}
using (var context = new smlpobDB())
{
context.Orderanalysisdetailtbl.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);
}
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, 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, 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, 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, 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> 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.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, 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> 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, 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> 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);
}