public List <Models.MViewModels.MViewTransactions> GetAll()
{
List <Models.MViewModels.MViewTransactions> Transactions = new List <Models.MViewModels.MViewTransactions>();
List <Models.MSaleTransactions> AllTransactions = new List <Models.MSaleTransactions>();
Models.MViewModels.MViewTransactions mvv = new Models.MViewModels.MViewTransactions();
Classes.CProducts cp = new CProducts();
Classes.CSaleTransations cst = new CSaleTransations();
Classes.CWareHouse cw = new CWareHouse();
AllTransactions = cst.GetAll();
AllTransactions = (from o in AllTransactions select o).OrderBy(o => o.date).ToList();
for (int i = 0; i < AllTransactions.Count; i++)
{
mvv = new Models.MViewModels.MViewTransactions();
string ProductId = AllTransactions[i].ProductID;
string ProductName = cp.GetProductNameWithTagsById(Convert.ToInt32(ProductId));
string WareHouseId = AllTransactions[i].WareHouseId;
string WareHouseName = cw.GetWareHouseNameById(Convert.ToInt32(WareHouseId));
mvv.TransactionId = AllTransactions[i].id.ToString();
mvv.Date = AllTransactions[i].date.ToShortDateString();
mvv.Product = ProductName;
mvv.Type = AllTransactions[i].transactionType;
mvv.Units = AllTransactions[i].units;
mvv.WareHouse = WareHouseName;
mvv.OrderId = AllTransactions[i].OrderId;
mvv.WareHouseId = WareHouseId;
Transactions.Add(mvv);
}
return(Transactions);
}
public List <Models.MInventoryBalance> GetInventoryBalance(DateTime fromDate, DateTime toDate)
{
List <Models.MInventoryBalance> Data = new List <Models.MInventoryBalance>();
var query = from o in obj.InventoryBalances
where o.Date >= fromDate && o.Date <= toDate
select o;
Classes.CProducts cp = new CProducts();
Classes.CWareHouse cw = new CWareHouse();
foreach (var item in query)
{
Models.MInventoryBalance mib = new Models.MInventoryBalance();
string ProductName = string.Empty;
string WarehouseName = string.Empty;
ProductName = cp.GetProductNameWithTagsById(Convert.ToInt32(item.ProductsId));
mib.WareHouseId = Convert.ToInt32(item.WarehouseId.ToString());
WarehouseName = cw.GetWareHouseNameById(Convert.ToInt32(item.WarehouseId));
mib.BalanceTotal = item.BalanceTotal;
mib.BalanceUnits = item.BalanceUnits;
mib.BalanceUnitsCost = item.BalanceUnitsCost;
mib.date = Convert.ToDateTime(item.Date);
mib.ProductName = ProductName;
mib.PurchaseTotal = item.PurchaseTotal;
mib.PurchaseUnits = item.PurchaseUnits;
mib.PurchaseUnitsCost = item.PurchaseUnitsCost;
mib.SaleTotal = item.SaleTotal;
mib.SaleUnits = item.SaleUnits;
mib.SaleUnitsCost = item.SaleUnitsCost;
mib.WareHouseName = WarehouseName;
Data.Add(mib);
}
return(Data);
}
public List <Models.MInventory> GetInventoryData()
{
List <Models.MInventory> Data = new List <Models.MInventory>();
var query = from o in obj.Inventories orderby o.WareHouseId ascending select o;
if (query != null)
{
foreach (var item in query)
{
Models.MInventory mi = new Models.MInventory();
string Get = string.Empty;
string WareHouseName = string.Empty;
Classes.CProducts cp = new CProducts();
Classes.CWareHouse cw = new CWareHouse();
Get = cp.GetProductNameWithTagsById(Convert.ToInt32(item.ProductId));
WareHouseName = cw.GetWareHouseNameById(Convert.ToInt32(item.WareHouseId));
string[] ProductDetails = Get.Split('-');
mi.ProductCode = ProductDetails[0];
mi.ProductName = ProductDetails[1];
mi.ProducyTag1 = ProductDetails[2];
mi.ProductTag2 = ProductDetails[3];
mi.ProductId = item.ProductId.ToString();
mi.WareHouseld = item.WareHouseId.ToString();
mi.WareHouseName = WareHouseName;
mi.Cost = item.Cost;
mi.Quantity = item.Quantity;
mi.TotalCost = Convert.ToSingle(Convert.ToSingle(item.Cost) * Convert.ToSingle(item.Quantity));
Data.Add(mi);
}
}
return(Data);
}
public List <Models.MViewModels.MViewCashInHand> GetAll(int fiscalYeadId)
{
List <Models.MViewModels.MViewCashInHand> Get = new List <Models.MViewModels.MViewCashInHand>();
Models.MViewModels.MViewCashInHand mvm = new Models.MViewModels.MViewCashInHand();
Classes.CInventory ci = new CInventory();
Classes.CWareHouse cw = new CWareHouse();
List <Models.MInventory> Inventory = new List <Models.MInventory>();
Inventory = ci.GetAll();
Inventory = (from o in Inventory
where Convert.ToInt32(o.FiscalYearld) == fiscalYeadId
select o).ToList();
for (int i = 0; i < Inventory.Count; i++)
{
string ProductName;
string ProductCode;
string ProductTag1;
string ProductTag2;
string Units;
string PerUnitCost;
string Total;
string WareHouseName;
Classes.CProducts cp = new CProducts();
int ProductId = 0;
ProductId = Convert.ToInt32(Inventory[i].ProductId);
List <Models.MProducts> Products = new List <Models.MProducts>();
Products = cp.GetAllbyid(ProductId);
if (Products.Count() != 0)
{
mvm = new Models.MViewModels.MViewCashInHand();
int WareHouseId = 0;
WareHouseId = Convert.ToInt32(Inventory[i].WareHouseld);
WareHouseName = cw.GetWareHouseNameById(WareHouseId);
ProductName = Products[0].Name;
ProductCode = Products[0].ProductCode;
ProductTag1 = Products[0].tag1;
ProductTag2 = Products[0].tag2;
Units = Inventory[i].Quantity.ToString();
PerUnitCost = Inventory[i].Cost;
Total = (Convert.ToSingle(Units) * Convert.ToSingle(PerUnitCost)).ToString();
//object
mvm.PerUnitCost = PerUnitCost;
mvm.ProductCode = ProductCode;
mvm.ProductName = ProductName;
mvm.ProductTag1 = ProductTag1;
mvm.ProductTag2 = ProductTag2;
mvm.Total = Total;
mvm.Units = Units;
mvm.WareHouseName = WareHouseName;
Get.Add(mvm);
}
}
return(Get);
}
public string GetWareHouseIdByUserId(string UserId)
{
string WareHouseName = string.Empty;
var query = (from o in obj.UserWareHouseContainers
where
o.UserId == Convert.ToInt32(UserId)
select o.WareHouseId).FirstOrDefault();
if (query == null)
{
WareHouseName = "No WareHouse Associated";
}
else
{
CWareHouse cw = new CWareHouse();
WareHouseName = query.ToString();
}
return(WareHouseName);
}
public List <Models.MViewModels.MItemProfatibilityReport> GetAll(DateTime fromDate, DateTime toDate)
{
#region Class Objects
Classes.CSaleTransations ct = new CSaleTransations();
Classes.CWareHouse cw = new CWareHouse();
Classes.CProducts cp = new CProducts();
#endregion
#region Models
Models.MSaleTransactions mt = new Models.MSaleTransactions();
Models.MViewModels.MItemProfatibilityReport mii = new Models.MViewModels.MItemProfatibilityReport();
#endregion
#region Lists
List <Models.MViewModels.MItemProfatibilityReport> ItemProfatiblity = new List <Models.MViewModels.MItemProfatibilityReport>();
List <Models.MSaleTransactions> Transactions = new List <Models.MSaleTransactions>();
List <string> Products = new List <string>();
#endregion
#region Logic
float totalUnits = 0;
Transactions = ct.GetAll();
//filtering for only deductions
Transactions = (from o in Transactions
where o.transactionType == Common.Constants.SaleTransactions.Deduction.ToString() &&
Convert.ToDateTime(o.date) >= fromDate && Convert.ToDateTime(o.date) <= toDate
select o).ToList();
totalUnits = (from o in Transactions select Convert.ToSingle(o.units)).Sum();
Products = (from o in Transactions select o.ProductID).Distinct().ToList();
for (int i = 0; i < Products.Count; i++)
{
mii = new Models.MViewModels.MItemProfatibilityReport();
List <Models.MSaleTransactions> ProductWise = new List <Models.MSaleTransactions>();
ProductWise = (from o in Transactions where o.ProductID == Products[i] select o).ToList();
string ProductName = cp.GetProductNameWithTagsById(Convert.ToInt32(Products[i]));
float CostPrice = (from a in ProductWise
where a.ProductID == Products[i]
select Convert.ToSingle(a.CostPrice)).Sum();
float Revenue = (from a in ProductWise
where a.ProductID == Products[i]
select Convert.ToSingle(a.SalePrice)).Sum();
float units = (from a in ProductWise
where a.ProductID == Products[i]
select Convert.ToSingle(a.units)).Sum();
CostPrice = CostPrice * units;
Revenue = Revenue * units;
float Difference = Revenue - CostPrice;
float totalCost = Transactions.Select(o => Convert.ToSingle(o.units)).Sum();
float Percentage = (units / totalUnits) * 100;
mii.Inventory = ProductName;
mii.WareHouse = "Remaining";
mii.ActualCost = CostPrice.ToString();
mii.ActualRevenue = Revenue.ToString();
mii.Diff = Difference.ToString();
mii.UnitsSold = units.ToString();
mii.Percent = Percentage.ToString() + "%";
ItemProfatiblity.Add(mii);
}
#endregion
return(ItemProfatiblity);
}
