public void InsertBillData(VoygerBillWithLinq voygerBill) { VoyBill bill = voygerBill.bill; List <LineItems> lineItemList = voygerBill.lineItems; List <VPaymentMode> paymentList = voygerBill.payModes; ConnectLinqDataBase(); var v = from vyb in voyDatabase.VoyBill where vyb.BillNumber == bill.BillNumber && vyb.BillTime == bill.BillTime select new { vyb.ID }; if (v.Count() > 0) { Console.WriteLine("Invoice all ready Present in file"); return; } voyDatabase.VoyBill.InsertOnSubmit(bill); voyDatabase.SubmitChanges(); foreach (LineItems item in lineItemList) { item.VoyBillId = bill.ID; voyDatabase.LineItems.InsertOnSubmit(item); } foreach (VPaymentMode item in paymentList) { item.VoyBillId = bill.ID; voyDatabase.VPaymentMode.InsertOnSubmit(item); } InsertDataLog dataLog = new InsertDataLog() { BillNumber = bill.BillNumber, Remark = "First Step", VoyBillId = bill.ID, }; voyDatabase.InsertDataLogs.InsertOnSubmit(dataLog); voyDatabase.SubmitChanges(); }
private async Task <Uri> AddBill(VoyagerBillInfo bill) { HttpResponseMessage response = await client.PostAsJsonAsync("api/VoyagerBills", bill); LogEvent.WriteEvent("Header:" + response.Headers.ToString()); LogEvent.WriteEvent("Content:" + response.Content.ToString()); LogEvent.WriteEvent("Status Code:" + response.StatusCode.ToString()); response.EnsureSuccessStatusCode(); if (response.IsSuccessStatusCode) { LogEvent.WriteEvent("Invocie is saved: " + bill.InvoiceNo); using (VoyagerContext db = new VoyagerContext()) { InsertDataLog log = db.InsertDataLogs.Where(c => c.BillNumber == bill.InvoiceNo).FirstOrDefault(); log.Remark = response.Content.ToString(); db.Entry(log).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } } return(response.Headers.Location); }
public void InsertBillData(VoygerBill voygerBill) { if (voygerBill != null) { if (voygerBill.bill.BillType != null) { LogEvent.WriteEvent("bill tye: " + voygerBill.bill.BillType); } } VoyBill bill = voygerBill.bill; List <LineItem> lineItemList = voygerBill.lineItems; List <VPaymentMode> paymentList = voygerBill.payModes; VoyagerContext voyDatabase; using (voyDatabase = new VoyagerContext()) { // TODO:Need to Check line below here var v = from vyb in voyDatabase.VoyBills where vyb.BillNumber == bill.BillNumber && vyb.BillTime == bill.BillTime select new { vyb.VoyBillId }; if (v.Count() > 0) { LogEvent.WriteEvent($"Invoice all ready Present in file {v.FirstOrDefault().VoyBillId},{bill.BillNumber}"); return; } else { LogEvent.WriteEvent($"Invoice is new with bill no {bill.BillNumber}"); } voyDatabase.VoyBills.Add(bill); if (voyDatabase.SaveChanges() > 0) { LogEvent.WriteEvent($"Bill with ID: {bill.VoyBillId} is saved!!! "); } else { LogEvent.WriteEvent("bill is not Saved"); } foreach (LineItem item in lineItemList) { item.VoyBillId = bill.VoyBillId; voyDatabase.LineItems.Add(item); } // LogEvent.WriteEvent("Inserted LinesItem"); foreach (VPaymentMode item in paymentList) { item.VoyBillId = bill.VoyBillId; voyDatabase.VPaymentModes.Add(item); } // LogEvent.WriteEvent("Inserted payments"); InsertDataLog dataLog = new InsertDataLog() { BillNumber = bill.BillNumber, Remark = "First Step", VoyBillId = bill.VoyBillId, }; LogEvent.WriteEvent("Inserted Datalog,payments,LinesItem,payments"); voyDatabase.InsertDataLogs.Add(dataLog); voyDatabase.SaveChanges(); LogEvent.WriteEvent("VoyBill is added with BillId: [" + bill.VoyBillId + "]and BillNo: [" + bill.BillNumber + "]"); } }
partial void DeleteInsertDataLog(InsertDataLog instance);
partial void UpdateInsertDataLog(InsertDataLog instance);
partial void InsertInsertDataLog(InsertDataLog instance);