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);
}
