public HttpResponseMessage SynInvoiceClientToServer(string LoginName, string Password, int StoreID, NailSyn.DataAccess.Model.InvoiceClient dataInvoice) { bool IsResult = false; SynDataClientToServer _cls = new SynDataClientToServer(); IsResult = _cls.SynInvoiceClientToServer(LoginName, Password, StoreID, dataInvoice); if (IsResult) return Request.CreateResponse(HttpStatusCode.OK, true); else return Request.CreateErrorResponse(HttpStatusCode.ExpectationFailed, "Not ok"); }
public bool SynInvoiceClientToServer(string LoginName, string Password, int StoreID, NailSyn.DataAccess.Model.InvoiceClient dataInvoice) { try { using (var db = new NailShopEntities()) { using (TransactionScope transcope = new TransactionScope()) { try { NailShop.DataAccess.Invoice _invoice; foreach (NailSyn.DataAccess.SynInvoiceClient row in dataInvoice.ListInvoice) { var select = from c in db.Invoices where c.StoreID == StoreID && c.LocalID == row.InvoiceID select c; if (select.Count() == 0) { if (row.RecordState == (int)Enum.RecordState.AddNew) { _invoice = new Invoice(); _invoice.LocalID = row.InvoiceID; _invoice.StoreID = StoreID; _invoice.IsPaid = row.IsPaid; _invoice.IsPending = row.IsPending; _invoice.InvoiceDate = row.InvoiceDate; _invoice.InvoiceNo = row.InvoiceNo; _invoice.BusinessName = row.BusinessName; _invoice.Address = row.Address; _invoice.City = row.City; _invoice.State = row.City; _invoice.ZipCode = row.ZipCode; _invoice.AddressAddr1 = row.AddressAddr1; _invoice.AddressAddr2 = row.AddressAddr2; _invoice.AddressAddr3 = row.AddressAddr3; _invoice.AddressAddr4 = row.AddressAddr4; _invoice.AddressAddr5 = row.AddressAddr5; _invoice.AddressAddr1S = row.AddressAddr1S; _invoice.AddressAddr2S = row.AddressAddr2S; _invoice.AddressAddr3S = row.AddressAddr3S; _invoice.AddressAddr4S = row.AddressAddr4S; _invoice.AddressAddr5S = row.AddressAddr5S; _invoice.SkipTax = row.SkipTax; _invoice.SubTotal = row.SubTotal; _invoice.SaleTax = row.SaleTax; _invoice.Deposit = row.Deposit; _invoice.AmtPaid = row.AmtPaid; _invoice.Discount = row.Discount; _invoice.AmtCredit = row.AmtCredit; _invoice.Shipping = row.Shipping; _invoice.Balance = row.Balance; _invoice.Total = row.Total; _invoice.Voided = row.Voided; _invoice.Notes = row.Notes; _invoice.Memo = row.Memo; _invoice.RecordState = (int)Enum.RecordState.Unchange; _invoice.InvoiceStatus = row.InvoiceStatus; if(row.CustomerID!=null) { var customer = from c in db.Customers where c.StoreID == StoreID && c.LocalID == row.CustomerID select c; _invoice.CustomerID = customer.First().CustomerID; } db.Invoices.Add(_invoice); db.SaveChanges(); //Insert OrdItem OrdItem _OrdItem; foreach (NailSyn.DataAccess.SynOrdItemClient rowDetail in dataInvoice.ListOrdItem) { if (rowDetail.InvoiceID == row.InvoiceID) { if (rowDetail.RecordState != (int)Enum.RecordState.Delete) { _OrdItem = new OrdItem(); _OrdItem.InvoiceID = _invoice.InvoiceID; _OrdItem.ProductName = rowDetail.ProductName; _OrdItem.Description = rowDetail.Description; _OrdItem.ProdType = rowDetail.ProdType; _OrdItem.NoTax = rowDetail.NoTax; _OrdItem.Qty = rowDetail.Qty; _OrdItem.Price = rowDetail.Price; _OrdItem.Discount = rowDetail.Discount; _OrdItem.Total = rowDetail.Total; _OrdItem.RecordState = (int)Enum.RecordState.Unchange; var selectProduct = from c in db.Products where c.LocalID == rowDetail.ProductID && c.StoreID == StoreID select c; _OrdItem.ProductID = selectProduct.First().ProductID; db.OrdItems.Add(_OrdItem); } } } } } else { if (select.Count() == 1) { long InvoiceID = select.First().InvoiceID; var selectInvoice = from c in db.Invoices where c.InvoiceID == InvoiceID select c; if (row.RecordState == (int)Enum.RecordState.Modify) { if (row.CustomerID != null) { var customer = from c in db.Customers where c.StoreID == StoreID && c.LocalID == row.CustomerID select c; selectInvoice.First().CustomerID = customer.First().CustomerID; } selectInvoice.First().IsPaid = row.IsPaid; selectInvoice.First().IsPending = row.IsPending; selectInvoice.First().InvoiceDate = row.InvoiceDate; selectInvoice.First().InvoiceNo = row.InvoiceNo; selectInvoice.First().BusinessName = row.BusinessName; selectInvoice.First().Address = row.Address; selectInvoice.First().City = row.City; selectInvoice.First().State = row.City; selectInvoice.First().ZipCode = row.ZipCode; selectInvoice.First().AddressAddr1 = row.AddressAddr1; selectInvoice.First().AddressAddr2 = row.AddressAddr2; selectInvoice.First().AddressAddr3 = row.AddressAddr3; selectInvoice.First().AddressAddr4 = row.AddressAddr4; selectInvoice.First().AddressAddr5 = row.AddressAddr5; selectInvoice.First().AddressAddr1S = row.AddressAddr1S; selectInvoice.First().AddressAddr2S = row.AddressAddr2S; selectInvoice.First().AddressAddr3S = row.AddressAddr3S; selectInvoice.First().AddressAddr4S = row.AddressAddr4S; selectInvoice.First().AddressAddr5S = row.AddressAddr5S; selectInvoice.First().SkipTax = row.SkipTax; selectInvoice.First().SubTotal = row.SubTotal; selectInvoice.First().SaleTax = row.SaleTax; selectInvoice.First().Deposit = row.Deposit; selectInvoice.First().AmtPaid = row.AmtPaid; selectInvoice.First().Discount = row.Discount; selectInvoice.First().AmtCredit = row.AmtCredit; selectInvoice.First().Shipping = row.Shipping; selectInvoice.First().Balance = row.Balance; selectInvoice.First().Total = row.Total; selectInvoice.First().Voided = row.Voided; selectInvoice.First().Notes = row.Notes; selectInvoice.First().Memo = row.Memo; selectInvoice.First().RecordState = (int)Enum.RecordState.Unchange; selectInvoice.First().InvoiceStatus = row.InvoiceStatus; db.Entry(select.First()).State = System.Data.Entity.EntityState.Modified; //Clear Detail & insert var selectDetail = from c in db.OrdItems where c.InvoiceID == InvoiceID select c; db.OrdItems.RemoveRange(selectDetail.ToList()); db.SaveChanges(); //Insert OrdItem OrdItem _OrdItem; foreach (NailSyn.DataAccess.SynOrdItemClient rowDetail in dataInvoice.ListOrdItem) { if (rowDetail.InvoiceID == row.InvoiceID) { if (rowDetail.RecordState != (int)Enum.RecordState.Delete) { _OrdItem = new OrdItem(); _OrdItem.InvoiceID = InvoiceID; _OrdItem.ProductName = rowDetail.ProductName; _OrdItem.Description = rowDetail.Description; _OrdItem.ProdType = rowDetail.ProdType; _OrdItem.NoTax = rowDetail.NoTax; _OrdItem.Qty = rowDetail.Qty; _OrdItem.Price = rowDetail.Price; _OrdItem.Discount = rowDetail.Discount; _OrdItem.Total = rowDetail.Total; _OrdItem.RecordState = (int)Enum.RecordState.Unchange; var selectProduct = from c in db.Products where c.LocalID == rowDetail.ProductID && c.StoreID == StoreID select c; _OrdItem.ProductID = selectProduct.First().ProductID; db.OrdItems.Add(_OrdItem); } } } db.SaveChanges(); } else { //Delete Detail var selectDetail = from c in db.OrdItems where c.InvoiceID == InvoiceID select c; db.OrdItems.RemoveRange(selectDetail.ToList()); db.Entry(select.First()).State = System.Data.Entity.EntityState.Deleted; db.SaveChanges(); } } } } db.SaveChanges(); transcope.Complete(); return true; } catch { transcope.Dispose(); return false; } } } } catch { return false; } }