public IActionResult DeliveredOrder(int orderID)
{
Order deliveredOrder = Context.Order.Find(orderID);
IncomeVM incomeVM = new IncomeVM(Context);
deliveredOrder.Status = true;
Context.SaveChanges();
// add company income :
CompanyIncome companyIncome = Context.CompanyIncome.FirstOrDefault(i => i.DateFrom.Month == deliveredOrder.Date.Month && i.DateFrom.Year == deliveredOrder.Date.Year);
if (companyIncome != null)
{
companyIncome.Income += deliveredOrder.TotalPrice;
companyIncome.DelivarymenCost += deliveredOrder.DelivarymanCost;
companyIncome.Profit = companyIncome.Income - companyIncome.DelivarymenCost;
Context.SaveChanges();
}
else
{
incomeVM.AddCompanyIncome(deliveredOrder.Date);
}
return(RedirectToAction("GetNotDeliveredOrders"));
}
internal CompanyDetail GetCompanies(int id)
{
var parameters = new List <SqlParameter>();
parameters.Add(new SqlParameter("@companyId", SqlDbType.Int)
{
Value = id
});
var dataSet = dbHelper.SelectDataSet("spCompanyDetails_Get", parameters.ToArray());
var companyDetails = new CompanyDetail();
var incomeInfo = new List <CompanyIncome>();
foreach (DataRow dataRow in dataSet.Tables[0].Rows)
{
var info = new CompanyIncome();
info.Id = dataRow["id"] == DBNull.Value ? 1 : Convert.ToInt32(dataRow["id"]);
info.RowHeader = dataRow["RowHeader"] == DBNull.Value ? "" : Convert.ToString(dataRow["RowHeader"]);
info.ValueCell1 = dataRow["valueCell1"] == DBNull.Value ? "" : Convert.ToString(dataRow["valueCell1"]);
info.ValueCell2 = dataRow["valueCell2"] == DBNull.Value ? "" : Convert.ToString(dataRow["valueCell2"]);
info.ValueCell3 = dataRow["valueCell3"] == DBNull.Value ? "" : Convert.ToString(dataRow["valueCell3"]);
info.ValueCell4 = dataRow["valueCell4"] == DBNull.Value ? "" : Convert.ToString(dataRow["valueCell4"]);
info.ValueCell5 = dataRow["valueCell5"] == DBNull.Value ? "" : Convert.ToString(dataRow["valueCell5"]);
info.IsHeaderRow = dataRow["isHeaderRow"] == DBNull.Value ? 1 : Convert.ToInt32(dataRow["isHeaderRow"]);
info.SheetName = dataRow["sheetName"] == DBNull.Value ? "" : Convert.ToString(dataRow["sheetName"]);
info.CompanyId = dataRow["companyId"] == DBNull.Value ? 0 : Convert.ToInt32(dataRow["companyId"]);
incomeInfo.Add(info);
}
companyDetails.CompanyIncomeInfo = incomeInfo;
var segmentInfo = new List <CompanySegment>();
foreach (DataRow dataRow in dataSet.Tables[0].Rows)
{
var info = new CompanySegment();
info.Id = dataRow["id"] == DBNull.Value ? 1 : Convert.ToInt32(dataRow["id"]);
info.RowHeader = dataRow["RowHeader"] == DBNull.Value ? "" : Convert.ToString(dataRow["RowHeader"]);
info.ValueCell1 = dataRow["valueCell1"] == DBNull.Value ? "" : Convert.ToString(dataRow["valueCell1"]);
info.ValueCell2 = dataRow["valueCell2"] == DBNull.Value ? "" : Convert.ToString(dataRow["valueCell2"]);
info.ValueCell3 = dataRow["valueCell3"] == DBNull.Value ? "" : Convert.ToString(dataRow["valueCell3"]);
info.ValueCell4 = dataRow["valueCell4"] == DBNull.Value ? "" : Convert.ToString(dataRow["valueCell4"]);
info.ValueCell5 = dataRow["valueCell5"] == DBNull.Value ? "" : Convert.ToString(dataRow["valueCell5"]);
info.IsHeaderRow = dataRow["isHeaderRow"] == DBNull.Value ? 1 : Convert.ToInt32(dataRow["isHeaderRow"]);
info.SheetName = dataRow["sheetName"] == DBNull.Value ? "" : Convert.ToString(dataRow["sheetName"]);
info.CompanyId = dataRow["companyId"] == DBNull.Value ? 0 : Convert.ToInt32(dataRow["companyId"]);
segmentInfo.Add(info);
}
companyDetails.CompanySegments = segmentInfo;
return(companyDetails);
}
public void SaveCompanyIncome(CompanyIncome companyIncome)
{
var parameters = new List <SqlParameter>();
parameters.Add(new SqlParameter("@rowHeader", SqlDbType.NVarChar)
{
Value = companyIncome.RowHeader
});
parameters.Add(new SqlParameter("@valueCell1", SqlDbType.NVarChar)
{
Value = companyIncome.ValueCell1 ?? ""
});
parameters.Add(new SqlParameter("@valueCell2", SqlDbType.NVarChar)
{
Value = companyIncome.ValueCell2 ?? ""
});
parameters.Add(new SqlParameter("@valueCell3", SqlDbType.NVarChar)
{
Value = companyIncome.ValueCell3 ?? ""
});
parameters.Add(new SqlParameter("@valueCell4", SqlDbType.NVarChar)
{
Value = companyIncome.ValueCell4 ?? ""
});
parameters.Add(new SqlParameter("@valueCell5", SqlDbType.NVarChar)
{
Value = companyIncome.ValueCell5 ?? ""
});
parameters.Add(new SqlParameter("@isHeaderRow", SqlDbType.Int)
{
Value = companyIncome.IsHeaderRow
});
parameters.Add(new SqlParameter("@sheetName", SqlDbType.NVarChar)
{
Value = companyIncome.SheetName
});
parameters.Add(new SqlParameter("@companyId", SqlDbType.Int)
{
Value = companyIncome.CompanyId
});
dbHelper.ExecuteNonQuery("spCompanyIncome_Save", parameters.ToArray());
}
// ---------------------------------------------------------------------------
// Calculate Company Income :
public void AddCompanyIncome(DateTime dateFrom)
{
List <Order> monthOrders = Context.Order.Where(o => o.Date.Month == dateFrom.Month && o.Date.Year == dateFrom.Year).ToList();
CompanyIncome companyIncome = new CompanyIncome()
{
DateFrom = dateFrom,
DateTo = dateFrom.AddMonths(1),
Income = 0,
DelivarymenCost = 0,
Profit = 0
};
foreach (var order in monthOrders)
{
companyIncome.Income += order.TotalPrice;
companyIncome.DelivarymenCost += order.DelivarymanCost;
}
companyIncome.Profit = companyIncome.Income - companyIncome.DelivarymenCost;
Context.CompanyIncome.Add(companyIncome);
Context.SaveChanges();
}
