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.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> AddData(Ordermastertbl obj) { try { using (var context = new smlpobDB()) { context.Ordermastertbl.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> 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> 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); }