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 AddCSVIntegratorSalesInvoiceItem(List <CSVIntegratorEntities.CSVIntegratorTrnSalesInvoiceItem> objSalesInvoiceItems)
{
try
{
if (objSalesInvoiceItems.Any())
{
List <Int32> listSalesInvoiceIds = new List <Int32>();
foreach (var objSalesInvoiceItem in objSalesInvoiceItems)
{
Boolean salesInvoiceExists = false;
var salesInvoice = from d in db.TrnSalesInvoices where d.MstBranch.BranchCode.Equals(objSalesInvoiceItem.BranchCode) && d.ManualSINumber.Equals(objSalesInvoiceItem.ManualSINumber) select d;
if (salesInvoice.Any())
{
listSalesInvoiceIds.Add(salesInvoice.FirstOrDefault().Id);
salesInvoiceExists = true;
}
Boolean itemExists = false;
var items = from d in db.MstArticles where d.ManualArticleCode.Equals(objSalesInvoiceItem.ItemCode) && d.ArticleTypeId == 1 && d.IsLocked == true select d;
if (items.Any())
{
itemExists = true;
}
Boolean unitExist = false;
var units = from d in db.MstUnits where d.Unit == objSalesInvoiceItem.Unit select d;
if (units.Any())
{
unitExist = true;
}
Boolean taxTypesExist = false;
var taxTypes = from d in db.MstTaxTypes where d.TaxType == objSalesInvoiceItem.VAT && d.IsLocked == true select d;
if (taxTypes.Any())
{
taxTypesExist = true;
}
Boolean discountsExist = false;
var discounts = from d in db.MstDiscounts where d.Discount == objSalesInvoiceItem.Discount && d.IsLocked == true select d;
if (discounts.Any())
{
discountsExist = true;
}
Boolean isValid = false;
if (salesInvoiceExists)
{
if (itemExists)
{
if (unitExist)
{
if (taxTypesExist)
{
if (discountsExist)
{
if (!salesInvoice.FirstOrDefault().IsLocked)
{
isValid = true;
}
}
}
}
}
}
if (isValid)
{
Int32?itemInventoryId = null;
var articleInventory = from d in db.MstArticleInventories where d.MstBranch.BranchCode.Equals(objSalesInvoiceItem.BranchCode) && d.ArticleId == items.FirstOrDefault().Id select d;
if (articleInventory.Any())
{
itemInventoryId = articleInventory.FirstOrDefault().Id;
}
// ===============
// Package Kitting
// ===============
if (items.FirstOrDefault().Kitting == 2)
{
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 = objSalesInvoiceItem.Quantity * 1;
Decimal basePrice = objSalesInvoiceItem.Amount;
if (packageConversionUnit.FirstOrDefault().Multiplier > 0)
{
baseQuantity = objSalesInvoiceItem.Quantity * (1 / packageConversionUnit.FirstOrDefault().Multiplier);
}
if (baseQuantity > 0)
{
basePrice = objSalesInvoiceItem.Amount / baseQuantity;
}
Data.TrnSalesInvoiceItem addSaleInvoiceItemPackage = new Data.TrnSalesInvoiceItem
{
SIId = salesInvoice.FirstOrDefault().Id,
ItemId = items.FirstOrDefault().Id,
ItemInventoryId = itemInventoryId,
Particulars = objSalesInvoiceItem.Particulars,
UnitId = units.FirstOrDefault().Id,
Quantity = objSalesInvoiceItem.Quantity,
Price = objSalesInvoiceItem.Price,
DiscountId = discounts.FirstOrDefault().Id,
DiscountRate = discounts.FirstOrDefault().DiscountRate,
DiscountAmount = objSalesInvoiceItem.DiscountAmount,
NetPrice = objSalesInvoiceItem.NetPrice,
Amount = objSalesInvoiceItem.Amount,
VATId = taxTypes.FirstOrDefault().Id,
VATPercentage = taxTypes.FirstOrDefault().TaxRate,
VATAmount = (objSalesInvoiceItem.Amount / (1 + (taxTypes.FirstOrDefault().TaxRate / 100))) * (taxTypes.FirstOrDefault().TaxRate / 100),
BaseUnitId = items.FirstOrDefault().UnitId,
BaseQuantity = baseQuantity,
BasePrice = basePrice,
SalesItemTimeStamp = Convert.ToDateTime(objSalesInvoiceItem.SalesItemTimeStamp)
};
db.TrnSalesInvoiceItems.InsertOnSubmit(addSaleInvoiceItemPackage);
var articleComponents = from d in db.MstArticleComponents where d.MstArticle.ManualArticleCode == objSalesInvoiceItem.ItemCode select d;
if (articleComponents.Any())
{
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 + (taxTypes.FirstOrDefault().TaxRate / 100));
salesInvoiceItemDiscountAmount = price * (discounts.FirstOrDefault().DiscountRate / 100);
salesInvoiceItemNetPrice = price - (price * (discounts.FirstOrDefault().DiscountRate / 100));
}
}
Decimal quantity = articleComponent.Quantity * objSalesInvoiceItem.Quantity;
Decimal amount = quantity * salesInvoiceItemNetPrice;
Decimal VATAmount = amount * (taxTypes.FirstOrDefault().TaxRate / 100);
var taxTypeTAXIsInclusive = from d in db.MstTaxTypes where d.Id == taxTypes.FirstOrDefault().Id select d;
if (taxTypeTAXIsInclusive.Any())
{
if (taxTypeTAXIsInclusive.FirstOrDefault().IsInclusive)
{
VATAmount = amount / (1 + (taxTypes.FirstOrDefault().TaxRate / 100)) * (taxTypes.FirstOrDefault().TaxRate / 100);
}
}
Int32? componentItemInventoryId = null;
Boolean isValidComponentItem = false;
if (articleComponent.MstArticle1.IsInventory)
{
var componentArticleInventory = from d in db.MstArticleInventories where d.MstBranch.BranchCode.Equals(objSalesInvoiceItem.BranchCode) && d.ArticleId == articleComponent.ComponentArticleId select d;
if (componentArticleInventory.Any())
{
componentItemInventoryId = componentArticleInventory.FirstOrDefault().Id;
isValidComponentItem = true;
}
}
else
{
isValidComponentItem = true;
}
if (isValidComponentItem)
{
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 * objSalesInvoiceItem.Quantity) * 1;
if (componentItemConversionUnit.FirstOrDefault().Multiplier > 0)
{
componentBaseQuantity = (articleComponent.Quantity * objSalesInvoiceItem.Quantity) * (1 / componentItemConversionUnit.FirstOrDefault().Multiplier);
}
Decimal componentBasePrice = amount;
if (baseQuantity > 0)
{
componentBasePrice = amount / baseQuantity;
}
Data.TrnSalesInvoiceItem addSaleInvoiceItem = new Data.TrnSalesInvoiceItem
{
SIId = salesInvoice.FirstOrDefault().Id,
ItemId = articleComponent.ComponentArticleId,
ItemInventoryId = componentItemInventoryId,
Particulars = articleComponent.Particulars,
UnitId = articleComponent.MstArticle1.UnitId,
Quantity = articleComponent.Quantity * objSalesInvoiceItem.Quantity,
Price = 0,
DiscountId = discounts.FirstOrDefault().Id,
DiscountRate = discounts.FirstOrDefault().DiscountRate,
DiscountAmount = salesInvoiceItemDiscountAmount,
NetPrice = salesInvoiceItemNetPrice,
Amount = amount,
VATId = taxTypes.FirstOrDefault().Id,
VATPercentage = taxTypes.FirstOrDefault().TaxRate,
VATAmount = VATAmount,
BaseUnitId = componentItem.FirstOrDefault().UnitId,
BaseQuantity = componentBaseQuantity,
BasePrice = componentBasePrice,
SalesItemTimeStamp = Convert.ToDateTime(objSalesInvoiceItem.SalesItemTimeStamp)
};
db.TrnSalesInvoiceItems.InsertOnSubmit(addSaleInvoiceItem);
}
}
}
}
}
Decimal salesInvoiceItemTotalAmount = 0;
if (salesInvoice.FirstOrDefault().TrnSalesInvoiceItems.Any())
{
salesInvoiceItemTotalAmount = salesInvoice.FirstOrDefault().TrnSalesInvoiceItems.Sum(d => d.Amount);
}
var updateSalesInvoiceAmount = salesInvoice.FirstOrDefault();
updateSalesInvoiceAmount.Amount = salesInvoiceItemTotalAmount;
}
}
else
{
// ==================
// Main Selected Item
// ==================
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 = objSalesInvoiceItem.Quantity * 1;
if (conversionUnit.FirstOrDefault().Multiplier > 0)
{
baseQuantity = objSalesInvoiceItem.Quantity * (1 / conversionUnit.FirstOrDefault().Multiplier);
}
Decimal basePrice = objSalesInvoiceItem.Amount;
if (baseQuantity > 0)
{
basePrice = objSalesInvoiceItem.Amount / baseQuantity;
}
Data.TrnSalesInvoiceItem addSaleInvoiceItem = new Data.TrnSalesInvoiceItem
{
SIId = salesInvoice.FirstOrDefault().Id,
ItemId = items.FirstOrDefault().Id,
ItemInventoryId = itemInventoryId,
Particulars = objSalesInvoiceItem.Particulars,
UnitId = units.FirstOrDefault().Id,
Quantity = objSalesInvoiceItem.Quantity,
Price = objSalesInvoiceItem.Price,
DiscountId = discounts.FirstOrDefault().Id,
DiscountRate = discounts.FirstOrDefault().DiscountRate,
DiscountAmount = objSalesInvoiceItem.DiscountAmount,
NetPrice = objSalesInvoiceItem.NetPrice,
Amount = objSalesInvoiceItem.Amount,
VATId = taxTypes.FirstOrDefault().Id,
VATPercentage = taxTypes.FirstOrDefault().TaxRate,
VATAmount = (objSalesInvoiceItem.Amount / (1 + (taxTypes.FirstOrDefault().TaxRate / 100))) * (taxTypes.FirstOrDefault().TaxRate / 100),
BaseUnitId = items.FirstOrDefault().UnitId,
BaseQuantity = baseQuantity,
BasePrice = basePrice,
SalesItemTimeStamp = Convert.ToDateTime(objSalesInvoiceItem.SalesItemTimeStamp)
};
db.TrnSalesInvoiceItems.InsertOnSubmit(addSaleInvoiceItem);
Decimal salesInvoiceItemTotalAmount = 0;
if (salesInvoice.FirstOrDefault().TrnSalesInvoiceItems.Any())
{
salesInvoiceItemTotalAmount = salesInvoice.FirstOrDefault().TrnSalesInvoiceItems.Sum(d => d.Amount);
}
var updateSalesInvoiceAmount = salesInvoice.FirstOrDefault();
updateSalesInvoiceAmount.Amount = salesInvoiceItemTotalAmount;
}
}
}
}
db.SubmitChanges();
if (listSalesInvoiceIds.Any())
{
var salesInvoiceIds = from d in listSalesInvoiceIds
group d by d into g
select g.Key;
if (salesInvoiceIds.Any())
{
foreach (var salesInvoiceId in salesInvoiceIds)
{
LockCSVIntegratorSalesInvoice(salesInvoiceId);
}
}
}
return(Request.CreateResponse(HttpStatusCode.OK, "Sent Successful!"));
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "Empty!"));
}
}
catch (Exception e)
{
Debug.WriteLine(e.Message);
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,
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 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 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 insertSalesInvoiceItem(Models.TrnSalesInvoiceItem saleItem)
{
try
{
var articleComponents = from d in db.MstArticleComponents
where d.ArticleId == saleItem.ItemId
select new Models.MstArticleComponent
{
Id = d.Id,
ArticleId = d.ArticleId,
ComponentArticleId = d.ComponentArticleId,
ComponentArticle = d.MstArticle1.Article,
Quantity = d.Quantity,
UnitId = d.MstArticle1.UnitId,
Cost = Convert.ToDecimal(d.MstArticle1.Cost),
Price = d.MstArticle1.Price,
ComponentArticleInventoryId = (from i in db.MstArticleInventories where i.BranchId == currentBranchId() && i.ArticleId == d.ComponentArticleId select i.Id).FirstOrDefault(),
Amount = d.Quantity * Convert.ToDecimal(d.MstArticle1.Cost),
Particulars = d.Particulars
};
if (articleComponents.Any())
{
var kittingItem = (from d in db.MstArticles where d.Id == saleItem.ItemId select d.Kitting).SingleOrDefault();
if (kittingItem == 2)
{
Data.TrnSalesInvoiceItem newSaleInvoiceItemPackage = new Data.TrnSalesInvoiceItem();
newSaleInvoiceItemPackage.SIId = saleItem.SIId;
newSaleInvoiceItemPackage.ItemId = saleItem.ItemId;
newSaleInvoiceItemPackage.ItemInventoryId = saleItem.ItemInventoryId;
newSaleInvoiceItemPackage.Particulars = saleItem.Particulars;
newSaleInvoiceItemPackage.UnitId = saleItem.UnitId;
newSaleInvoiceItemPackage.Quantity = saleItem.Quantity;
newSaleInvoiceItemPackage.Price = saleItem.Price;
newSaleInvoiceItemPackage.DiscountId = saleItem.DiscountId;
newSaleInvoiceItemPackage.DiscountRate = saleItem.DiscountRate;
newSaleInvoiceItemPackage.DiscountAmount = saleItem.DiscountAmount;
newSaleInvoiceItemPackage.NetPrice = saleItem.NetPrice;
newSaleInvoiceItemPackage.Amount = saleItem.Amount;
newSaleInvoiceItemPackage.VATId = saleItem.VATId;
newSaleInvoiceItemPackage.VATPercentage = saleItem.VATPercentage;
newSaleInvoiceItemPackage.VATAmount = saleItem.VATAmount;
var packageItem = from d in db.MstArticles where d.Id == saleItem.ItemId select d;
newSaleInvoiceItemPackage.BaseUnitId = packageItem.First().UnitId;
var packageConversionUnit = from d in db.MstArticleUnits where d.ArticleId == saleItem.ItemId && d.UnitId == saleItem.UnitId select d;
if (packageConversionUnit.First().Multiplier > 0)
{
newSaleInvoiceItemPackage.BaseQuantity = saleItem.Quantity * (1 / packageConversionUnit.First().Multiplier);
}
else
{
newSaleInvoiceItemPackage.BaseQuantity = saleItem.Quantity * 1;
}
var packageBaseQuantity = saleItem.Quantity * (1 / packageConversionUnit.First().Multiplier);
if (packageBaseQuantity > 0)
{
newSaleInvoiceItemPackage.BasePrice = saleItem.Amount / packageBaseQuantity;
}
else
{
newSaleInvoiceItemPackage.BasePrice = saleItem.Amount;
}
db.TrnSalesInvoiceItems.InsertOnSubmit(newSaleInvoiceItemPackage);
db.SubmitChanges();
var packageSalesInvoces = from d in db.TrnSalesInvoices where d.Id == saleItem.SIId select d;
if (packageSalesInvoces.Any())
{
var salesInvoiceItems = from d in db.TrnSalesInvoiceItems where d.SIId == saleItem.SIId select d;
Decimal amount = 0;
if (salesInvoiceItems.Any())
{
amount = salesInvoiceItems.Sum(d => d.Amount + d.VATAmount);
}
var updateSalesInvoice = packageSalesInvoces.FirstOrDefault();
updateSalesInvoice.Amount = amount;
db.SubmitChanges();
}
foreach (var articleComponent in articleComponents)
{
Data.TrnSalesInvoiceItem newSaleInvoiceItem = new Data.TrnSalesInvoiceItem();
var discountIsInclusiveQuery = from d in db.MstDiscounts where d.Id == saleItem.DiscountId select d;
Decimal saleItemDiscountAmount = 0;
Decimal netPrice = 0;
if (discountIsInclusiveQuery.FirstOrDefault().IsInclusive == false)
{
var price = 0 / (1 + (saleItem.VATPercentage / 100));
saleItemDiscountAmount = price * (saleItem.DiscountRate / 100);
var newDiscountAmount = price * (saleItem.DiscountRate / 100);
netPrice = price - newDiscountAmount;
}
else
{
saleItemDiscountAmount = 0 * (saleItem.DiscountRate / 100);
var newDiscountAmount = 0 * (saleItem.DiscountRate / 100);
netPrice = 0 - newDiscountAmount;
}
Decimal quantity = articleComponent.Quantity * saleItem.Quantity;
Decimal amount = quantity * netPrice;
Decimal VATAmount = 0;
var taxTypeTAXIsInclusive = from d in db.MstTaxTypes where d.Id == saleItem.VATId select d;
if (taxTypeTAXIsInclusive.FirstOrDefault().IsInclusive == true)
{
VATAmount = amount / (1 + (saleItem.VATPercentage / 100)) * (saleItem.VATPercentage / 100);
}
else
{
VATAmount = amount * (saleItem.VATPercentage / 100);
}
newSaleInvoiceItem.SIId = saleItem.SIId;
newSaleInvoiceItem.ItemId = articleComponent.ComponentArticleId;
newSaleInvoiceItem.ItemInventoryId = articleComponent.ComponentArticleInventoryId;
newSaleInvoiceItem.Particulars = articleComponent.Particulars;
newSaleInvoiceItem.UnitId = articleComponent.UnitId;
newSaleInvoiceItem.Quantity = articleComponent.Quantity * saleItem.Quantity;
newSaleInvoiceItem.Price = 0;
newSaleInvoiceItem.DiscountId = saleItem.DiscountId;
newSaleInvoiceItem.DiscountRate = saleItem.DiscountRate;
newSaleInvoiceItem.DiscountAmount = saleItemDiscountAmount;
newSaleInvoiceItem.NetPrice = netPrice;
newSaleInvoiceItem.Amount = amount;
newSaleInvoiceItem.VATId = saleItem.VATId;
newSaleInvoiceItem.VATPercentage = saleItem.VATPercentage;
newSaleInvoiceItem.VATAmount = VATAmount;
var item = from d in db.MstArticles where d.Id == articleComponent.ComponentArticleId select d;
newSaleInvoiceItem.BaseUnitId = item.First().UnitId;
var conversionUnit = from d in db.MstArticleUnits where d.ArticleId == articleComponent.ComponentArticleId && d.UnitId == articleComponent.UnitId select d;
if (conversionUnit.Any())
{
if (conversionUnit.First().Multiplier > 0)
{
newSaleInvoiceItem.BaseQuantity = (articleComponent.Quantity * saleItem.Quantity) * (1 / conversionUnit.First().Multiplier);
}
else
{
newSaleInvoiceItem.BaseQuantity = (articleComponent.Quantity * saleItem.Quantity) * 1;
}
var baseQuantity = (articleComponent.Quantity * saleItem.Quantity) * (1 / conversionUnit.First().Multiplier);
if (baseQuantity > 0)
{
newSaleInvoiceItem.BasePrice = amount / baseQuantity;
}
else
{
newSaleInvoiceItem.BasePrice = amount;
}
}
else
{
newSaleInvoiceItem.BaseQuantity = (articleComponent.Quantity * saleItem.Quantity) * 1;
newSaleInvoiceItem.BasePrice = amount;
}
db.TrnSalesInvoiceItems.InsertOnSubmit(newSaleInvoiceItem);
db.SubmitChanges();
var salesInvoces = from d in db.TrnSalesInvoices where d.Id == saleItem.SIId select d;
if (salesInvoces.Any())
{
var salesInvoiceItems = from d in db.TrnSalesInvoiceItems where d.SIId == saleItem.SIId select d;
Decimal salesAmount = 0;
if (salesInvoiceItems.Any())
{
salesAmount = salesInvoiceItems.Sum(d => d.Amount + d.VATAmount);
}
var updateSalesInvoice = salesInvoces.FirstOrDefault();
updateSalesInvoice.Amount = salesAmount;
db.SubmitChanges();
}
}
return Request.CreateResponse(HttpStatusCode.OK);
}
else
{
return Request.CreateResponse(HttpStatusCode.NotFound);
}
}
else
{
Data.TrnSalesInvoiceItem newSaleInvoiceItem = new Data.TrnSalesInvoiceItem();
newSaleInvoiceItem.SIId = saleItem.SIId;
newSaleInvoiceItem.ItemId = saleItem.ItemId;
newSaleInvoiceItem.ItemInventoryId = saleItem.ItemInventoryId;
newSaleInvoiceItem.Particulars = saleItem.Particulars;
newSaleInvoiceItem.UnitId = saleItem.UnitId;
newSaleInvoiceItem.Quantity = saleItem.Quantity;
newSaleInvoiceItem.Price = saleItem.Price;
newSaleInvoiceItem.DiscountId = saleItem.DiscountId;
newSaleInvoiceItem.DiscountRate = saleItem.DiscountRate;
newSaleInvoiceItem.DiscountAmount = saleItem.DiscountAmount;
newSaleInvoiceItem.NetPrice = saleItem.NetPrice;
newSaleInvoiceItem.Amount = saleItem.Amount;
newSaleInvoiceItem.VATId = saleItem.VATId;
newSaleInvoiceItem.VATPercentage = saleItem.VATPercentage;
newSaleInvoiceItem.VATAmount = saleItem.VATAmount;
var item = from d in db.MstArticles where d.Id == saleItem.ItemId select d;
newSaleInvoiceItem.BaseUnitId = item.First().UnitId;
var conversionUnit = from d in db.MstArticleUnits where d.ArticleId == saleItem.ItemId && d.UnitId == saleItem.UnitId select d;
if (conversionUnit.First().Multiplier > 0)
{
newSaleInvoiceItem.BaseQuantity = saleItem.Quantity * (1 / conversionUnit.First().Multiplier);
}
else
{
newSaleInvoiceItem.BaseQuantity = saleItem.Quantity * 1;
}
var baseQuantity = saleItem.Quantity * (1 / conversionUnit.First().Multiplier);
if (baseQuantity > 0)
{
newSaleInvoiceItem.BasePrice = saleItem.Amount / baseQuantity;
}
else
{
newSaleInvoiceItem.BasePrice = saleItem.Amount;
}
db.TrnSalesInvoiceItems.InsertOnSubmit(newSaleInvoiceItem);
db.SubmitChanges();
var salesInvoces = from d in db.TrnSalesInvoices where d.Id == saleItem.SIId select d;
if (salesInvoces.Any())
{
var salesInvoiceItems = from d in db.TrnSalesInvoiceItems where d.SIId == saleItem.SIId select d;
Decimal amount = 0;
if (salesInvoiceItems.Any())
{
amount = salesInvoiceItems.Sum(d => d.Amount + d.VATAmount);
}
var updateSalesInvoice = salesInvoces.FirstOrDefault();
updateSalesInvoice.Amount = amount;
db.SubmitChanges();
}
return Request.CreateResponse(HttpStatusCode.OK);
}
}
catch (Exception e)
{
Debug.WriteLine(e);
return Request.CreateResponse(HttpStatusCode.BadRequest);
}
}
public HttpResponseMessage AddSalesInvoiceItem(Entities.TrnSalesInvoiceItem objSalesInvoiceItem, String SIId)
{
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 userForms = from d in db.MstUserForms
where d.UserId == currentUserId &&
d.SysForm.FormName.Equals("SalesInvoiceDetail")
select d;
if (userForms.Any())
{
if (userForms.FirstOrDefault().CanAdd)
{
var salesInvoice = from d in db.TrnSalesInvoices
where d.Id == Convert.ToInt32(SIId)
select d;
if (salesInvoice.Any())
{
if (!salesInvoice.FirstOrDefault().IsLocked)
{
var item = from d in db.MstArticles
where d.Id == objSalesInvoiceItem.ItemId &&
d.ArticleTypeId == 1 &&
d.IsLocked == true
select d;
if (item.Any())
{
var taxTypes = from d in db.MstTaxTypes
where d.Id == objSalesInvoiceItem.VATId &&
d.IsLocked == true
select d;
if (taxTypes.Any())
{
var discounts = from d in db.MstDiscounts
where d.Id == objSalesInvoiceItem.DiscountId &&
d.IsLocked == true
select d;
if (discounts.Any())
{
var conversionUnit = from d in db.MstArticleUnits
where d.ArticleId == objSalesInvoiceItem.ItemId &&
d.UnitId == objSalesInvoiceItem.UnitId &&
d.MstArticle.IsLocked == true
select d;
if (conversionUnit.Any())
{
Decimal discountAmount = objSalesInvoiceItem.Price * (objSalesInvoiceItem.DiscountRate / 100);
Decimal netPrice = objSalesInvoiceItem.Price - discountAmount;
Decimal amount = netPrice * objSalesInvoiceItem.Quantity;
Decimal VATAmount = amount * (objSalesInvoiceItem.VATPercentage / 100);
if (taxTypes.FirstOrDefault().IsInclusive)
{
VATAmount = amount / (1 + (objSalesInvoiceItem.VATPercentage / 100)) * (objSalesInvoiceItem.VATPercentage / 100);
}
Decimal baseQuantity = objSalesInvoiceItem.Quantity * 1;
if (conversionUnit.FirstOrDefault().Multiplier > 0)
{
baseQuantity = objSalesInvoiceItem.Quantity * (1 / conversionUnit.FirstOrDefault().Multiplier);
}
Decimal basePrice = amount;
if (baseQuantity > 0)
{
basePrice = amount / baseQuantity;
}
Data.TrnSalesInvoiceItem newPackageSalesInvoiceItem = new Data.TrnSalesInvoiceItem
{
SIId = Convert.ToInt32(SIId),
ItemId = objSalesInvoiceItem.ItemId,
ItemInventoryId = objSalesInvoiceItem.ItemInventoryId,
Particulars = objSalesInvoiceItem.Particulars,
UnitId = objSalesInvoiceItem.UnitId,
Quantity = objSalesInvoiceItem.Quantity,
Price = objSalesInvoiceItem.Price,
DiscountId = objSalesInvoiceItem.DiscountId,
DiscountRate = objSalesInvoiceItem.DiscountRate,
DiscountAmount = discountAmount,
NetPrice = netPrice,
Amount = amount,
VATId = objSalesInvoiceItem.VATId,
VATPercentage = objSalesInvoiceItem.VATPercentage,
VATAmount = VATAmount,
BaseUnitId = item.FirstOrDefault().UnitId,
BaseQuantity = baseQuantity,
BasePrice = basePrice,
SalesItemTimeStamp = DateTime.Now
};
db.TrnSalesInvoiceItems.InsertOnSubmit(newPackageSalesInvoiceItem);
db.SubmitChanges();
var itemComponents = from d in db.MstArticleComponents
where d.ArticleId == objSalesInvoiceItem.ItemId
select new
{
ComponentArticleId = d.ComponentArticleId,
Quantity = d.Quantity,
UnitId = d.MstArticle1.UnitId,
Cost = Convert.ToDecimal(d.MstArticle1.Cost),
Price = d.MstArticle1.Price,
ComponentArticleInventoryId = GetComponentItemArticleInventoryId(d.ComponentArticleId),
Amount = d.Quantity * Convert.ToDecimal(d.MstArticle1.Cost),
Particulars = d.Particulars
};
if (itemComponents.Any())
{
if (item.FirstOrDefault().Kitting == 2)
{
foreach (var itemComponent in itemComponents)
{
var componentItemConversionUnit = from d in db.MstArticleUnits
where d.ArticleId == itemComponent.ComponentArticleId &&
d.UnitId == itemComponent.UnitId &&
d.MstArticle.IsLocked == true
select d;
if (componentItemConversionUnit.Any())
{
Decimal itemComponentDiscountAmount = 0 * (objSalesInvoiceItem.DiscountRate / 100);
Decimal itemComponentNetPrice = 0 - itemComponentDiscountAmount;
if (discounts.FirstOrDefault().IsInclusive)
{
Decimal price = 0 / (1 + (objSalesInvoiceItem.VATPercentage / 100));
itemComponentDiscountAmount = price * (objSalesInvoiceItem.DiscountRate / 100);
itemComponentNetPrice = price - itemComponentDiscountAmount;
}
Decimal itemComponentQuantity = itemComponent.Quantity * objSalesInvoiceItem.Quantity;
Decimal itemComponentAmount = itemComponentNetPrice * itemComponentQuantity;
Decimal itemComponentVATAmount = itemComponentAmount * (objSalesInvoiceItem.VATPercentage / 100);
if (taxTypes.FirstOrDefault().IsInclusive)
{
itemComponentVATAmount = itemComponentAmount / (1 + (objSalesInvoiceItem.VATPercentage / 100)) * (objSalesInvoiceItem.VATPercentage / 100);
}
Decimal componentItemBaseQuantity = itemComponentQuantity * 1;
if (componentItemConversionUnit.FirstOrDefault().Multiplier > 0)
{
componentItemBaseQuantity = itemComponentQuantity * (1 / componentItemConversionUnit.FirstOrDefault().Multiplier);
}
Decimal componentItemBasePrice = itemComponentAmount;
if (baseQuantity > 0)
{
componentItemBasePrice = itemComponentAmount / componentItemBaseQuantity;
}
Data.TrnSalesInvoiceItem newComponentSalesInvoiceItem = new Data.TrnSalesInvoiceItem
{
SIId = Convert.ToInt32(SIId),
ItemId = itemComponent.ComponentArticleId,
ItemInventoryId = itemComponent.ComponentArticleInventoryId,
Particulars = itemComponent.Particulars,
UnitId = itemComponent.UnitId,
Quantity = itemComponentQuantity,
Price = 0,
DiscountId = objSalesInvoiceItem.DiscountId,
DiscountRate = objSalesInvoiceItem.DiscountRate,
DiscountAmount = discountAmount,
NetPrice = itemComponentNetPrice,
Amount = itemComponentAmount,
VATId = objSalesInvoiceItem.VATId,
VATPercentage = objSalesInvoiceItem.VATPercentage,
VATAmount = itemComponentVATAmount,
BaseUnitId = itemComponent.UnitId,
BaseQuantity = componentItemBaseQuantity,
BasePrice = componentItemBasePrice,
SalesItemTimeStamp = DateTime.Now
};
db.TrnSalesInvoiceItems.InsertOnSubmit(newComponentSalesInvoiceItem);
db.SubmitChanges();
}
}
}
}
Decimal salesInvoiceItemTotalAmount = 0;
if (salesInvoice.FirstOrDefault().TrnSalesInvoiceItems.Any())
{
salesInvoiceItemTotalAmount = salesInvoice.FirstOrDefault().TrnSalesInvoiceItems.Sum(d => d.Amount);
}
var updateSalesInvoiceAmount = salesInvoice.FirstOrDefault();
updateSalesInvoiceAmount.Amount = salesInvoiceItemTotalAmount;
db.SubmitChanges();
return(Request.CreateResponse(HttpStatusCode.OK));
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "The selected item has no unit conversion."));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "The selected discount was not found in the server."));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "The selected tax type was not found in the server."));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "The selected item was not found in the server."));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "You cannot add new sales invoice item if the current sales invoice detail is locked."));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound, "These current sales invoice details are not found in the server. Please add new sales invoice first before proceeding."));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "Sorry. You have no rights to add new sales invoice item in this sales invoice detail page."));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "Sorry. You have no access in this sales invoice detail 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(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 HttpResponseMessage insertSalesInvoiceItem(Models.TrnSalesInvoiceItem saleItem)
{
try
{
var articleComponents = from d in db.MstArticleComponents
where d.ArticleId == saleItem.ItemId
select new Models.MstArticleComponent
{
Id = d.Id,
ArticleId = d.ArticleId,
ComponentArticleId = d.ComponentArticleId,
ComponentArticle = d.MstArticle1.Article,
Quantity = d.Quantity,
UnitId = d.MstArticle1.UnitId,
Cost = Convert.ToDecimal(d.MstArticle1.Cost),
Price = d.MstArticle1.Price,
ComponentArticleInventoryId = (from i in db.MstArticleInventories where i.BranchId == currentBranchId() && i.ArticleId == d.ComponentArticleId select i.Id).FirstOrDefault(),
Amount = d.Quantity * Convert.ToDecimal(d.MstArticle1.Cost),
Particulars = d.Particulars
};
if (articleComponents.Any())
{
var kittingItem = (from d in db.MstArticles where d.Id == saleItem.ItemId select d.Kitting).SingleOrDefault();
if (kittingItem == 2)
{
Data.TrnSalesInvoiceItem newSaleInvoiceItemPackage = new Data.TrnSalesInvoiceItem();
newSaleInvoiceItemPackage.SIId = saleItem.SIId;
newSaleInvoiceItemPackage.ItemId = saleItem.ItemId;
newSaleInvoiceItemPackage.ItemInventoryId = saleItem.ItemInventoryId;
newSaleInvoiceItemPackage.Particulars = saleItem.Particulars;
newSaleInvoiceItemPackage.UnitId = saleItem.UnitId;
newSaleInvoiceItemPackage.Quantity = saleItem.Quantity;
newSaleInvoiceItemPackage.Price = saleItem.Price;
newSaleInvoiceItemPackage.DiscountId = saleItem.DiscountId;
newSaleInvoiceItemPackage.DiscountRate = saleItem.DiscountRate;
newSaleInvoiceItemPackage.DiscountAmount = saleItem.DiscountAmount;
newSaleInvoiceItemPackage.NetPrice = saleItem.NetPrice;
newSaleInvoiceItemPackage.Amount = saleItem.Amount;
newSaleInvoiceItemPackage.VATId = saleItem.VATId;
newSaleInvoiceItemPackage.VATPercentage = saleItem.VATPercentage;
newSaleInvoiceItemPackage.VATAmount = saleItem.VATAmount;
var packageItem = from d in db.MstArticles where d.Id == saleItem.ItemId select d;
newSaleInvoiceItemPackage.BaseUnitId = packageItem.First().UnitId;
var packageConversionUnit = from d in db.MstArticleUnits where d.ArticleId == saleItem.ItemId && d.UnitId == saleItem.UnitId select d;
if (packageConversionUnit.First().Multiplier > 0)
{
newSaleInvoiceItemPackage.BaseQuantity = saleItem.Quantity * (1 / packageConversionUnit.First().Multiplier);
}
else
{
newSaleInvoiceItemPackage.BaseQuantity = saleItem.Quantity * 1;
}
var packageBaseQuantity = saleItem.Quantity * (1 / packageConversionUnit.First().Multiplier);
if (packageBaseQuantity > 0)
{
newSaleInvoiceItemPackage.BasePrice = saleItem.Amount / packageBaseQuantity;
}
else
{
newSaleInvoiceItemPackage.BasePrice = saleItem.Amount;
}
newSaleInvoiceItemPackage.SalesItemTimeStamp = DateTime.Now;
db.TrnSalesInvoiceItems.InsertOnSubmit(newSaleInvoiceItemPackage);
db.SubmitChanges();
var packageSalesInvoces = from d in db.TrnSalesInvoices where d.Id == saleItem.SIId select d;
if (packageSalesInvoces.Any())
{
var salesInvoiceItems = from d in db.TrnSalesInvoiceItems where d.SIId == saleItem.SIId select d;
Decimal amount = 0;
if (salesInvoiceItems.Any())
{
amount = salesInvoiceItems.Sum(d => d.Amount + d.VATAmount);
}
var updateSalesInvoice = packageSalesInvoces.FirstOrDefault();
updateSalesInvoice.Amount = amount;
db.SubmitChanges();
}
foreach (var articleComponent in articleComponents)
{
Data.TrnSalesInvoiceItem newSaleInvoiceItem = new Data.TrnSalesInvoiceItem();
var discountIsInclusiveQuery = from d in db.MstDiscounts where d.Id == saleItem.DiscountId select d;
Decimal saleItemDiscountAmount = 0;
Decimal netPrice = 0;
if (discountIsInclusiveQuery.FirstOrDefault().IsInclusive == false)
{
var price = 0 / (1 + (saleItem.VATPercentage / 100));
saleItemDiscountAmount = price * (saleItem.DiscountRate / 100);
var newDiscountAmount = price * (saleItem.DiscountRate / 100);
netPrice = price - newDiscountAmount;
}
else
{
saleItemDiscountAmount = 0 * (saleItem.DiscountRate / 100);
var newDiscountAmount = 0 * (saleItem.DiscountRate / 100);
netPrice = 0 - newDiscountAmount;
}
Decimal quantity = articleComponent.Quantity * saleItem.Quantity;
Decimal amount = quantity * netPrice;
Decimal VATAmount = 0;
var taxTypeTAXIsInclusive = from d in db.MstTaxTypes where d.Id == saleItem.VATId select d;
if (taxTypeTAXIsInclusive.FirstOrDefault().IsInclusive == true)
{
VATAmount = amount / (1 + (saleItem.VATPercentage / 100)) * (saleItem.VATPercentage / 100);
}
else
{
VATAmount = amount * (saleItem.VATPercentage / 100);
}
newSaleInvoiceItem.SIId = saleItem.SIId;
newSaleInvoiceItem.ItemId = articleComponent.ComponentArticleId;
newSaleInvoiceItem.ItemInventoryId = articleComponent.ComponentArticleInventoryId;
newSaleInvoiceItem.Particulars = articleComponent.Particulars;
newSaleInvoiceItem.UnitId = articleComponent.UnitId;
newSaleInvoiceItem.Quantity = articleComponent.Quantity * saleItem.Quantity;
newSaleInvoiceItem.Price = 0;
newSaleInvoiceItem.DiscountId = saleItem.DiscountId;
newSaleInvoiceItem.DiscountRate = saleItem.DiscountRate;
newSaleInvoiceItem.DiscountAmount = saleItemDiscountAmount;
newSaleInvoiceItem.NetPrice = netPrice;
newSaleInvoiceItem.Amount = amount;
newSaleInvoiceItem.VATId = saleItem.VATId;
newSaleInvoiceItem.VATPercentage = saleItem.VATPercentage;
newSaleInvoiceItem.VATAmount = VATAmount;
var item = from d in db.MstArticles where d.Id == articleComponent.ComponentArticleId select d;
newSaleInvoiceItem.BaseUnitId = item.First().UnitId;
var conversionUnit = from d in db.MstArticleUnits where d.ArticleId == articleComponent.ComponentArticleId && d.UnitId == articleComponent.UnitId select d;
if (conversionUnit.Any())
{
if (conversionUnit.First().Multiplier > 0)
{
newSaleInvoiceItem.BaseQuantity = (articleComponent.Quantity * saleItem.Quantity) * (1 / conversionUnit.First().Multiplier);
}
else
{
newSaleInvoiceItem.BaseQuantity = (articleComponent.Quantity * saleItem.Quantity) * 1;
}
var baseQuantity = (articleComponent.Quantity * saleItem.Quantity) * (1 / conversionUnit.First().Multiplier);
if (baseQuantity > 0)
{
newSaleInvoiceItem.BasePrice = amount / baseQuantity;
}
else
{
newSaleInvoiceItem.BasePrice = amount;
}
}
else
{
newSaleInvoiceItem.BaseQuantity = (articleComponent.Quantity * saleItem.Quantity) * 1;
newSaleInvoiceItem.BasePrice = amount;
}
newSaleInvoiceItem.SalesItemTimeStamp = DateTime.Now;
db.TrnSalesInvoiceItems.InsertOnSubmit(newSaleInvoiceItem);
db.SubmitChanges();
var salesInvoces = from d in db.TrnSalesInvoices where d.Id == saleItem.SIId select d;
if (salesInvoces.Any())
{
var salesInvoiceItems = from d in db.TrnSalesInvoiceItems where d.SIId == saleItem.SIId select d;
Decimal salesAmount = 0;
if (salesInvoiceItems.Any())
{
salesAmount = salesInvoiceItems.Sum(d => d.Amount + d.VATAmount);
}
var updateSalesInvoice = salesInvoces.FirstOrDefault();
updateSalesInvoice.Amount = salesAmount;
db.SubmitChanges();
}
}
return(Request.CreateResponse(HttpStatusCode.OK));
}
else
{
Data.TrnSalesInvoiceItem newSaleInvoiceItem = new Data.TrnSalesInvoiceItem();
newSaleInvoiceItem.SIId = saleItem.SIId;
newSaleInvoiceItem.ItemId = saleItem.ItemId;
newSaleInvoiceItem.ItemInventoryId = saleItem.ItemInventoryId;
newSaleInvoiceItem.Particulars = saleItem.Particulars;
newSaleInvoiceItem.UnitId = saleItem.UnitId;
newSaleInvoiceItem.Quantity = saleItem.Quantity;
newSaleInvoiceItem.Price = saleItem.Price;
newSaleInvoiceItem.DiscountId = saleItem.DiscountId;
newSaleInvoiceItem.DiscountRate = saleItem.DiscountRate;
newSaleInvoiceItem.DiscountAmount = saleItem.DiscountAmount;
newSaleInvoiceItem.NetPrice = saleItem.NetPrice;
newSaleInvoiceItem.Amount = saleItem.Amount;
newSaleInvoiceItem.VATId = saleItem.VATId;
newSaleInvoiceItem.VATPercentage = saleItem.VATPercentage;
newSaleInvoiceItem.VATAmount = saleItem.VATAmount;
var item = from d in db.MstArticles
where d.Id == saleItem.ItemId
select d;
newSaleInvoiceItem.BaseUnitId = item.FirstOrDefault().UnitId;
var conversionUnit = from d in db.MstArticleUnits where d.ArticleId == saleItem.ItemId && d.UnitId == saleItem.UnitId select d;
if (conversionUnit.Any())
{
if (conversionUnit.FirstOrDefault().Multiplier > 0)
{
newSaleInvoiceItem.BaseQuantity = saleItem.Quantity * (1 / conversionUnit.FirstOrDefault().Multiplier);
}
else
{
newSaleInvoiceItem.BaseQuantity = saleItem.Quantity * 1;
}
}
else
{
newSaleInvoiceItem.BaseQuantity = saleItem.Quantity * 1;
}
if (conversionUnit.Any())
{
var baseQuantity = saleItem.Quantity * (1 / conversionUnit.FirstOrDefault().Multiplier);
if (baseQuantity > 0)
{
newSaleInvoiceItem.BasePrice = saleItem.Amount / baseQuantity;
}
else
{
newSaleInvoiceItem.BasePrice = saleItem.Amount;
}
}
else
{
newSaleInvoiceItem.BasePrice = saleItem.Amount;
}
newSaleInvoiceItem.SalesItemTimeStamp = DateTime.Now;
db.TrnSalesInvoiceItems.InsertOnSubmit(newSaleInvoiceItem);
db.SubmitChanges();
var salesInvoces = from d in db.TrnSalesInvoices where d.Id == saleItem.SIId select d;
if (salesInvoces.Any())
{
var salesInvoiceItems = from d in db.TrnSalesInvoiceItems where d.SIId == saleItem.SIId select d;
Decimal amount = 0;
if (salesInvoiceItems.Any())
{
amount = salesInvoiceItems.Sum(d => d.Amount + d.VATAmount);
}
var updateSalesInvoice = salesInvoces.FirstOrDefault();
updateSalesInvoice.Amount = amount;
db.SubmitChanges();
}
return(Request.CreateResponse(HttpStatusCode.OK));
}
}
else
{
Data.TrnSalesInvoiceItem newSaleInvoiceItem = new Data.TrnSalesInvoiceItem();
newSaleInvoiceItem.SIId = saleItem.SIId;
newSaleInvoiceItem.ItemId = saleItem.ItemId;
newSaleInvoiceItem.ItemInventoryId = saleItem.ItemInventoryId;
newSaleInvoiceItem.Particulars = saleItem.Particulars;
newSaleInvoiceItem.UnitId = saleItem.UnitId;
newSaleInvoiceItem.Quantity = saleItem.Quantity;
newSaleInvoiceItem.Price = saleItem.Price;
newSaleInvoiceItem.DiscountId = saleItem.DiscountId;
newSaleInvoiceItem.DiscountRate = saleItem.DiscountRate;
newSaleInvoiceItem.DiscountAmount = saleItem.DiscountAmount;
newSaleInvoiceItem.NetPrice = saleItem.NetPrice;
newSaleInvoiceItem.Amount = saleItem.Amount;
newSaleInvoiceItem.VATId = saleItem.VATId;
newSaleInvoiceItem.VATPercentage = saleItem.VATPercentage;
newSaleInvoiceItem.VATAmount = saleItem.VATAmount;
var item = from d in db.MstArticles
where d.Id == saleItem.ItemId
select d;
newSaleInvoiceItem.BaseUnitId = item.FirstOrDefault().UnitId;
var conversionUnit = from d in db.MstArticleUnits where d.ArticleId == saleItem.ItemId && d.UnitId == saleItem.UnitId select d;
if (conversionUnit.Any())
{
if (conversionUnit.FirstOrDefault().Multiplier > 0)
{
newSaleInvoiceItem.BaseQuantity = saleItem.Quantity * (1 / conversionUnit.FirstOrDefault().Multiplier);
}
else
{
newSaleInvoiceItem.BaseQuantity = saleItem.Quantity * 1;
}
}
else
{
newSaleInvoiceItem.BaseQuantity = saleItem.Quantity * 1;
}
if (conversionUnit.Any())
{
var baseQuantity = saleItem.Quantity * (1 / conversionUnit.FirstOrDefault().Multiplier);
if (baseQuantity > 0)
{
newSaleInvoiceItem.BasePrice = saleItem.Amount / baseQuantity;
}
else
{
newSaleInvoiceItem.BasePrice = saleItem.Amount;
}
}
else
{
newSaleInvoiceItem.BasePrice = saleItem.Amount;
}
newSaleInvoiceItem.SalesItemTimeStamp = DateTime.Now;
db.TrnSalesInvoiceItems.InsertOnSubmit(newSaleInvoiceItem);
db.SubmitChanges();
var salesInvoces = from d in db.TrnSalesInvoices where d.Id == saleItem.SIId select d;
if (salesInvoces.Any())
{
var salesInvoiceItems = from d in db.TrnSalesInvoiceItems where d.SIId == saleItem.SIId select d;
Decimal amount = 0;
if (salesInvoiceItems.Any())
{
amount = salesInvoiceItems.Sum(d => d.Amount + d.VATAmount);
}
var updateSalesInvoice = salesInvoces.FirstOrDefault();
updateSalesInvoice.Amount = amount;
db.SubmitChanges();
}
return(Request.CreateResponse(HttpStatusCode.OK));
}
}
catch (Exception e)
{
Debug.WriteLine(e);
return(Request.CreateResponse(HttpStatusCode.BadRequest));
}
}
