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 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, 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, 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 salesInvoice = from d in db.TrnSalesInvoices where d.ManualSINumber.Equals(objSales.FTN) select d; if (salesInvoice.Any()) { salesInvoiceId = salesInvoice.FirstOrDefault().Id; Business.Inventory inventory = new Business.Inventory(); inventory.DeleteSalesInvoiceInventory(Convert.ToInt32(salesInvoiceId)); Business.Journal journal = new Business.Journal(); journal.DeleteSalesInvoiceJournal(Convert.ToInt32(salesInvoiceId)); listSINumber.Add(new Entities.ReturnedDocument() { SINumber = salesInvoice.FirstOrDefault().SINumber, ManualSINumber = salesInvoice.FirstOrDefault().ManualSINumber }); } else { 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 = DateTime.Today, 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, 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, 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()) { var salesInvoiceItems = from d in db.TrnSalesInvoiceItems where d.SIId == salesInvoiceId select d; Decimal salesAmount = 0; Decimal paidAmount = currentSalesInvoice.FirstOrDefault().PaidAmount; Decimal adjustmentAmount = currentSalesInvoice.FirstOrDefault().AdjustmentAmount; 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()) { // ================== // Process Collection // ================== 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 = DateTime.Today, ManualORNumber = "NA", CustomerId = customers.FirstOrDefault().Id, Particulars = "NA", 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.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 = false }; db.TrnCollectionLines.InsertOnSubmit(newCollectionLine); db.SubmitChanges(); } } } } } } } } } } return(listSINumber.ToList()); } else { return(new List <Entities.ReturnedDocument>()); } } catch (Exception e) { Debug.WriteLine(e); return(new List <Entities.ReturnedDocument>()); } }
public HttpResponseMessage UnlockSalesInvoice(String id) { 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 userForms = from d in db.MstUserForms where d.UserId == currentUserId && d.SysForm.FormName.Equals("SalesInvoiceDetail") select d; if (userForms.Any()) { if (userForms.FirstOrDefault().CanUnlock) { var salesInvoice = from d in db.TrnSalesInvoices where d.Id == Convert.ToInt32(id) select d; if (salesInvoice.Any()) { if (salesInvoice.FirstOrDefault().IsLocked) { String oldObject = auditTrail.GetObjectString(salesInvoice.FirstOrDefault()); var unlockSalesInvoice = salesInvoice.FirstOrDefault(); unlockSalesInvoice.IsLocked = false; unlockSalesInvoice.UpdatedById = currentUserId; unlockSalesInvoice.UpdatedDateTime = DateTime.Now; db.SubmitChanges(); if (!unlockSalesInvoice.IsLocked) { inventory.DeleteSalesInvoiceInventory(Convert.ToInt32(id)); journal.DeleteSalesInvoiceJournal(Convert.ToInt32(id)); } String newObject = auditTrail.GetObjectString(salesInvoice.FirstOrDefault()); auditTrail.InsertAuditTrail(currentUser.FirstOrDefault().Id, GetType().Name, MethodBase.GetCurrentMethod().Name, oldObject, newObject); return(Request.CreateResponse(HttpStatusCode.OK)); } else { return(Request.CreateResponse(HttpStatusCode.BadRequest, "Unlocking Error. These sales invoice details are already unlocked.")); } } else { return(Request.CreateResponse(HttpStatusCode.NotFound, "Data not found. These sales invoice details are not found in the server.")); } } else { return(Request.CreateResponse(HttpStatusCode.BadRequest, "Sorry. You have no rights to unlock 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 updateSalesInvoice(String id, Models.TrnSalesInvoice sales) { try { var userId = (from d in db.MstUsers where d.UserId == User.Identity.GetUserId() select d.Id).SingleOrDefault(); var salesInvoices = from d in db.TrnSalesInvoices where d.Id == Convert.ToInt32(id) select d; if (salesInvoices.Any()) { Decimal PaidAmount = 0; var collectionLinesORId = from d in db.TrnCollectionLines where d.SIId == Convert.ToInt32(id) select d; if (collectionLinesORId.Any()) { Boolean collectionHeaderIsLocked = (from d in db.TrnCollections where d.Id == collectionLinesORId.First().ORId select d.IsLocked).SingleOrDefault(); var collectionLines = from d in db.TrnCollectionLines where d.SIId == Convert.ToInt32(id) select d; if (collectionLines.Any()) { if (collectionHeaderIsLocked == true) { PaidAmount = collectionLines.Sum(d => d.Amount); } } } var updateSalesInvoice = salesInvoices.FirstOrDefault(); updateSalesInvoice.BranchId = sales.BranchId; updateSalesInvoice.SINumber = sales.SINumber; updateSalesInvoice.SIDate = Convert.ToDateTime(sales.SIDate); updateSalesInvoice.CustomerId = sales.CustomerId; updateSalesInvoice.TermId = sales.TermId; updateSalesInvoice.DocumentReference = sales.DocumentReference; updateSalesInvoice.ManualSINumber = sales.ManualSINumber; updateSalesInvoice.Remarks = sales.Remarks; updateSalesInvoice.Amount = getAmountSalesInvoiceItem(Convert.ToInt32(id)); updateSalesInvoice.PaidAmount = PaidAmount; updateSalesInvoice.AdjustmentAmount = 0; updateSalesInvoice.BalanceAmount = getAmountSalesInvoiceItem(Convert.ToInt32(id)) - PaidAmount; updateSalesInvoice.SoldById = sales.SoldById; updateSalesInvoice.PreparedById = sales.PreparedById; updateSalesInvoice.CheckedById = sales.CheckedById; updateSalesInvoice.ApprovedById = sales.ApprovedById; updateSalesInvoice.IsLocked = true; updateSalesInvoice.UpdatedById = userId; updateSalesInvoice.UpdatedDateTime = DateTime.Now; db.SubmitChanges(); inventory.InsertSalesInvoiceInventory(Convert.ToInt32(id)); journal.InsertSalesInvoiceJournal(Convert.ToInt32(id)); // Check for negative inventory bool foundNegativeQuantity = false; if (updateSalesInvoice.TrnSalesInvoiceItems.Any()) { foreach (var salesInvoiceItem in updateSalesInvoice.TrnSalesInvoiceItems) { if (salesInvoiceItem.MstArticle.IsInventory) { var mstArticleInventory = from d in db.MstArticleInventories where d.TrnSalesInvoiceItems.Contains(salesInvoiceItem) select d; if (mstArticleInventory.Any()) { if (salesInvoiceItem.MstArticleInventory.Quantity < 0) { foundNegativeQuantity = true; break; } } } } } if (!foundNegativeQuantity) { return(Request.CreateResponse(HttpStatusCode.OK)); } else { inventory.DeleteSalesInvoiceInventory(Convert.ToInt32(id)); journal.DeleteSalesInvoiceJournal(Convert.ToInt32(id)); updateSalesInvoice.IsLocked = false; db.SubmitChanges(); return(Request.CreateResponse(HttpStatusCode.BadRequest, "Negative Inventory Found!")); } } else { return(Request.CreateResponse(HttpStatusCode.NotFound, "No Sales Invoice Found!")); } } catch (Exception e) { Debug.WriteLine(e); return(Request.CreateResponse(HttpStatusCode.BadRequest, "Internal Server Error!")); } }