public Int32 insertSalesInvoice(Models.TrnSalesInvoice sales) { try { var userId = (from d in db.MstUsers where d.UserId == User.Identity.GetUserId() select d.Id).SingleOrDefault(); var lastSINumber = from d in db.TrnSalesInvoices.OrderByDescending(d => d.Id) where d.BranchId == currentBranchId() select d; var SINumberResult = "0000000001"; if (lastSINumber.Any()) { var SINumber = Convert.ToInt32(lastSINumber.FirstOrDefault().SINumber) + 0000000001; SINumberResult = zeroFill(SINumber, 10); } Data.TrnSalesInvoice newSalesInvoice = new Data.TrnSalesInvoice(); newSalesInvoice.BranchId = currentBranchId(); newSalesInvoice.SINumber = SINumberResult; newSalesInvoice.SIDate = DateTime.Today; newSalesInvoice.CustomerId = (from d in db.MstArticles where d.ArticleTypeId == 2 select d.Id).FirstOrDefault(); newSalesInvoice.TermId = (from d in db.MstTerms select d.Id).FirstOrDefault(); newSalesInvoice.DocumentReference = "NA"; newSalesInvoice.ManualSINumber = "NA"; newSalesInvoice.Remarks = "NA"; newSalesInvoice.Amount = 0; newSalesInvoice.PaidAmount = 0; newSalesInvoice.AdjustmentAmount = 0; newSalesInvoice.BalanceAmount = 0; newSalesInvoice.SoldById = userId; newSalesInvoice.PreparedById = userId; newSalesInvoice.CheckedById = userId; newSalesInvoice.ApprovedById = userId; newSalesInvoice.IsLocked = false; newSalesInvoice.CreatedById = userId; newSalesInvoice.CreatedDateTime = DateTime.Now; newSalesInvoice.UpdatedById = userId; newSalesInvoice.UpdatedDateTime = DateTime.Now; db.TrnSalesInvoices.InsertOnSubmit(newSalesInvoice); db.SubmitChanges(); return(newSalesInvoice.Id); } catch (Exception e) { Debug.WriteLine(e); return(0); } }
public HttpResponseMessage AddFolderMonitoringSalesInvoice(List <Entities.FolderMonitoringTrnSalesInvoice> folderMonitoringTrnSalesInvoiceObjects) { try { if (folderMonitoringTrnSalesInvoiceObjects.Any()) { foreach (var folderMonitoringTrnSalesInvoiceObject in folderMonitoringTrnSalesInvoiceObjects) { Boolean isBranchExist = false, isCustomerExist = false, isTermExist = false, isUserExist = false, isItemExist = false, isDiscountExist = false; var branch = from d in db.MstBranches where d.BranchCode.Equals(folderMonitoringTrnSalesInvoiceObject.BranchCode) select d; if (branch.Any()) { isBranchExist = true; } var customer = from d in db.MstArticles where d.ArticleTypeId == 2 && d.ManualArticleCode.Equals(folderMonitoringTrnSalesInvoiceObject.CustomerCode) && d.IsLocked == true select d; if (customer.Any()) { isCustomerExist = true; } var term = from d in db.MstTerms where d.Term.Equals(folderMonitoringTrnSalesInvoiceObject.Term) select d; if (term.Any()) { isTermExist = true; } var user = from d in db.MstUsers where d.UserName.Equals(folderMonitoringTrnSalesInvoiceObject.UserCode) select d; if (user.Any()) { isUserExist = true; } var item = from d in db.MstArticles where d.ArticleTypeId == 1 && d.ManualArticleCode.Equals(folderMonitoringTrnSalesInvoiceObject.ItemCode) && d.IsLocked == true select d; if (item.Any()) { isItemExist = true; } var discount = from d in db.MstDiscounts where d.Discount.Equals(folderMonitoringTrnSalesInvoiceObject.Discount) select d; if (discount.Any()) { isDiscountExist = true; } if (isBranchExist && isCustomerExist && isTermExist && isUserExist && isItemExist && isDiscountExist) { Int32 SIId = 0; var currentSalesInvoice = from d in db.TrnSalesInvoices where d.BranchId == branch.FirstOrDefault().Id&& d.ManualSINumber.Equals(folderMonitoringTrnSalesInvoiceObject.ManualSINumber) && d.IsLocked == true select d; if (currentSalesInvoice.Any()) { SIId = currentSalesInvoice.FirstOrDefault().Id; var unlockSalesInvoice = currentSalesInvoice.FirstOrDefault(); unlockSalesInvoice.IsLocked = false; unlockSalesInvoice.UpdatedById = user.FirstOrDefault().Id; unlockSalesInvoice.UpdatedDateTime = Convert.ToDateTime(folderMonitoringTrnSalesInvoiceObject.CreatedDateTime); db.SubmitChanges(); inventory.DeleteSalesInvoiceInventory(SIId); journal.DeleteSalesInvoiceJournal(SIId); } else { var defaultSINumber = "0000000001"; var lastSalesInvoice = from d in db.TrnSalesInvoices.OrderByDescending(d => d.Id) where d.BranchId == branch.FirstOrDefault().Id select d; if (lastSalesInvoice.Any()) { var SINumber = Convert.ToInt32(lastSalesInvoice.FirstOrDefault().SINumber) + 0000000001; defaultSINumber = FillLeadingZeroes(SINumber, 10); } Data.TrnSalesInvoice newSalesInvoice = new Data.TrnSalesInvoice { BranchId = branch.FirstOrDefault().Id, SINumber = defaultSINumber, SIDate = Convert.ToDateTime(folderMonitoringTrnSalesInvoiceObject.SIDate), DocumentReference = folderMonitoringTrnSalesInvoiceObject.DocumentReference, CustomerId = customer.FirstOrDefault().Id, TermId = term.FirstOrDefault().Id, Remarks = folderMonitoringTrnSalesInvoiceObject.Remarks, ManualSINumber = folderMonitoringTrnSalesInvoiceObject.ManualSINumber, Amount = 0, PaidAmount = 0, AdjustmentAmount = 0, BalanceAmount = 0, SoldById = user.FirstOrDefault().Id, PreparedById = user.FirstOrDefault().Id, CheckedById = user.FirstOrDefault().Id, ApprovedById = user.FirstOrDefault().Id, Status = null, IsCancelled = false, IsPrinted = false, IsLocked = false, CreatedById = user.FirstOrDefault().Id, CreatedDateTime = Convert.ToDateTime(folderMonitoringTrnSalesInvoiceObject.CreatedDateTime), UpdatedById = user.FirstOrDefault().Id, UpdatedDateTime = Convert.ToDateTime(folderMonitoringTrnSalesInvoiceObject.CreatedDateTime) }; db.TrnSalesInvoices.InsertOnSubmit(newSalesInvoice); db.SubmitChanges(); SIId = newSalesInvoice.Id; } var unitConversion = from d in item.FirstOrDefault().MstArticleUnits where d.MstUnit.Unit.Equals(folderMonitoringTrnSalesInvoiceObject.Unit) select d; if (unitConversion.Any()) { Decimal baseQuantity = folderMonitoringTrnSalesInvoiceObject.Quantity * 1; if (unitConversion.FirstOrDefault().Multiplier > 0) { baseQuantity = folderMonitoringTrnSalesInvoiceObject.Quantity * (1 / unitConversion.FirstOrDefault().Multiplier); } Decimal basePrice = folderMonitoringTrnSalesInvoiceObject.Amount; if (baseQuantity > 0) { basePrice = folderMonitoringTrnSalesInvoiceObject.Amount / baseQuantity; } Int32? itemInventoryId = null; Boolean isValid = false; if (item.FirstOrDefault().IsInventory) { var itemInventory = from d in db.MstArticleInventories where d.BranchId == branch.FirstOrDefault().Id&& d.ArticleId == item.FirstOrDefault().Id select d; if (itemInventory.Any()) { itemInventoryId = itemInventory.FirstOrDefault().Id; isValid = true; } } else { isValid = true; } if (isValid) { Data.TrnSalesInvoiceItem newSalesInvoiceItem = new Data.TrnSalesInvoiceItem { SIId = SIId, ItemId = item.FirstOrDefault().Id, ItemInventoryId = itemInventoryId, Particulars = folderMonitoringTrnSalesInvoiceObject.Particulars, UnitId = unitConversion.FirstOrDefault().UnitId, Quantity = folderMonitoringTrnSalesInvoiceObject.Quantity, Price = folderMonitoringTrnSalesInvoiceObject.Price, DiscountId = discount.FirstOrDefault().Id, DiscountRate = folderMonitoringTrnSalesInvoiceObject.DiscountRate, DiscountAmount = folderMonitoringTrnSalesInvoiceObject.DiscountAmount, NetPrice = folderMonitoringTrnSalesInvoiceObject.NetPrice, Amount = folderMonitoringTrnSalesInvoiceObject.Amount, VATId = item.FirstOrDefault().OutputTaxId, VATPercentage = item.FirstOrDefault().MstTaxType.TaxRate, VATAmount = ComputeVATAmount(item.FirstOrDefault().MstTaxType.IsInclusive, folderMonitoringTrnSalesInvoiceObject.Amount, item.FirstOrDefault().MstTaxType.TaxRate), BaseUnitId = item.FirstOrDefault().UnitId, BaseQuantity = baseQuantity, BasePrice = basePrice, SalesItemTimeStamp = DateTime.Now }; db.TrnSalesInvoiceItems.InsertOnSubmit(newSalesInvoiceItem); db.SubmitChanges(); var itemComponents = from d in item.FirstOrDefault().MstArticleComponents select d; if (itemComponents.Any()) { foreach (var itemComponent in itemComponents) { var itemComponentUnitConversion = from d in itemComponent.MstArticle1.MstArticleUnits where d.UnitId == itemComponent.MstArticle1.UnitId select d; if (itemComponentUnitConversion.Any()) { Decimal itemComponentDiscountAmount = 0 * (folderMonitoringTrnSalesInvoiceObject.DiscountRate / 100); Decimal itemComponentNetPrice = 0 - itemComponentDiscountAmount; if (discount.FirstOrDefault().IsInclusive) { Decimal price = 0 / (1 + (itemComponent.MstArticle1.MstTaxType.TaxRate / 100)); itemComponentDiscountAmount = price * (folderMonitoringTrnSalesInvoiceObject.DiscountRate / 100); itemComponentNetPrice = price - itemComponentDiscountAmount; } Decimal itemComponentQuantity = itemComponent.Quantity * folderMonitoringTrnSalesInvoiceObject.Quantity; Decimal itemComponentAmount = itemComponentNetPrice * itemComponentQuantity; Decimal componentItemBaseQuantity = itemComponentQuantity * 1; if (itemComponentUnitConversion.FirstOrDefault().Multiplier > 0) { componentItemBaseQuantity = itemComponentQuantity * (1 / itemComponentUnitConversion.FirstOrDefault().Multiplier); } Decimal componentItemBasePrice = itemComponentAmount; if (baseQuantity > 0) { componentItemBasePrice = itemComponentAmount / componentItemBaseQuantity; } Int32?itemComponentInventoryId = null; var itemComponentInventory = from d in itemComponent.MstArticle1.MstArticleInventories where d.BranchId == branch.FirstOrDefault().Id&& d.ArticleId == itemComponent.ArticleId select d; if (itemComponentInventory.Any()) { itemComponentInventoryId = itemComponentInventory.FirstOrDefault().Id; } Data.TrnSalesInvoiceItem newComponentSalesInvoiceItem = new Data.TrnSalesInvoiceItem { SIId = SIId, ItemId = itemComponent.ComponentArticleId, ItemInventoryId = itemComponentInventoryId, Particulars = itemComponent.Particulars, UnitId = itemComponentUnitConversion.FirstOrDefault().UnitId, Quantity = itemComponentQuantity, Price = 0, DiscountId = discount.FirstOrDefault().Id, DiscountRate = folderMonitoringTrnSalesInvoiceObject.DiscountRate, DiscountAmount = itemComponentDiscountAmount, NetPrice = itemComponentNetPrice, Amount = itemComponentAmount, VATId = itemComponent.MstArticle1.MstTaxType.Id, VATPercentage = itemComponent.MstArticle1.MstTaxType.TaxRate, VATAmount = ComputeVATAmount(itemComponent.MstArticle1.MstTaxType.IsInclusive, itemComponentAmount, itemComponent.MstArticle1.MstTaxType.TaxRate), BaseUnitId = itemComponent.MstArticle1.UnitId, BaseQuantity = componentItemBaseQuantity, BasePrice = componentItemBasePrice, SalesItemTimeStamp = DateTime.Now }; db.TrnSalesInvoiceItems.InsertOnSubmit(newComponentSalesInvoiceItem); db.SubmitChanges(); } } } } var salesInvoice = from d in db.TrnSalesInvoices where d.Id == SIId && d.IsLocked == false select d; if (salesInvoice.Any()) { Decimal amount = 0; var salesInvoiceItems = from d in db.TrnSalesInvoiceItems where d.SIId == SIId select d; if (salesInvoiceItems.Any()) { amount = salesInvoiceItems.Sum(d => d.Amount); } var lockSalesInvoice = salesInvoice.FirstOrDefault(); lockSalesInvoice.Amount = amount; lockSalesInvoice.IsLocked = true; lockSalesInvoice.UpdatedById = user.FirstOrDefault().Id; lockSalesInvoice.UpdatedDateTime = Convert.ToDateTime(folderMonitoringTrnSalesInvoiceObject.CreatedDateTime); db.SubmitChanges(); accountsReceivable.UpdateAccountsReceivable(SIId); inventory.InsertSalesInvoiceInventory(SIId); journal.InsertSalesInvoiceJournal(SIId); } } } } return(Request.CreateResponse(HttpStatusCode.OK)); } else { return(Request.CreateResponse(HttpStatusCode.NotFound, "No data found.")); } } catch (Exception ex) { Debug.WriteLine(ex); return(Request.CreateResponse(HttpStatusCode.InternalServerError, "Something's went wrong from the server.")); } }
public HttpResponseMessage AddFolderMonitoringSalesInvoice(List <Entities.FolderMonitoringTrnSalesInvoice> folderMonitoringTrnSalesInvoiceObjects) { try { if (folderMonitoringTrnSalesInvoiceObjects.Any()) { String returnMessage = ""; List <Entities.FolderMonitoringTrnSalesInvoiceHeader> newFolderMonitoringTrnSalesInvoiceHeaders = new List <Entities.FolderMonitoringTrnSalesInvoiceHeader>(); List <Entities.FolderMonitoringTrnSalesInvoiceItem> newFolderMonitoringTrnSalesInvoiceItems = new List <Entities.FolderMonitoringTrnSalesInvoiceItem>(); Boolean isDataValid = false; foreach (var folderMonitoringTrnSalesInvoiceObject in folderMonitoringTrnSalesInvoiceObjects) { Boolean isBranchExist = false, isCustomerExist = false, isSoldByUserExist = false, isUserExist = false, isItemExist = false, isUnitExist = false, isDiscountExist = false; var branch = from d in db.MstBranches where d.BranchCode.Equals(folderMonitoringTrnSalesInvoiceObject.BranchCode) select d; if (branch.Any()) { isBranchExist = true; } var customer = from d in db.MstArticles where d.ArticleTypeId == 2 && d.ManualArticleCode.Equals(folderMonitoringTrnSalesInvoiceObject.CustomerCode) && d.IsLocked == true select d; if (customer.Any()) { isCustomerExist = true; } var soldByUser = from d in db.MstUsers where d.FullName.Equals(branch.FirstOrDefault().Branch) select d; if (soldByUser.Any()) { isSoldByUserExist = true; } var user = from d in db.MstUsers where d.UserName.Equals(folderMonitoringTrnSalesInvoiceObject.UserCode) select d; if (user.Any()) { isUserExist = true; } var item = from d in db.MstArticles where d.ArticleTypeId == 1 && d.ManualArticleCode.Equals(folderMonitoringTrnSalesInvoiceObject.ItemCode) && d.IsLocked == true select d; if (item.Any()) { isItemExist = true; } var unit = from d in db.MstUnits where d.Unit.Equals(folderMonitoringTrnSalesInvoiceObject.Unit) select d; if (unit.Any()) { isUnitExist = true; } var discount = from d in db.MstDiscounts where d.Discount.Equals("Variable Discount") select d; if (discount.Any()) { isDiscountExist = true; } if (!isBranchExist) { returnMessage = "Invalid Branch Code: " + folderMonitoringTrnSalesInvoiceObject.BranchCode; isDataValid = false; break; } else if (!isCustomerExist) { returnMessage = "Invalid Customer Code: " + folderMonitoringTrnSalesInvoiceObject.CustomerCode; isDataValid = false; break; } else if (!isSoldByUserExist) { returnMessage = "Invalid Sold By User: "******"Invalid User Code: " + folderMonitoringTrnSalesInvoiceObject.UserCode; isDataValid = false; break; } else if (!isItemExist) { returnMessage = "Invalid Item Code: " + folderMonitoringTrnSalesInvoiceObject.ItemCode; isDataValid = false; break; } else if (!isUnitExist) { returnMessage = "Invalid Unit: " + folderMonitoringTrnSalesInvoiceObject.Unit; isDataValid = false; break; } else if (!isDiscountExist) { returnMessage = "Invalid Discount: Variable Discount"; isDataValid = false; break; } else { var salesInvoice = from d in db.TrnSalesInvoices where d.BranchId == branch.FirstOrDefault().Id && d.ManualSINumber.Equals(folderMonitoringTrnSalesInvoiceObject.ManualSINumber) && d.IsLocked == true select d; if (salesInvoice.Any()) { returnMessage = "This Manual SI No. " + folderMonitoringTrnSalesInvoiceObject.ManualSINumber + " is already exist!"; isDataValid = false; break; } else { var unitConversion = from d in item.FirstOrDefault().MstArticleUnits where d.UnitId == unit.FirstOrDefault().Id select d; if (unitConversion.Any()) { Decimal baseQuantity = folderMonitoringTrnSalesInvoiceObject.Quantity * 1; if (unitConversion.FirstOrDefault().Multiplier > 0) { baseQuantity = folderMonitoringTrnSalesInvoiceObject.Quantity * (1 / unitConversion.FirstOrDefault().Multiplier); } Decimal basePrice = folderMonitoringTrnSalesInvoiceObject.Amount; if (baseQuantity > 0) { basePrice = folderMonitoringTrnSalesInvoiceObject.Amount / baseQuantity; } Int32? itemInventoryId = null; Boolean isValidInventoryItem = false; if (item.FirstOrDefault().IsInventory) { var itemInventory = from d in db.MstArticleInventories where d.BranchId == branch.FirstOrDefault().Id && d.ArticleId == item.FirstOrDefault().Id select d; if (itemInventory.Any()) { itemInventoryId = itemInventory.FirstOrDefault().Id; isValidInventoryItem = true; } } else { isValidInventoryItem = true; } if (isValidInventoryItem) { var folderMonitoringTrnSalesInvoiceHeader = from d in newFolderMonitoringTrnSalesInvoiceHeaders where d.BranchId == branch.FirstOrDefault().Id && d.ManualSINumber.Equals(folderMonitoringTrnSalesInvoiceObject.ManualSINumber) select d; if (folderMonitoringTrnSalesInvoiceHeader.Any()) { var currentFolderMonitoringTrnSalesInvoiceHeader = folderMonitoringTrnSalesInvoiceHeader.FirstOrDefault(); currentFolderMonitoringTrnSalesInvoiceHeader.ListFolderMonitoringTrnSalesInvoiceItems.Add(new Entities.FolderMonitoringTrnSalesInvoiceItem() { ManualSINumber = folderMonitoringTrnSalesInvoiceObject.ManualSINumber, ItemId = item.FirstOrDefault().Id, ItemInventoryId = itemInventoryId, Particulars = folderMonitoringTrnSalesInvoiceObject.Particulars, UnitId = unitConversion.FirstOrDefault().UnitId, Quantity = folderMonitoringTrnSalesInvoiceObject.Quantity, Price = folderMonitoringTrnSalesInvoiceObject.Price, DiscountId = discount.FirstOrDefault().Id, DiscountRate = discount.FirstOrDefault().DiscountRate, DiscountAmount = folderMonitoringTrnSalesInvoiceObject.DiscountAmount, NetPrice = folderMonitoringTrnSalesInvoiceObject.NetPrice, Amount = folderMonitoringTrnSalesInvoiceObject.Amount, VATId = item.FirstOrDefault().OutputTaxId, VATPercentage = item.FirstOrDefault().MstTaxType.TaxRate, VATAmount = ComputeVATAmount(item.FirstOrDefault().MstTaxType.IsInclusive, folderMonitoringTrnSalesInvoiceObject.Amount, item.FirstOrDefault().MstTaxType.TaxRate), BaseUnitId = item.FirstOrDefault().UnitId, BaseQuantity = baseQuantity, BasePrice = basePrice, SalesItemTimeStamp = DateTime.Now }); } else { newFolderMonitoringTrnSalesInvoiceItems = new List <Entities.FolderMonitoringTrnSalesInvoiceItem> { new Entities.FolderMonitoringTrnSalesInvoiceItem() { ManualSINumber = folderMonitoringTrnSalesInvoiceObject.ManualSINumber, ItemId = item.FirstOrDefault().Id, ItemInventoryId = itemInventoryId, Particulars = folderMonitoringTrnSalesInvoiceObject.Particulars, UnitId = unitConversion.FirstOrDefault().UnitId, Quantity = folderMonitoringTrnSalesInvoiceObject.Quantity, Price = folderMonitoringTrnSalesInvoiceObject.Price, DiscountId = discount.FirstOrDefault().Id, DiscountRate = discount.FirstOrDefault().DiscountRate, DiscountAmount = folderMonitoringTrnSalesInvoiceObject.DiscountAmount, NetPrice = folderMonitoringTrnSalesInvoiceObject.NetPrice, Amount = folderMonitoringTrnSalesInvoiceObject.Amount, VATId = item.FirstOrDefault().OutputTaxId, VATPercentage = item.FirstOrDefault().MstTaxType.TaxRate, VATAmount = ComputeVATAmount(item.FirstOrDefault().MstTaxType.IsInclusive, folderMonitoringTrnSalesInvoiceObject.Amount, item.FirstOrDefault().MstTaxType.TaxRate), BaseUnitId = item.FirstOrDefault().UnitId, BaseQuantity = baseQuantity, BasePrice = basePrice, SalesItemTimeStamp = DateTime.Now } }; if (newFolderMonitoringTrnSalesInvoiceItems.Any()) { newFolderMonitoringTrnSalesInvoiceHeaders.Add(new Entities.FolderMonitoringTrnSalesInvoiceHeader() { BranchId = branch.FirstOrDefault().Id, SINumber = "00000000000", SIDate = Convert.ToDateTime(folderMonitoringTrnSalesInvoiceObject.SIDate), DocumentReference = folderMonitoringTrnSalesInvoiceObject.DocumentReference, CustomerId = customer.FirstOrDefault().Id, TermId = customer.FirstOrDefault().TermId, Remarks = folderMonitoringTrnSalesInvoiceObject.Remarks, ManualSINumber = folderMonitoringTrnSalesInvoiceObject.ManualSINumber, Amount = 0, PaidAmount = 0, AdjustmentAmount = 0, BalanceAmount = 0, SoldById = soldByUser.FirstOrDefault().Id, PreparedById = user.FirstOrDefault().Id, CheckedById = user.FirstOrDefault().Id, ApprovedById = user.FirstOrDefault().Id, Status = null, IsCancelled = false, IsPrinted = false, IsLocked = false, CreatedById = user.FirstOrDefault().Id, CreatedDateTime = Convert.ToDateTime(folderMonitoringTrnSalesInvoiceObject.CreatedDateTime), UpdatedById = user.FirstOrDefault().Id, UpdatedDateTime = Convert.ToDateTime(folderMonitoringTrnSalesInvoiceObject.CreatedDateTime), ListFolderMonitoringTrnSalesInvoiceItems = newFolderMonitoringTrnSalesInvoiceItems }); } } isDataValid = true; } else { returnMessage = "This item code: " + folderMonitoringTrnSalesInvoiceObject.ItemCode + " has no Inventory"; isDataValid = false; break; } } else { returnMessage = "This item code: " + folderMonitoringTrnSalesInvoiceObject.ItemCode + " has invalid unit conversion. Unit: " + folderMonitoringTrnSalesInvoiceObject.Unit; isDataValid = false; break; } } } } if (isDataValid) { if (newFolderMonitoringTrnSalesInvoiceHeaders.Any()) { foreach (var newFolderMonitoringTrnSalesInvoiceHeader in newFolderMonitoringTrnSalesInvoiceHeaders) { Int32 SIId = 0; var defaultSINumber = "0000000001"; var lastSalesInvoice = from d in db.TrnSalesInvoices.OrderByDescending(d => d.Id) where d.BranchId == newFolderMonitoringTrnSalesInvoiceHeader.BranchId select d; if (lastSalesInvoice.Any()) { var SINumber = Convert.ToInt32(lastSalesInvoice.FirstOrDefault().SINumber) + 0000000001; defaultSINumber = FillLeadingZeroes(SINumber, 10); } Data.TrnSalesInvoice newSalesInvoice = new Data.TrnSalesInvoice { BranchId = newFolderMonitoringTrnSalesInvoiceHeader.BranchId, SINumber = defaultSINumber, SIDate = newFolderMonitoringTrnSalesInvoiceHeader.SIDate, DocumentReference = newFolderMonitoringTrnSalesInvoiceHeader.DocumentReference, CustomerId = newFolderMonitoringTrnSalesInvoiceHeader.CustomerId, TermId = newFolderMonitoringTrnSalesInvoiceHeader.TermId, Remarks = newFolderMonitoringTrnSalesInvoiceHeader.Remarks, ManualSINumber = newFolderMonitoringTrnSalesInvoiceHeader.ManualSINumber, Amount = newFolderMonitoringTrnSalesInvoiceHeader.Amount, PaidAmount = newFolderMonitoringTrnSalesInvoiceHeader.PaidAmount, AdjustmentAmount = newFolderMonitoringTrnSalesInvoiceHeader.AdjustmentAmount, BalanceAmount = newFolderMonitoringTrnSalesInvoiceHeader.BalanceAmount, SoldById = newFolderMonitoringTrnSalesInvoiceHeader.SoldById, PreparedById = newFolderMonitoringTrnSalesInvoiceHeader.PreparedById, CheckedById = newFolderMonitoringTrnSalesInvoiceHeader.CheckedById, ApprovedById = newFolderMonitoringTrnSalesInvoiceHeader.ApprovedById, Status = newFolderMonitoringTrnSalesInvoiceHeader.Status, IsCancelled = newFolderMonitoringTrnSalesInvoiceHeader.IsCancelled, IsPrinted = newFolderMonitoringTrnSalesInvoiceHeader.IsPrinted, IsLocked = newFolderMonitoringTrnSalesInvoiceHeader.IsLocked, CreatedById = newFolderMonitoringTrnSalesInvoiceHeader.CreatedById, CreatedDateTime = newFolderMonitoringTrnSalesInvoiceHeader.CreatedDateTime, UpdatedById = newFolderMonitoringTrnSalesInvoiceHeader.UpdatedById, UpdatedDateTime = newFolderMonitoringTrnSalesInvoiceHeader.UpdatedDateTime }; db.TrnSalesInvoices.InsertOnSubmit(newSalesInvoice); db.SubmitChanges(); SIId = newSalesInvoice.Id; if (newFolderMonitoringTrnSalesInvoiceHeader.ListFolderMonitoringTrnSalesInvoiceItems.Any()) { foreach (var listFolderMonitoringTrnSalesInvoiceItem in newFolderMonitoringTrnSalesInvoiceHeader.ListFolderMonitoringTrnSalesInvoiceItems) { Data.TrnSalesInvoiceItem newSalesInvoiceItem = new Data.TrnSalesInvoiceItem { SIId = SIId, ItemId = listFolderMonitoringTrnSalesInvoiceItem.ItemId, ItemInventoryId = listFolderMonitoringTrnSalesInvoiceItem.ItemInventoryId, Particulars = listFolderMonitoringTrnSalesInvoiceItem.Particulars, UnitId = listFolderMonitoringTrnSalesInvoiceItem.UnitId, Quantity = listFolderMonitoringTrnSalesInvoiceItem.Quantity, Price = listFolderMonitoringTrnSalesInvoiceItem.Price, DiscountId = listFolderMonitoringTrnSalesInvoiceItem.DiscountId, DiscountRate = listFolderMonitoringTrnSalesInvoiceItem.DiscountRate, DiscountAmount = listFolderMonitoringTrnSalesInvoiceItem.DiscountAmount, NetPrice = listFolderMonitoringTrnSalesInvoiceItem.NetPrice, Amount = listFolderMonitoringTrnSalesInvoiceItem.Amount, VATId = listFolderMonitoringTrnSalesInvoiceItem.VATId, VATPercentage = listFolderMonitoringTrnSalesInvoiceItem.VATPercentage, VATAmount = listFolderMonitoringTrnSalesInvoiceItem.VATAmount, BaseUnitId = listFolderMonitoringTrnSalesInvoiceItem.BaseUnitId, BaseQuantity = listFolderMonitoringTrnSalesInvoiceItem.BaseQuantity, BasePrice = listFolderMonitoringTrnSalesInvoiceItem.BasePrice, SalesItemTimeStamp = listFolderMonitoringTrnSalesInvoiceItem.SalesItemTimeStamp }; db.TrnSalesInvoiceItems.InsertOnSubmit(newSalesInvoiceItem); } db.SubmitChanges(); } var salesInvoice = from d in db.TrnSalesInvoices where d.Id == SIId select d; if (salesInvoice.Any()) { Decimal amount = 0; var salesInvoiceItems = from d in db.TrnSalesInvoiceItems where d.SIId == SIId select d; if (salesInvoiceItems.Any()) { amount = salesInvoiceItems.Sum(d => d.Amount); } var lockSalesInvoice = salesInvoice.FirstOrDefault(); lockSalesInvoice.Amount = amount; lockSalesInvoice.IsLocked = true; db.SubmitChanges(); accountsReceivable.UpdateAccountsReceivable(SIId); inventory.InsertSalesInvoiceInventory(SIId); journal.InsertSalesInvoiceJournal(SIId); } } } } return(Request.CreateResponse(HttpStatusCode.OK, returnMessage)); } else { return(Request.CreateResponse(HttpStatusCode.NotFound, "Data Source is Invalid or Empty.")); } } catch (Exception ex) { Debug.WriteLine(ex); return(Request.CreateResponse(HttpStatusCode.InternalServerError, "Backend Error: " + ex.Message)); } }
public List <Entities.ReturnedDocument> QuintaIntegrationAddSalesInvoice(Entities.RootObject objRoot) { try { List <Entities.ReturnedDocument> listSINumber = new List <Entities.ReturnedDocument>(); var branch = from d in db.MstBranches select d; if (branch.Any()) { Int32 currentBranchId = branch.FirstOrDefault().Id; if (objRoot.TRN.Any()) { foreach (var objSales in objRoot.TRN) { if (objSales != null) { Boolean unitExist = false; var units = from d in db.MstUnits select d; if (units.Any()) { unitExist = true; } Boolean termExist = false; var terms = from d in db.MstTerms where d.Term.Equals(objRoot.DefaultTerm) select d; if (terms.Any()) { termExist = true; } Boolean userExist = false; var users = from d in db.MstUsers where d.UserName.Equals("admin") select d; if (users.Any()) { userExist = true; } Int32 customerId = 0; var customers = from d in db.MstArticles where d.ManualArticleCode.Equals(objSales.ACI) && d.ArticleTypeId == 2 select d; if (customers.Any()) { customerId = customers.FirstOrDefault().Id; } else { var defaultCustomerCode = "0000000001"; var lastCustomer = from d in db.MstArticles.OrderByDescending(d => d.Id) where d.ArticleTypeId == 2 select d; if (lastCustomer.Any()) { var customerCode = Convert.ToInt32(lastCustomer.FirstOrDefault().ArticleCode) + 0000000001; defaultCustomerCode = ZeroFill(customerCode, 10); } var articleGroups = from d in db.MstArticleGroups where d.ArticleTypeId == 2 select d; if (articleGroups.Any()) { Data.MstArticle newCustomer = new Data.MstArticle { ArticleCode = defaultCustomerCode, ManualArticleCode = objSales.ACI, Article = objSales.ACC, Category = "NA", ArticleTypeId = 2, ArticleGroupId = articleGroups.FirstOrDefault().Id, AccountId = articleGroups.FirstOrDefault().AccountId, SalesAccountId = articleGroups.FirstOrDefault().SalesAccountId, CostAccountId = articleGroups.FirstOrDefault().CostAccountId, AssetAccountId = articleGroups.FirstOrDefault().AssetAccountId, ExpenseAccountId = articleGroups.FirstOrDefault().ExpenseAccountId, UnitId = units.FirstOrDefault().Id, OutputTaxId = db.MstTaxTypes.FirstOrDefault().Id, InputTaxId = db.MstTaxTypes.FirstOrDefault().Id, WTaxTypeId = db.MstTaxTypes.FirstOrDefault().Id, Price = 0, Cost = 0, IsInventory = false, IsConsignment = false, ConsignmentCostPercentage = 0, ConsignmentCostValue = 0, Particulars = "NA", Address = "NA", TermId = terms.FirstOrDefault().Id, ContactNumber = "NA", ContactPerson = "NA", EmailAddress = "NA", TaxNumber = "NA", CreditLimit = 0, DateAcquired = DateTime.Now, UsefulLife = 0, SalvageValue = 0, ManualArticleOldCode = "NA", Kitting = 0, DefaultSupplierId = null, StockLevelQuantity = 0, ReorderQuantity = 0, IsLocked = true, CreatedById = users.FirstOrDefault().Id, CreatedDateTime = DateTime.Now, UpdatedById = users.FirstOrDefault().Id, UpdatedDateTime = DateTime.Now }; db.MstArticles.InsertOnSubmit(newCustomer); db.SubmitChanges(); customerId = newCustomer.Id; } } Boolean taxTypeExist = false; var taxTypes = from d in db.MstTaxTypes select d; if (taxTypes.Any()) { taxTypeExist = true; } Boolean discountExist = false; var discounts = from d in db.MstDiscounts where d.Discount.Equals(objRoot.DefaultDiscount) select d; if (discounts.Any()) { discountExist = true; } if (userExist) { if (termExist) { if (customerId != 0) { Int32 salesInvoiceId = 0; var SINumberResult = "0000000001"; var lastSalesInvoice = from d in db.TrnSalesInvoices.OrderByDescending(d => d.Id) where d.BranchId == currentBranchId select d; if (lastSalesInvoice.Any()) { var SINumber = Convert.ToInt32(lastSalesInvoice.FirstOrDefault().SINumber) + 0000000001; SINumberResult = ZeroFill(SINumber, 10); } Data.TrnSalesInvoice addSalesInvoice = new Data.TrnSalesInvoice { BranchId = currentBranchId, SINumber = SINumberResult, SIDate = Convert.ToDateTime(objSales.TDT), CustomerId = customerId, TermId = terms.FirstOrDefault().Id, DocumentReference = objSales.FTN, ManualSINumber = objSales.FTN, Remarks = "NA", Amount = objSales.NAM, PaidAmount = 0, AdjustmentAmount = 0, BalanceAmount = objSales.NAM, SoldById = users.FirstOrDefault().Id, PreparedById = users.FirstOrDefault().Id, CheckedById = users.FirstOrDefault().Id, ApprovedById = users.FirstOrDefault().Id, IsLocked = true, CreatedById = users.FirstOrDefault().Id, CreatedDateTime = DateTime.Now, UpdatedById = users.FirstOrDefault().Id, UpdatedDateTime = DateTime.Now }; db.TrnSalesInvoices.InsertOnSubmit(addSalesInvoice); db.SubmitChanges(); salesInvoiceId = addSalesInvoice.Id; listSINumber.Add(new Entities.ReturnedDocument() { SINumber = addSalesInvoice.SINumber, ManualSINumber = addSalesInvoice.ManualSINumber }); if (salesInvoiceId != 0) { Int32 itemId = 0; var items = from d in db.MstArticles where d.ManualArticleCode.Equals(objSales.SAI) && d.ArticleTypeId == 1 select d; if (items.Any()) { itemId = items.FirstOrDefault().Id; } else { var defaultItemCode = "0000000001"; var lastItem = from d in db.MstArticles.OrderByDescending(d => d.Id) where d.ArticleTypeId == 1 select d; if (lastItem.Any()) { var itemCode = Convert.ToInt32(lastItem.FirstOrDefault().ArticleCode) + 0000000001; defaultItemCode = ZeroFill(itemCode, 10); } var articleGroups = from d in db.MstArticleGroups where d.ArticleTypeId == 1 select d; if (articleGroups.Any()) { Data.MstArticle newItem = new Data.MstArticle { ArticleCode = defaultItemCode, ManualArticleCode = objSales.SAI, Article = objSales.SAM, Category = "NA", ArticleTypeId = 1, ArticleGroupId = articleGroups.FirstOrDefault().Id, AccountId = articleGroups.FirstOrDefault().AccountId, SalesAccountId = articleGroups.FirstOrDefault().SalesAccountId, CostAccountId = articleGroups.FirstOrDefault().CostAccountId, AssetAccountId = articleGroups.FirstOrDefault().AssetAccountId, ExpenseAccountId = articleGroups.FirstOrDefault().ExpenseAccountId, UnitId = units.FirstOrDefault().Id, OutputTaxId = taxTypes.Where(d => d.TaxType.Equals(objRoot.DefaultVatOutput)).FirstOrDefault().Id, InputTaxId = taxTypes.Where(d => d.TaxType.Equals(objRoot.DefaultVatInput)).FirstOrDefault().Id, WTaxTypeId = taxTypes.Where(d => d.TaxType.Equals(objRoot.DefaultWTax)).FirstOrDefault().Id, Price = objSales.NAM, Cost = 0, IsInventory = false, IsConsignment = false, ConsignmentCostPercentage = 0, ConsignmentCostValue = 0, Particulars = "NA", Address = "NA", TermId = terms.FirstOrDefault().Id, ContactNumber = "NA", ContactPerson = "NA", EmailAddress = "NA", TaxNumber = "NA", CreditLimit = 0, DateAcquired = DateTime.Now, UsefulLife = 0, SalvageValue = 0, ManualArticleOldCode = "NA", Kitting = 0, DefaultSupplierId = null, StockLevelQuantity = 0, ReorderQuantity = 0, IsLocked = true, CreatedById = users.FirstOrDefault().Id, CreatedDateTime = DateTime.Now, UpdatedById = users.FirstOrDefault().Id, UpdatedDateTime = DateTime.Now }; db.MstArticles.InsertOnSubmit(newItem); db.SubmitChanges(); itemId = newItem.Id; Data.MstArticleUnit newItemUnitConversion = new Data.MstArticleUnit { ArticleId = Convert.ToInt32(itemId), UnitId = units.FirstOrDefault().Id, Multiplier = 1, IsCountUnit = false }; db.MstArticleUnits.InsertOnSubmit(newItemUnitConversion); db.SubmitChanges(); Data.MstArticlePrice newItemPrice = new Data.MstArticlePrice { ArticleId = Convert.ToInt32(itemId), PriceDescription = "SRP", Price = objSales.NAM, Remarks = "NA" }; db.MstArticlePrices.InsertOnSubmit(newItemPrice); db.SubmitChanges(); } } if (itemId != 0) { if (unitExist) { if (taxTypeExist) { if (discountExist) { Int32?itemInventoryId = null; var articleInventory = from d in db.MstArticleInventories where d.BranchId == currentBranchId && d.ArticleId == itemId select d; if (articleInventory.Any()) { itemInventoryId = articleInventory.FirstOrDefault().Id; } var conversionUnit = from d in db.MstArticleUnits where d.ArticleId == itemId && d.UnitId == items.FirstOrDefault().UnitId select d; if (conversionUnit.Any()) { Decimal baseQuantity = 1; Decimal basePrice = objSales.NAM; if (conversionUnit.FirstOrDefault().Multiplier > 0) { baseQuantity = 1 * (1 / conversionUnit.FirstOrDefault().Multiplier); } if (baseQuantity > 0) { basePrice = objSales.NAM / baseQuantity; } Data.TrnSalesInvoiceItem newSalesInvoiceItem = new Data.TrnSalesInvoiceItem { SIId = salesInvoiceId, ItemId = itemId, ItemInventoryId = itemInventoryId, Particulars = "NA", UnitId = units.FirstOrDefault().Id, Quantity = 1, Price = objSales.NAM, DiscountId = discounts.FirstOrDefault().Id, DiscountRate = discounts.FirstOrDefault().DiscountRate, DiscountAmount = 0, NetPrice = objSales.NAM, Amount = objSales.NAM, VATId = items.FirstOrDefault().OutputTaxId, VATPercentage = items.FirstOrDefault().MstTaxType.TaxRate, VATAmount = (objSales.NAM / (1 + (items.FirstOrDefault().MstTaxType.TaxRate / 100))) * (items.FirstOrDefault().MstTaxType.TaxRate / 100), BaseUnitId = items.FirstOrDefault().UnitId, BaseQuantity = baseQuantity, BasePrice = basePrice, SalesItemTimeStamp = DateTime.Now }; db.TrnSalesInvoiceItems.InsertOnSubmit(newSalesInvoiceItem); db.SubmitChanges(); } } } } } var currentSalesInvoice = from d in db.TrnSalesInvoices where d.Id == salesInvoiceId select d; if (currentSalesInvoice.Any()) { Decimal salesAmount = 0; Decimal paidAmount = currentSalesInvoice.FirstOrDefault().PaidAmount; Decimal adjustmentAmount = currentSalesInvoice.FirstOrDefault().AdjustmentAmount; var salesInvoiceItems = from d in db.TrnSalesInvoiceItems where d.SIId == salesInvoiceId select d; if (salesInvoiceItems.Any()) { salesAmount = salesInvoiceItems.Sum(d => d.Amount); } var updateSalesInvoiceAmount = currentSalesInvoice.FirstOrDefault(); updateSalesInvoiceAmount.Amount = salesAmount; updateSalesInvoiceAmount.BalanceAmount = (salesAmount - paidAmount) + adjustmentAmount; db.SubmitChanges(); } inventory.InsertSalesInvoiceInventory(Convert.ToInt32(salesInvoiceId)); journal.InsertSalesInvoiceJournal(Convert.ToInt32(salesInvoiceId)); if (currentSalesInvoice.Any()) { var defaultORNumber = "0000000001"; var lastCollection = from d in db.TrnCollections.OrderByDescending(d => d.Id) where d.BranchId == currentBranchId select d; if (lastCollection.Any()) { var ORNumber = Convert.ToInt32(lastCollection.FirstOrDefault().ORNumber) + 0000000001; defaultORNumber = ZeroFill(ORNumber, 10); } Data.TrnCollection newCollection = new Data.TrnCollection { BranchId = currentBranchId, ORNumber = defaultORNumber, ORDate = Convert.ToDateTime(objSales.ADT), ManualORNumber = "NA", CustomerId = customers.FirstOrDefault().Id, Particulars = "NA", PreparedById = users.FirstOrDefault().Id, CheckedById = users.FirstOrDefault().Id, ApprovedById = users.FirstOrDefault().Id, IsLocked = true, CreatedById = users.FirstOrDefault().Id, CreatedDateTime = DateTime.Now, UpdatedById = users.FirstOrDefault().Id, UpdatedDateTime = DateTime.Now }; db.TrnCollections.InsertOnSubmit(newCollection); db.SubmitChanges(); Boolean payTypeExist = false; var payTypes = from d in db.MstPayTypes select d; if (payTypes.Any()) { payTypeExist = true; } Boolean bankExist = false; var banks = from d in db.MstArticles where d.ArticleTypeId == 5 select d; if (banks.Any()) { bankExist = true; } if (payTypeExist) { if (bankExist) { Data.TrnCollectionLine newCollectionLine = new Data.TrnCollectionLine { ORId = newCollection.Id, BranchId = currentBranchId, AccountId = currentSalesInvoice.FirstOrDefault().MstArticle.AccountId, ArticleId = currentSalesInvoice.FirstOrDefault().CustomerId, SIId = currentSalesInvoice.FirstOrDefault().Id, Particulars = currentSalesInvoice.FirstOrDefault().Remarks, Amount = objSales.NAM, PayTypeId = payTypes.FirstOrDefault().Id, CheckNumber = "NA", CheckDate = DateTime.Today, CheckBank = "NA", DepositoryBankId = banks.FirstOrDefault().Id, IsClear = true }; db.TrnCollectionLines.InsertOnSubmit(newCollectionLine); db.SubmitChanges(); journal.InsertOfficialReceiptJournal(Convert.ToInt32(newCollection.Id)); accountsReceivable.UpdateAccountsReceivable(currentSalesInvoice.FirstOrDefault().Id); } } } } } } } } } } return(listSINumber.ToList()); } else { return(new List <Entities.ReturnedDocument>()); } } catch (Exception e) { Debug.WriteLine(e); return(new List <Entities.ReturnedDocument>()); } }
public HttpResponseMessage AddSalesInvoice() { try { var currentUser = from d in db.MstUsers where d.UserId == User.Identity.GetUserId() select d; if (currentUser.Any()) { var currentUserId = currentUser.FirstOrDefault().Id; var currentBranchId = currentUser.FirstOrDefault().BranchId; var currentSalesInvoiceCheckedById = currentUserId; if (currentUser.FirstOrDefault().SalesInvoiceCheckedById != null) { currentSalesInvoiceCheckedById = Convert.ToInt32(currentUser.FirstOrDefault().SalesInvoiceCheckedById); } var currentSalesInvoiceApprovedById = currentUserId; if (currentUser.FirstOrDefault().SalesInvoiceApprovedById != null) { currentSalesInvoiceApprovedById = Convert.ToInt32(currentUser.FirstOrDefault().SalesInvoiceApprovedById); } var userForms = from d in db.MstUserForms where d.UserId == currentUserId && d.SysForm.FormName.Equals("SalesInvoiceList") select d; if (userForms.Any()) { if (userForms.FirstOrDefault().CanAdd) { var defaultSINumber = "0000000001"; var lastSalesInvoice = from d in db.TrnSalesInvoices.OrderByDescending(d => d.Id) where d.BranchId == currentBranchId select d; if (lastSalesInvoice.Any()) { var SINumber = Convert.ToInt32(lastSalesInvoice.FirstOrDefault().SINumber) + 0000000001; defaultSINumber = FillLeadingZeroes(SINumber, 10); } var customers = from d in db.MstArticles.OrderBy(d => d.Article) where d.ArticleTypeId == 2 && d.IsLocked == true select d; if (customers.Any()) { var terms = from d in db.MstTerms.OrderBy(d => d.Term) where d.IsLocked == true select d; if (terms.Any()) { var users = from d in db.MstUsers.OrderBy(d => d.FullName) where d.IsLocked == true select d; if (users.Any()) { Data.TrnSalesInvoice newSalesInvoice = new Data.TrnSalesInvoice { BranchId = currentBranchId, SINumber = defaultSINumber, SIDate = DateTime.Today, DocumentReference = "NA", CustomerId = customers.FirstOrDefault().Id, TermId = terms.FirstOrDefault().Id, Remarks = "NA", ManualSINumber = "NA", Amount = 0, PaidAmount = 0, AdjustmentAmount = 0, BalanceAmount = 0, SoldById = currentUserId, PreparedById = currentUserId, CheckedById = currentSalesInvoiceCheckedById, ApprovedById = currentSalesInvoiceApprovedById, Status = null, IsCancelled = false, IsPrinted = false, IsLocked = false, CreatedById = currentUserId, CreatedDateTime = DateTime.Now, UpdatedById = currentUserId, UpdatedDateTime = DateTime.Now }; db.TrnSalesInvoices.InsertOnSubmit(newSalesInvoice); db.SubmitChanges(); String newObject = auditTrail.GetObjectString(newSalesInvoice); auditTrail.InsertAuditTrail(currentUser.FirstOrDefault().Id, GetType().Name, MethodBase.GetCurrentMethod().Name, "NA", newObject); return(Request.CreateResponse(HttpStatusCode.OK, newSalesInvoice.Id)); } else { return(Request.CreateResponse(HttpStatusCode.NotFound, "No user found. Please setup more users for all transactions.")); } } else { return(Request.CreateResponse(HttpStatusCode.NotFound, "No term found. Please setup more terms for all transactions.")); } } else { return(Request.CreateResponse(HttpStatusCode.NotFound, "No supplier found. Please setup more suppliers for all transactions.")); } } else { return(Request.CreateResponse(HttpStatusCode.BadRequest, "Sorry. You have no rights to add sales invoice.")); } } else { return(Request.CreateResponse(HttpStatusCode.BadRequest, "Sorry. You have no access for this sales invoice page.")); } } else { return(Request.CreateResponse(HttpStatusCode.BadRequest, "Theres no current user logged in.")); } } catch (Exception e) { Debug.WriteLine(e); return(Request.CreateResponse(HttpStatusCode.InternalServerError, "Something's went wrong from the server.")); } }
public HttpResponseMessage AddSalesInvoicePOSIntegration(POSIntegrationEntities.POSIntegrationTrnSalesInvoice POSIntegrationTrnSalesInvoiceObject) { try { var lastSINumber = from d in db.TrnSalesInvoices.OrderByDescending(d => d.Id) select d; var SINumberResult = "0000000001"; if (lastSINumber.Any()) { var SINumber = Convert.ToInt32(lastSINumber.FirstOrDefault().SINumber) + 0000000001; SINumberResult = ZeroFill(SINumber, 10); } Boolean customerExist = false; var customers = from d in db.MstArticles where d.ManualArticleCode == POSIntegrationTrnSalesInvoiceObject.CustomerManualArticleCode select d; if (customers.Any()) { if (customers.Count() == 1) { customerExist = true; } } Boolean userExist = false; var users = from d in db.MstUsers where d.UserName == POSIntegrationTrnSalesInvoiceObject.CreatedBy select d; if (users.Any()) { if (users.Count() == 1) { userExist = true; } } Boolean termExist = false; var terms = from d in db.MstTerms where d.Term == POSIntegrationTrnSalesInvoiceObject.Term select d; if (terms.Any()) { if (terms.Count() == 1) { termExist = true; } } Boolean branchExist = false; var branches = from d in db.MstBranches where d.BranchCode == POSIntegrationTrnSalesInvoiceObject.BranchCode select d; if (branches.Any()) { if (branches.Count() == 1) { branchExist = true; } } if (customerExist) { if (userExist) { if (termExist) { if (branchExist) { // ==================== // Insert Sales Invoice // ==================== Data.TrnSalesInvoice addSalesInvoice = new Data.TrnSalesInvoice { BranchId = branches.FirstOrDefault().Id, SINumber = SINumberResult, SIDate = Convert.ToDateTime(POSIntegrationTrnSalesInvoiceObject.SIDate), CustomerId = customers.FirstOrDefault().Id, TermId = terms.FirstOrDefault().Id, DocumentReference = POSIntegrationTrnSalesInvoiceObject.DocumentReference, ManualSINumber = POSIntegrationTrnSalesInvoiceObject.ManualSINumber, Remarks = POSIntegrationTrnSalesInvoiceObject.Remarks, Amount = POSIntegrationTrnSalesInvoiceObject.Amount, PaidAmount = POSIntegrationTrnSalesInvoiceObject.PaidAmount, AdjustmentAmount = POSIntegrationTrnSalesInvoiceObject.AdjustmentAmount, BalanceAmount = (POSIntegrationTrnSalesInvoiceObject.Amount - POSIntegrationTrnSalesInvoiceObject.PaidAmount) + POSIntegrationTrnSalesInvoiceObject.AdjustmentAmount, SoldById = users.FirstOrDefault().Id, PreparedById = users.FirstOrDefault().Id, CheckedById = users.FirstOrDefault().Id, ApprovedById = users.FirstOrDefault().Id, IsLocked = true, CreatedById = users.FirstOrDefault().Id, CreatedDateTime = DateTime.Now, UpdatedById = users.FirstOrDefault().Id, UpdatedDateTime = DateTime.Now }; db.TrnSalesInvoices.InsertOnSubmit(addSalesInvoice); db.SubmitChanges(); // ========================= // Insert Sales Invoice Item // ========================= foreach (var salesInvoiceItem in POSIntegrationTrnSalesInvoiceObject.ListPOSIntegrationTrnSalesInvoiceItem.ToList()) { var articleComponents = from d in db.MstArticleComponents where d.MstArticle.ManualArticleCode == salesInvoiceItem.ItemManualArticleCode select d; if (articleComponents.Any()) { if (articleComponents.FirstOrDefault().MstArticle.Kitting == 2) { Boolean itemExist = false; var items = from d in db.MstArticles where d.Id == articleComponents.FirstOrDefault().ArticleId select d; if (items.Any()) { if (items.Count() == 1) { itemExist = true; } } if (itemExist) { var articleInventory = from d in db.MstArticleInventories where d.BranchId == branches.FirstOrDefault().Id && d.ArticleId == items.FirstOrDefault().Id select d; if (articleInventory.Any()) { Boolean unitExist = false; var units = from d in db.MstUnits where d.Unit == salesInvoiceItem.Unit select d; if (units.Any()) { if (units.Count() == 1) { unitExist = true; } } Boolean discountExist = false; var discounts = from d in db.MstDiscounts where d.Discount == salesInvoiceItem.Discount select d; if (discounts.Any()) { if (discounts.Count() == 1) { discountExist = true; } } Boolean taxExist = false; var taxes = from d in db.MstTaxTypes where d.TaxType == salesInvoiceItem.VAT select d; if (taxes.Any()) { if (taxes.Count() == 1) { taxExist = true; } } if (unitExist) { if (discountExist) { if (taxExist) { var packageConversionUnit = from d in db.MstArticleUnits where d.ArticleId == items.FirstOrDefault().Id && d.UnitId == items.FirstOrDefault().UnitId select d; if (packageConversionUnit.Any()) { Decimal baseQuantity = salesInvoiceItem.Quantity * 1; Decimal basePrice = salesInvoiceItem.Amount; if (packageConversionUnit.FirstOrDefault().Multiplier > 0) { baseQuantity = salesInvoiceItem.Quantity * (1 / packageConversionUnit.FirstOrDefault().Multiplier); } if (baseQuantity > 0) { basePrice = salesInvoiceItem.Amount / baseQuantity; } // ============================ // Sales Invoice Item - Package // ============================ Data.TrnSalesInvoiceItem addSaleInvoiceItemPackage = new Data.TrnSalesInvoiceItem { SIId = addSalesInvoice.Id, ItemId = items.FirstOrDefault().Id, ItemInventoryId = articleInventory.FirstOrDefault().Id, Particulars = salesInvoiceItem.Particulars, UnitId = units.FirstOrDefault().Id, Quantity = salesInvoiceItem.Quantity, Price = salesInvoiceItem.Price, DiscountId = discounts.FirstOrDefault().Id, DiscountRate = discounts.FirstOrDefault().DiscountRate, DiscountAmount = salesInvoiceItem.DiscountAmount, NetPrice = salesInvoiceItem.NetPrice, Amount = salesInvoiceItem.Amount, VATId = taxes.FirstOrDefault().Id, VATPercentage = taxes.FirstOrDefault().TaxRate, VATAmount = (salesInvoiceItem.Amount / (1 + (taxes.FirstOrDefault().TaxRate / 100))) * (taxes.FirstOrDefault().TaxRate / 100), BaseUnitId = articleComponents.FirstOrDefault().MstArticle.UnitId, BaseQuantity = baseQuantity, BasePrice = basePrice, SalesItemTimeStamp = Convert.ToDateTime(salesInvoiceItem.SalesItemTimeStamp) }; db.TrnSalesInvoiceItems.InsertOnSubmit(addSaleInvoiceItemPackage); db.SubmitChanges(); // =========================== // Update Sales Invoice Amount // =========================== var salesInvoice = from d in db.TrnSalesInvoices where d.Id == addSalesInvoice.Id select d; if (salesInvoice.Any()) { var salesInvoiceItems = from d in db.TrnSalesInvoiceItems where d.SIId == addSalesInvoice.Id select d; foreach (var articleComponent in articleComponents) { Decimal salesInvoiceItemDiscountAmount = 0 * (discounts.FirstOrDefault().DiscountRate / 100); Decimal salesInvoiceItemNetPrice = 0 - (0 * (discounts.FirstOrDefault().DiscountRate / 100)); var discount = from d in db.MstDiscounts where d.Id == discounts.FirstOrDefault().Id select d; if (discount.Any()) { if (!discount.FirstOrDefault().IsInclusive) { var price = 0 / (1 + (taxes.FirstOrDefault().TaxRate / 100)); salesInvoiceItemDiscountAmount = price * (discounts.FirstOrDefault().DiscountRate / 100); salesInvoiceItemNetPrice = price - (price * (discounts.FirstOrDefault().DiscountRate / 100)); } } Decimal quantity = articleComponent.Quantity * salesInvoiceItem.Quantity; Decimal amount = quantity * salesInvoiceItemNetPrice; Decimal VATAmount = amount * (taxes.FirstOrDefault().TaxRate / 100); var taxTypeTAXIsInclusive = from d in db.MstTaxTypes where d.Id == taxes.FirstOrDefault().Id select d; if (taxTypeTAXIsInclusive.Any()) { if (taxTypeTAXIsInclusive.FirstOrDefault().IsInclusive) { VATAmount = amount / (1 + (taxes.FirstOrDefault().TaxRate / 100)) * (taxes.FirstOrDefault().TaxRate / 100); } } Int32 componentItemInventoryId = 0; var componentArticleInventory = from d in db.MstArticleInventories where d.BranchId == branches.FirstOrDefault().Id && d.ArticleId == articleComponent.ComponentArticleId select d; if (componentArticleInventory.Any()) { componentItemInventoryId = componentArticleInventory.FirstOrDefault().Id; } if (componentItemInventoryId > 0) { var componentItem = from d in db.MstArticles where d.Id == articleComponent.ComponentArticleId select d; if (componentItem.Any()) { var componentItemConversionUnit = from d in db.MstArticleUnits where d.ArticleId == articleComponent.ComponentArticleId && d.UnitId == articleComponent.MstArticle1.UnitId select d; if (componentItemConversionUnit.Any()) { Decimal componentBaseQuantity = (articleComponent.Quantity * salesInvoiceItem.Quantity) * 1; if (componentItemConversionUnit.FirstOrDefault().Multiplier > 0) { componentBaseQuantity = (articleComponent.Quantity * salesInvoiceItem.Quantity) * (1 / componentItemConversionUnit.FirstOrDefault().Multiplier); } Decimal componentBasePrice = amount; if (baseQuantity > 0) { componentBasePrice = amount / baseQuantity; } Data.TrnSalesInvoiceItem addSaleInvoiceItem = new Data.TrnSalesInvoiceItem { SIId = addSalesInvoice.Id, ItemId = articleComponent.ComponentArticleId, ItemInventoryId = componentItemInventoryId, Particulars = articleComponent.Particulars, UnitId = articleComponent.MstArticle1.UnitId, Quantity = articleComponent.Quantity * salesInvoiceItem.Quantity, Price = 0, DiscountId = discounts.FirstOrDefault().Id, DiscountRate = discounts.FirstOrDefault().DiscountRate, DiscountAmount = salesInvoiceItemDiscountAmount, NetPrice = salesInvoiceItemNetPrice, Amount = amount, VATId = taxes.FirstOrDefault().Id, VATPercentage = taxes.FirstOrDefault().TaxRate, VATAmount = VATAmount, BaseUnitId = componentItem.FirstOrDefault().UnitId, BaseQuantity = componentBaseQuantity, BasePrice = componentBasePrice, SalesItemTimeStamp = Convert.ToDateTime(salesInvoiceItem.SalesItemTimeStamp) }; db.TrnSalesInvoiceItems.InsertOnSubmit(addSaleInvoiceItem); db.SubmitChanges(); } } } } Decimal totalSalesInvoiceItemAmount = 0; if (salesInvoiceItems.Any()) { totalSalesInvoiceItemAmount = salesInvoiceItems.Sum(d => d.Amount); } var updateSalesInvoiceAmount = salesInvoice.FirstOrDefault(); updateSalesInvoiceAmount.Amount = totalSalesInvoiceItemAmount; updateSalesInvoiceAmount.BalanceAmount = totalSalesInvoiceItemAmount; db.SubmitChanges(); } } } } } } } } } else { Boolean itemExist = false; var items = from d in db.MstArticles where d.ManualArticleCode == salesInvoiceItem.ItemManualArticleCode select d; if (items.Any()) { if (items.Count() == 1) { itemExist = true; } } if (itemExist) { var articleInventory = from d in db.MstArticleInventories where d.BranchId == branches.FirstOrDefault().Id && d.ArticleId == items.FirstOrDefault().Id select d; if (articleInventory.Any()) { Boolean unitExist = false; var units = from d in db.MstUnits where d.Unit == salesInvoiceItem.Unit select d; if (units.Any()) { if (units.Count() == 1) { unitExist = true; } } Boolean discountExist = false; var discounts = from d in db.MstDiscounts where d.Discount == salesInvoiceItem.Discount select d; if (discounts.Any()) { if (discounts.Count() == 1) { discountExist = true; } } Boolean taxExist = false; var taxes = from d in db.MstTaxTypes where d.TaxType == salesInvoiceItem.VAT select d; if (taxes.Any()) { if (taxes.Count() == 1) { taxExist = true; } } if (unitExist) { if (discountExist) { if (taxExist) { var conversionUnit = from d in db.MstArticleUnits where d.ArticleId == items.FirstOrDefault().Id && d.UnitId == items.FirstOrDefault().UnitId select d; if (conversionUnit.Any()) { Decimal baseQuantity = salesInvoiceItem.Quantity * 1; if (conversionUnit.FirstOrDefault().Multiplier > 0) { baseQuantity = salesInvoiceItem.Quantity * (1 / conversionUnit.FirstOrDefault().Multiplier); } Decimal basePrice = salesInvoiceItem.Amount; if (baseQuantity > 0) { basePrice = salesInvoiceItem.Amount / baseQuantity; } // ================== // Sales Invoice Item // ================== Data.TrnSalesInvoiceItem addSaleInvoiceItem = new Data.TrnSalesInvoiceItem { SIId = addSalesInvoice.Id, ItemId = items.FirstOrDefault().Id, ItemInventoryId = articleInventory.FirstOrDefault().Id, Particulars = salesInvoiceItem.Particulars, UnitId = units.FirstOrDefault().Id, Quantity = salesInvoiceItem.Quantity, Price = salesInvoiceItem.Price, DiscountId = discounts.FirstOrDefault().Id, DiscountRate = discounts.FirstOrDefault().DiscountRate, DiscountAmount = salesInvoiceItem.DiscountAmount, NetPrice = salesInvoiceItem.NetPrice, Amount = salesInvoiceItem.Amount, VATId = taxes.FirstOrDefault().Id, VATPercentage = taxes.FirstOrDefault().TaxRate, VATAmount = (salesInvoiceItem.Amount / (1 + (taxes.FirstOrDefault().TaxRate / 100))) * (taxes.FirstOrDefault().TaxRate / 100), BaseUnitId = items.FirstOrDefault().UnitId, BaseQuantity = baseQuantity, BasePrice = basePrice, SalesItemTimeStamp = Convert.ToDateTime(salesInvoiceItem.SalesItemTimeStamp) }; db.TrnSalesInvoiceItems.InsertOnSubmit(addSaleInvoiceItem); db.SubmitChanges(); // =========================== // Update Sales Invoice Amount // =========================== var salesInvoice = from d in db.TrnSalesInvoices where d.Id == addSalesInvoice.Id select d; if (salesInvoice.Any()) { var salesInvoiceItems = from d in db.TrnSalesInvoiceItems where d.SIId == addSalesInvoice.Id select d; Decimal totalSalesInvoiceItemAmount = 0; if (salesInvoiceItems.Any()) { totalSalesInvoiceItemAmount = salesInvoiceItems.Sum(d => d.Amount); } var updateSalesInvoiceAmount = salesInvoice.FirstOrDefault(); updateSalesInvoiceAmount.Amount = totalSalesInvoiceItemAmount; updateSalesInvoiceAmount.BalanceAmount = totalSalesInvoiceItemAmount; db.SubmitChanges(); } } } } } } } } } // ======================================= // Insert Journal and Inventory (Business) // ======================================= var salesInvoiceForBusiness = from d in db.TrnSalesInvoices where d.Id == Convert.ToInt32(addSalesInvoice.Id) select d; if (salesInvoiceForBusiness.Any()) { inventory.InsertSIInventory(Convert.ToInt32(salesInvoiceForBusiness.FirstOrDefault().Id)); journal.insertSIJournal(Convert.ToInt32(salesInvoiceForBusiness.FirstOrDefault().Id)); } return(Request.CreateResponse(HttpStatusCode.OK, addSalesInvoice.SINumber)); } else { return(Request.CreateResponse(HttpStatusCode.BadRequest, "Easyfis: Branch Not Exist!")); } } else { return(Request.CreateResponse(HttpStatusCode.BadRequest, "Easyfis: Term Not Exist!")); } } else { return(Request.CreateResponse(HttpStatusCode.BadRequest, "Easyfis: User Not Exist!")); } } else { return(Request.CreateResponse(HttpStatusCode.BadRequest, "Easyfis: Customer Not Exist!")); } } catch (Exception e) { Debug.WriteLine(e); return(Request.CreateResponse(HttpStatusCode.InternalServerError, "Something's went wrong from the server.")); } }
public HttpResponseMessage AddSalesInvoiceCSVIntegrator(List <CSVIntegratorEntities.CSVIntegratorTrnSalesInvoice> objSalesInvoices) { try { if (objSalesInvoices.Any()) { foreach (var objSalesInvoice in objSalesInvoices) { Boolean currentBranchExist = false; var currentBranch = from d in db.MstBranches where d.BranchCode.Equals(objSalesInvoice.BranchCode) select d; if (currentBranch.Any()) { currentBranchExist = true; } Boolean customersExist = false; var customers = from d in db.MstArticles.OrderBy(d => d.Article) where d.ManualArticleCode.Equals(objSalesInvoice.CustomerCode) && d.ArticleTypeId == 2 && d.IsLocked == true select d; if (customers.Any()) { customersExist = true; } Boolean termsExist = false; var terms = from d in db.MstTerms.OrderBy(d => d.Term) where d.Term.Equals(objSalesInvoice.Term) && d.IsLocked == true select d; if (terms.Any()) { termsExist = true; } Boolean usersExist = false; var users = from d in db.MstUsers.OrderBy(d => d.FullName) where d.IsLocked == true select d; if (users.Any()) { usersExist = true; } Boolean isValid = false; if (currentBranchExist) { if (customersExist) { if (termsExist) { if (usersExist) { isValid = true; } } } } if (isValid) { var defaultSINumber = "0000000001"; var lastSalesInvoice = from d in db.TrnSalesInvoices.OrderByDescending(d => d.Id) where d.MstBranch.BranchCode.Equals(objSalesInvoice.BranchCode) select d; if (lastSalesInvoice.Any()) { var SINumber = Convert.ToInt32(lastSalesInvoice.FirstOrDefault().SINumber) + 0000000001; defaultSINumber = FillLeadingZeroes(SINumber, 10); } Data.TrnSalesInvoice newSalesInvoice = new Data.TrnSalesInvoice { BranchId = currentBranch.FirstOrDefault().Id, SINumber = defaultSINumber, SIDate = Convert.ToDateTime(objSalesInvoice.SIDate), DocumentReference = objSalesInvoice.DocumentReference, CustomerId = customers.FirstOrDefault().Id, TermId = terms.FirstOrDefault().Id, Remarks = objSalesInvoice.Remarks, ManualSINumber = objSalesInvoice.ManualSINumber, Amount = 0, PaidAmount = 0, AdjustmentAmount = 0, BalanceAmount = 0, SoldById = users.FirstOrDefault().Id, PreparedById = users.FirstOrDefault().Id, CheckedById = users.FirstOrDefault().Id, ApprovedById = users.FirstOrDefault().Id, IsLocked = false, CreatedById = users.FirstOrDefault().Id, CreatedDateTime = DateTime.Now, UpdatedById = users.FirstOrDefault().Id, UpdatedDateTime = DateTime.Now }; db.TrnSalesInvoices.InsertOnSubmit(newSalesInvoice); db.SubmitChanges(); } } return(Request.CreateResponse(HttpStatusCode.OK, "Sent Successful!")); } else { return(Request.CreateResponse(HttpStatusCode.BadRequest, "Empty!")); } } catch (Exception e) { Debug.WriteLine(e); return(Request.CreateResponse(HttpStatusCode.InternalServerError, "Something's went wrong from the server! " + e.Message)); } }
public HttpResponseMessage AddSalesInvoicePOSIntegration(Entities.POSIntegrationTrnSalesInvoice POSIntegrationTrnSalesInvoiceObject) { try { var branch = from d in db.MstBranches where d.BranchCode == POSIntegrationTrnSalesInvoiceObject.BranchCode select d; if (branch.Any()) { Int32 currentBranchId = branch.FirstOrDefault().Id; var SINumberResult = "0000000001"; var lastSalesInvoice = from d in db.TrnSalesInvoices.OrderByDescending(d => d.Id) where d.BranchId == currentBranchId select d; if (lastSalesInvoice.Any()) { var SINumber = Convert.ToInt32(lastSalesInvoice.FirstOrDefault().SINumber) + 0000000001; SINumberResult = ZeroFill(SINumber, 10); } Boolean customerExist = false; var customers = from d in db.MstArticles where d.ManualArticleCode == POSIntegrationTrnSalesInvoiceObject.CustomerManualArticleCode && d.ArticleTypeId == 2 select d; if (customers.Any()) { customerExist = true; } Boolean userExist = false; var users = from d in db.MstUsers where d.UserName == POSIntegrationTrnSalesInvoiceObject.CreatedBy select d; if (users.Any()) { userExist = true; } Boolean termExist = false; var terms = from d in db.MstTerms where d.Term == POSIntegrationTrnSalesInvoiceObject.Term select d; if (terms.Any()) { termExist = true; } if (customerExist) { if (userExist) { if (termExist) { Data.TrnSalesInvoice addSalesInvoice = new Data.TrnSalesInvoice { BranchId = currentBranchId, SINumber = SINumberResult, SIDate = Convert.ToDateTime(POSIntegrationTrnSalesInvoiceObject.SIDate), CustomerId = customers.FirstOrDefault().Id, TermId = terms.FirstOrDefault().Id, DocumentReference = POSIntegrationTrnSalesInvoiceObject.DocumentReference, ManualSINumber = POSIntegrationTrnSalesInvoiceObject.ManualSINumber, Remarks = POSIntegrationTrnSalesInvoiceObject.Remarks, Amount = 0, PaidAmount = 0, AdjustmentAmount = 0, BalanceAmount = 0, SoldById = users.FirstOrDefault().Id, PreparedById = users.FirstOrDefault().Id, CheckedById = users.FirstOrDefault().Id, ApprovedById = users.FirstOrDefault().Id, Status = null, IsCancelled = false, IsPrinted = false, IsLocked = true, CreatedById = users.FirstOrDefault().Id, CreatedDateTime = DateTime.Now, UpdatedById = users.FirstOrDefault().Id, UpdatedDateTime = DateTime.Now }; db.TrnSalesInvoices.InsertOnSubmit(addSalesInvoice); db.SubmitChanges(); foreach (var salesInvoiceItem in POSIntegrationTrnSalesInvoiceObject.ListPOSIntegrationTrnSalesInvoiceItem.ToList()) { Boolean itemExist = false; var items = from d in db.MstArticles where d.ManualArticleCode == salesInvoiceItem.ItemManualArticleCode && d.ArticleTypeId == 1 select d; if (items.Any()) { itemExist = true; } if (itemExist) { Int32?itemInventoryId = null; var articleInventory = from d in db.MstArticleInventories where d.BranchId == currentBranchId && d.ArticleId == items.FirstOrDefault().Id select d; if (articleInventory.Any()) { itemInventoryId = articleInventory.FirstOrDefault().Id; } Boolean unitExist = false; var units = from d in db.MstUnits where d.Unit == salesInvoiceItem.Unit select d; if (units.Any()) { unitExist = true; } Boolean discountExist = false; var discounts = from d in db.MstDiscounts where d.Discount == salesInvoiceItem.Discount select d; if (discounts.Any()) { discountExist = true; } Boolean taxExist = false; var taxes = from d in db.MstTaxTypes where d.TaxType == salesInvoiceItem.VAT select d; if (taxes.Any()) { taxExist = true; } if (unitExist) { if (discountExist) { if (taxExist) { var conversionUnit = from d in db.MstArticleUnits where d.ArticleId == items.FirstOrDefault().Id && d.UnitId == items.FirstOrDefault().UnitId select d; if (conversionUnit.Any()) { Decimal baseQuantity = salesInvoiceItem.Quantity * 1; if (conversionUnit.FirstOrDefault().Multiplier > 0) { baseQuantity = salesInvoiceItem.Quantity * (1 / conversionUnit.FirstOrDefault().Multiplier); } Decimal basePrice = salesInvoiceItem.Amount; if (baseQuantity > 0) { basePrice = salesInvoiceItem.Amount / baseQuantity; } Data.TrnSalesInvoiceItem addSaleInvoiceItem = new Data.TrnSalesInvoiceItem { SIId = addSalesInvoice.Id, ItemId = items.FirstOrDefault().Id, ItemInventoryId = itemInventoryId, Particulars = salesInvoiceItem.Particulars, UnitId = units.FirstOrDefault().Id, Quantity = salesInvoiceItem.Quantity, Price = salesInvoiceItem.Price, DiscountId = discounts.FirstOrDefault().Id, DiscountRate = discounts.FirstOrDefault().DiscountRate, DiscountAmount = salesInvoiceItem.DiscountAmount, NetPrice = salesInvoiceItem.NetPrice, Amount = salesInvoiceItem.Amount, VATId = taxes.FirstOrDefault().Id, VATPercentage = taxes.FirstOrDefault().TaxRate, VATAmount = (salesInvoiceItem.Amount / (1 + (taxes.FirstOrDefault().TaxRate / 100))) * (taxes.FirstOrDefault().TaxRate / 100), BaseUnitId = items.FirstOrDefault().UnitId, BaseQuantity = baseQuantity, BasePrice = basePrice, SalesItemTimeStamp = Convert.ToDateTime(salesInvoiceItem.SalesItemTimeStamp) }; db.TrnSalesInvoiceItems.InsertOnSubmit(addSaleInvoiceItem); db.SubmitChanges(); } } } } } } var salesInvoice = from d in db.TrnSalesInvoices where d.Id == addSalesInvoice.Id select d; if (salesInvoice.Any()) { var salesInvoiceItems = from d in db.TrnSalesInvoiceItems where d.SIId == addSalesInvoice.Id select d; Decimal totalSalesInvoiceItemAmount = 0; if (salesInvoiceItems.Any()) { totalSalesInvoiceItemAmount = salesInvoiceItems.Sum(d => d.Amount); } var updateSalesInvoiceAmount = salesInvoice.FirstOrDefault(); updateSalesInvoiceAmount.Amount = totalSalesInvoiceItemAmount; updateSalesInvoiceAmount.BalanceAmount = totalSalesInvoiceItemAmount; db.SubmitChanges(); } var salesInvoiceForBusiness = from d in db.TrnSalesInvoices where d.Id == Convert.ToInt32(addSalesInvoice.Id) select d; if (salesInvoiceForBusiness.Any()) { inventory.InsertSalesInvoiceInventory(Convert.ToInt32(salesInvoiceForBusiness.FirstOrDefault().Id)); journal.InsertSalesInvoiceJournal(Convert.ToInt32(salesInvoiceForBusiness.FirstOrDefault().Id)); } return(Request.CreateResponse(HttpStatusCode.OK, addSalesInvoice.SINumber)); } else { return(Request.CreateResponse(HttpStatusCode.BadRequest, "Easyfis: Term Not Exist!")); } } else { return(Request.CreateResponse(HttpStatusCode.BadRequest, "Easyfis: User Not Exist!")); } } else { return(Request.CreateResponse(HttpStatusCode.BadRequest, "Easyfis: Customer Not Exist!")); } } else { return(Request.CreateResponse(HttpStatusCode.BadRequest, "Easyfis: Branch Not Exist!")); } } catch (Exception e) { Debug.WriteLine(e); return(Request.CreateResponse(HttpStatusCode.InternalServerError, "Something's went wrong from the server.")); } }
public Int32 insertSalesInvoice(Models.TrnSalesInvoice sales) { try { var userId = (from d in db.MstUsers where d.UserId == User.Identity.GetUserId() select d.Id).SingleOrDefault(); var lastSINumber = from d in db.TrnSalesInvoices.OrderByDescending(d => d.Id) select d; var SINumberResult = "0000000001"; if (lastSINumber.Any()) { var SINumber = Convert.ToInt32(lastSINumber.FirstOrDefault().SINumber) + 0000000001; SINumberResult = zeroFill(SINumber, 10); } Data.TrnSalesInvoice newSalesInvoice = new Data.TrnSalesInvoice(); newSalesInvoice.BranchId = currentBranchId(); newSalesInvoice.SINumber = SINumberResult; newSalesInvoice.SIDate = DateTime.Today; newSalesInvoice.CustomerId = (from d in db.MstArticles where d.ArticleTypeId == 2 select d.Id).FirstOrDefault(); newSalesInvoice.TermId = (from d in db.MstTerms select d.Id).FirstOrDefault(); newSalesInvoice.DocumentReference = "NA"; newSalesInvoice.ManualSINumber = "NA"; newSalesInvoice.Remarks = "NA"; newSalesInvoice.Amount = 0; newSalesInvoice.PaidAmount = 0; newSalesInvoice.AdjustmentAmount = 0; newSalesInvoice.BalanceAmount = 0; newSalesInvoice.SoldById = userId; newSalesInvoice.PreparedById = userId; newSalesInvoice.CheckedById = userId; newSalesInvoice.ApprovedById = userId; newSalesInvoice.IsLocked = false; newSalesInvoice.CreatedById = userId; newSalesInvoice.CreatedDateTime = DateTime.Now; newSalesInvoice.UpdatedById = userId; newSalesInvoice.UpdatedDateTime = DateTime.Now; db.TrnSalesInvoices.InsertOnSubmit(newSalesInvoice); db.SubmitChanges(); return newSalesInvoice.Id; } catch { return 0; } }