private void BuildStoreInventoryList(int year, int storeId, DataTable dtItm)
{
string[] str = { "Item Name", "Batch No.", "Remark" };
foreach (string co in str)
{
dtBB.Columns.Add(co);
}
str = new string[] { "ItemId", "No.", "Beginning Balance", "Ending Balance(SOH)", "Physical Inventory", "ID", "RecID"};//, "Change Since Sene 30" };
foreach (string co in str)
{
dtBB.Columns.Add(co, typeof(int));
}
int count = 1;
var yProcess = new YearEnd();
var bal = new Balance();
dtDate.Value = DateTime.Now;
DateTime dtCurent = new DateTime();
dtDate.CustomFormat = "MM/dd/yyyy";
dtCurent = ConvertDate.DateConverter(dtDate.Text);
var recDoc = new ReceiveDoc();
int month = dtCurent.Month;
//btnSave.Enabled = true;
//CALENDAR:
//if ((dtCurent.Month == 10 && dtCurent.Day == 30) || dtCurent.Month == 11)
//{
// //btnSave.Enabled = ((!yProcess.IsInventoryComplete(year, storeId)));
// btnSave.Enabled =true;
// month = 10;
//}
//else
// btnSave.Enabled = false;
var yEnd = new YearEnd();
foreach (DataRow dr in dtItm.Rows)//For each item
{
string itemName = dr["ItemName"].ToString() + " - " + dr["DosageForm"].ToString() + " - " + dr["Strength"].ToString();
int itemID = Convert.ToInt32(dr["ID"]);
bool BalanceExists = (yProcess.DoesBalanceExist(year, storeId, itemID, false));
//We don't want to display those items whose inventory has already been done.
if (BalanceExists)
continue;
//bereket
//Int64 soh = bal.GetSOH(Convert.ToInt32(dr["ID"]), storeId, month, year);
Int64 soh = bal.GetSOHOptimized(Convert.ToInt32(dr["ID"]), storeId, month, year);
Int64 bbal = yEnd.GetBBalance(year, storeId, Convert.ToInt32(dr["ID"]), month);
yProcess.GetBalanceByItemId(year, storeId, Convert.ToInt32(dr["ID"]));
Int64 BB = (yProcess.RowCount > 0) ? yProcess.BBalance : bbal;
Int64 EB = ((yProcess.RowCount > 0 && yProcess.EBalance != 0) ? yProcess.EBalance : soh);
//Now if the physical inventory is chosen to be default value, we set it to the ending balance of last year.
string Phy = (yProcess.RowCount > 0) ? yProcess.PhysicalInventory.ToString() : (_defaultValueToPhysicalInventory ? EB.ToString() : "");
int id = (yProcess.RowCount > 0) ? yProcess.ID : 0;
string remark = (yProcess.RowCount > 0) ? yProcess.Remark : "";
//object[] obj = {Convert.ToInt32(dr["ID"]),count,itemName,"",BB,((EB != 0)?EB.ToString("#,###"):"0"),Phy,remark,id,-1};
//dtBB.Rows.Add(obj);
DataRowView drv = dtBB.DefaultView.AddNew();
if (yProcess.RowCount > 0)
{
drv["ID"] = yProcess.ID;
}
drv["ItemId"] = dr["ID"];
drv["No."] = count;
drv["Item Name"] = itemName;
drv["Beginning Balance"] = BB;
drv["Ending Balance(SOH)"] = EB;
if (Phy != "")
{
drv["Physical Inventory"] = Phy;
}
drv["RecID"] = -1;
drv["Remark"] = remark;
var ethioDate = new EthiopianDate.EthiopianDate(year, 1, 1);
//drv["Change Since Sene 30"] = BLL.Balance.GetChangeAfterDate(itemID, storeId, ethioDate.EndOfFiscalYear.ToGregorianDate());
count++;
//if (!BalanceExists)
//{
int theLastBalance = 0;
DataTable dtBatchs = recDoc.GetBatchWithValue(storeId, Convert.ToInt32(dr["ID"]), dtCurent);
foreach (DataRow drBatch in dtBatchs.Rows) //For each batch
{
if (drBatch["QuantityLeft"] != DBNull.Value && Convert.ToInt64(drBatch["QuantityLeft"]) != 0)
{
drv = dtBB.DefaultView.AddNew();
drv["Item Name"] = ">>";
drv["Batch No."] = drBatch["BatchNo"];
drv["Ending Balance(SOH)"] = Convert.ToInt64(drBatch["QuantityLeft"]);
//Now if the physical inventory is chosen to be default value, we set it to the ending balance of last year.
if (_defaultValueToPhysicalInventory)
drv["Physical Inventory"] = drBatch["QuantityLeft"].ToString();
theLastBalance += Convert.ToInt32(drBatch["QuantityLeft"]);
drv["RecID"] = drBatch["ID"];
}
}
//}
}
grdYearEnd.DataSource = dtBB;
dtDate.CustomFormat = "MMMM dd, yyyy";
}
public DataTable BalanceAllItems(int storeId, int year, int month, string selectedType)
{
IssueDoc iss = new IssueDoc();
ReceiveDoc rec = new ReceiveDoc();
Disposal dis = new Disposal();
YearEnd yEnd = new YearEnd();
Items itm = new Items();
DataTable dtResult = new DataTable();
string[] col = { "FullItemName", "BBalance", "BBAmount", "ReceivedQty", "ReceivedAmount", "IssuedQty", "IssuedAmount", "LossesQty", "LossesAmount", "AdjustedQty", "AdjustedAmount", "SOH", "SOHAmount", "Received", "ID", "CategoryId", "SubCategoryID" };
int i = 0;
foreach (string s in col)
{
if (i > 0)
{
dtResult.Columns.Add(s, typeof(double));
}
else
{
dtResult.Columns.Add(s);
}
i++;
}
DataTable dtItem = ((selectedType == "Drug") ? itm.GetAllItems(1) : itm.GetAllSupply());
foreach (DataRow dr in dtItem.Rows)
{
string itemName = dr["FullItemName"].ToString();// +" - " + dr["DosageForm"].ToString() + " - " + dr["Strength"].ToString();
int itemId = Convert.ToInt32(dr["ID"]);
Int64 bb = yEnd.GetBBalance(year, storeId, itemId, month);
double bbAmount = yEnd.GetBBalanceAmount(year, storeId, itemId, month);
Int64 recQuant = rec.GetReceivedQuantityTillMonth(itemId, storeId, month, year);
double recPrice = rec.GetReceivedAmountTillMonth(itemId, storeId, month, year);
Int64 issuedQuant = iss.GetIssuedQuantityTillMonth(itemId, storeId, month, year);
double issPrice = iss.GetIssuedAmountTillMonth(itemId, storeId, month, year);
Int64 lossQuant = dis.GetLossesQuantityTillMonth(itemId, storeId, month, year);
double lossAmount = dis.GetLossesAmountTillMonth(itemId, storeId, month, year);
Int64 adjQuant = dis.GetAdjustedQuantityTillMonth(itemId, storeId, month, year);
double adjAmount = dis.GetAdjustedAmountTillMonth(itemId, storeId, month, year);
Int64 SOH = bb + recQuant + adjQuant - issuedQuant - lossQuant;
double SOHAmount = (bbAmount + recPrice + adjAmount - issPrice) - lossAmount;
if (SOHAmount < 0)
{
;
}
int Isrec = ((bb == 0 && recQuant == 0) ? 0 : 1);
object[] obj = { itemName, bb, bbAmount, recQuant, recPrice, issuedQuant, issPrice, lossQuant, lossAmount, adjQuant, adjAmount, SOH, SOHAmount, Isrec, itemId, Convert.ToInt32(dr["CategoryId"]), Convert.ToInt32(dr["SubCategoryID"]) };
dtResult.Rows.Add(obj);
}
return dtResult;
}
/// <summary>
/// Gets SOH of a specific item for the end of the specified Ethipian Fiscal Month Item
/// </summary>
/// <param name="itemId"></param>
/// <param name="storeId"></param>
/// <param name="month"></param>
/// <param name="year"></param>
/// <returns></returns>
public Int64 GetSOHOld(int itemId, int storeId, int month, int year)
{
//ask by normal u get soh on normal month
IssueDoc iss = new IssueDoc();
ReceiveDoc rec = new ReceiveDoc();
Disposal dis = new Disposal();
YearEnd yEnd = new YearEnd();
//int month = (mon > 2) ? mon - 2 : ((mon == 1) ? 11 : 12);
//int year = (mon > 2) ? yr : yr - 1;
Int64 cons = 0;
long recievedQuantity = rec.GetReceivedQuantityTillMonth(itemId, storeId, month, year);
long adjustedQuantity = dis.GetAdjustedQuantityTillMonth(itemId, storeId, month, year);
long issuedQuantity = iss.GetIssuedQuantityTillMonth(itemId, storeId, month, year);
long lossQuantity = dis.GetLossesQuantityTillMonth(itemId, storeId, month, year);
long balanceQuantity = yEnd.GetBBalance(year, storeId, itemId, month);
cons = (balanceQuantity + recievedQuantity + adjustedQuantity - issuedQuantity - lossQuantity);
this.FlushData();
// this.LoadFromRawSql(String.Format("SELECT SUM(QuantityLeft) AS Quantity FROM ReceiveDoc WHERE (ItemID = {0}) AND (StoreID = {1} AND ((Month(Date) <= {2} AND Year(Date) = {3}) OR (Month(Date) > 10 AND Year(Date) = {4})))", itemId, storeId, month, year, year - 1));
// cons = (this.DataTable.Rows[0]["Quantity"].ToString() != "") ? Convert.ToInt64(this.DataTable.Rows[0]["Quantity"]) : 0;
return cons;
}
/// <summary>
/// Generates Past 12 Months charts
/// </summary>
private void GenerateChartsPastMonths()
{
Balance bal = new Balance();
GeneralInfo info = new GeneralInfo();
info.LoadAll();
DataTable dtList = new DataTable();
DataTable dtAmc = new DataTable();
DataTable dtMOS = new DataTable();
DataTable dtIss = new DataTable();
DataTable dtRec = new DataTable();
DataTable dtBB = new DataTable();
//foreach(string s in co)
//{
dtList.Columns.Add("Month");
dtList.Columns.Add("Value");
dtList.Columns[1].DataType = typeof(Int64);
dtMOS.Columns.Add("Month");
dtMOS.Columns.Add("Value");
dtMOS.Columns[1].DataType = typeof(Int32);
dtAmc.Columns.Add("Month");
dtAmc.Columns.Add("Value");
dtAmc.Columns[1].DataType = typeof(Int64);
dtIss.Columns.Add("Month");
dtIss.Columns.Add("Value");
dtIss.Columns[1].DataType = typeof(Int64);
dtRec.Columns.Add("Month");
dtRec.Columns.Add("Value");
dtRec.Columns[1].DataType = typeof(Int64);
dtBB.Columns.Add("Month");
dtBB.Columns.Add("Value");
dtBB.Columns[1].DataType = typeof(Int64);
//dtDate.Value = DateTime.Now;
//dtDate.CustomFormat = "MM/dd/yyyy";
//DateTime dtCurrent = ConvertDate.DateConverter(dtDate.Text);
DateTime dtPast = _dtCurrent.AddMonths(-11);
//CALENDAR:
string[] wer = { "Mes", "Tek", "Hed", "Tah", "Tir", "Yek", "Meg", "Miz", "Gen", "Sen", "Ham", "Neh" };
string[] co = new string[12];
int[] mon = new int[12];
int[] yr = new int[12];
int intialM = dtPast.Month;
int j = 0;
while (dtPast <= _dtCurrent && j < 12)
{
//mon[j] = intialM;
//co[j] = wer[intialM-1];
//yr[j] = (intialM < 11)?dtPast.Year: dtPast.Year +1;
//dtPast = dtPast.AddMonths(1);
//intialM = dtPast.Month;
mon[j] = dtPast.Month;
co[j] = wer[intialM - 1];
yr[j] = dtPast.Year;
dtPast = dtPast.AddMonths(1);
intialM = dtPast.Month;
j++;
}
//{ 11, 12, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10 };
long[] cons = new long[12];
long[] amc = new long[12];
DataTable dtBal = new DataTable();
IssueDoc issd = new IssueDoc();
Items recd = new Items();
YearEnd yEnd = new YearEnd();
Int64 bb = yEnd.GetBBalance(_year, _storeId, _itemId, 10);
object[] objBB = { "Ham", bb };
dtBB.Rows.Add(objBB);
for (int i = 0; i < mon.Length; i++)
{
Int64 con = bal.GetSOH(_itemId, _storeId, mon[i], yr[i]);
object[] str = { co[i], con };
amc[i] = bal.CalculateAMC(_itemId, _storeId, mon[i], yr[i]);
object[] objAmc = { co[i], amc[i] };
decimal mos = (amc[i] > 0) ? (Convert.ToDecimal(con) / Convert.ToDecimal(amc[i])) : 0;
mos = Decimal.Round(mos, 1);
object[] objMos = { co[i], mos };
Int64 issval = issd.GetIssuedQuantityByMonth(_itemId, _storeId, mon[i], yr[i]);
object[] objIss = { co[i], issval };
Int64 recVal = recd.GetQuantityReceiveByItemPerMonth(mon[i], _itemId, _storeId, yr[i]);
object[] objrec = { co[i], recVal };
dtList.Rows.Add(str);
dtAmc.Rows.Add(objAmc);
dtMOS.Rows.Add(objMos);
dtIss.Rows.Add(objIss);
dtRec.Rows.Add(objrec);
//}
}
// string[] str = { ((cons[0] != 0) ? cons[0].ToString("") : "0"), ((cons[1] != 0) ? cons[1].ToString() : "0"), ((cons[2] != 0) ? cons[2].ToString() : "0"), ((cons[3] != 0) ? cons[3].ToString() : "0"), ((cons[4] != 0) ? cons[4].ToString() : "0"), ((cons[5] != 0) ? cons[5].ToString() : "0"), ((cons[6] != 0) ? cons[6].ToString() : "0"), ((cons[7] != 0) ? cons[7].ToString() : "0"), ((cons[8] != 0) ? cons[8].ToString() : "0"), ((cons[9] != 0) ? cons[9].ToString() : "0"), ((cons[10] != 0) ? cons[10].ToString() : "0"), ((cons[11] != 0) ? cons[11].ToString() : "0")};
chartAmc.Series.Clear();
chartComp.Series.Clear();
chartBar.Series.Clear();
chartMOS.Series.Clear();
consuTrend.Series.Clear();
Series ser = new Series("Stock On Hand", ViewType.Line);
ser.DataSource = dtList;
ser.ArgumentScaleType = ScaleType.Qualitative;
ser.ArgumentDataMember = "Month";
ser.ValueScaleType = ScaleType.Numerical;
ser.ValueDataMembers.AddRange(new string[] { "Value" });
chartBar.Series.Add(ser);
Series serB = new Series("Begining Balance", ViewType.Bar);
serB.DataSource = dtBB;
serB.ArgumentScaleType = ScaleType.Qualitative;
serB.ArgumentDataMember = "Month";
serB.ValueScaleType = ScaleType.Numerical;
serB.PointOptions.ValueNumericOptions.Format = NumericFormat.Number;
serB.PointOptions.ValueNumericOptions.Precision = 0;
serB.ValueDataMembers.AddRange(new string[] { "Value" });
chartComp.Series.Add(serB);
Series serRec = new Series("Received Qty", ViewType.Bar);
serRec.DataSource = dtRec;
serRec.ArgumentScaleType = ScaleType.Qualitative;
serRec.ArgumentDataMember = "Month";
serRec.ValueScaleType = ScaleType.Numerical;
serRec.ValueDataMembers.AddRange(new string[] { "Value" });
chartComp.Series.Add(serRec);
Series serAmc = new Series("Average Monthly Consumption", ViewType.Line);
serAmc.DataSource = dtAmc;
serAmc.ArgumentScaleType = ScaleType.Qualitative;
serAmc.ArgumentDataMember = "Month";
serAmc.ValueScaleType = ScaleType.Numerical;
serAmc.ValueDataMembers.AddRange(new string[] { "Value" });
chartAmc.Series.Add(serAmc);
Series serIss = new Series("Issue Qty", ViewType.Bar);
serIss.DataSource = dtIss;
serIss.ArgumentScaleType = ScaleType.Qualitative;
serIss.ArgumentDataMember = "Month";
serIss.ValueScaleType = ScaleType.Numerical;
serIss.ValueDataMembers.AddRange(new string[] { "Value" });
chartComp.Series.Add(serIss);
Series serSOH = new Series("SOH", ViewType.Bar);
serSOH.DataSource = dtList;
serSOH.ArgumentScaleType = ScaleType.Qualitative;
serSOH.ArgumentDataMember = "Month";
serSOH.ValueScaleType = ScaleType.Numerical;
serSOH.ValueDataMembers.AddRange(new string[] { "Value" });
chartComp.Series.Add(serSOH);
Series sercons = new Series("Consumption Trend", ViewType.Line);
sercons.DataSource = dtIss;
sercons.ArgumentScaleType = ScaleType.Qualitative;
sercons.ArgumentDataMember = "Month";
sercons.ValueScaleType = ScaleType.Numerical;
sercons.ValueDataMembers.AddRange(new string[] { "Value" });
consuTrend.Series.Add(sercons);
Series serMos = new Series("Month Of Stock", ViewType.Line);
serMos.DataSource = dtMOS;
serMos.ArgumentScaleType = ScaleType.Qualitative;
serMos.ArgumentDataMember = "Month";
serMos.ValueScaleType = ScaleType.Numerical;
serMos.ValueDataMembers.AddRange(new string[] { "Value" });
chartMOS.Series.Add(serMos);
((XYDiagram)chartMOS.Diagram).AxisY.Range.MaxValue = 12;
Int64 amcCurent = bal.CalculateAMC(_itemId, _storeId, _dtCurrent.Month, _year);
//Int64 soh = bal.GetSOH(itemId,storeId,dtCurrent.Month,year);
//if (bal.RowCount > 0)
//{
Int64 min = info.Min * amcCurent;
Int64 max = info.Max * amcCurent;
ConstantLine target = new ConstantLine();
target.AxisValue = min;
//which min and max to show month
((XYDiagram)chartBar.Diagram).AxisY.ConstantLines.Clear();
target.Visible = true;
target.Title.Text = "Current Min value is " + target.AxisValue.ToString() + " " + lblBUnit.Text;
target.Color = Color.Red;
target.LineStyle.Thickness = 2;
// ((XYDiagram)chartBar.Diagram).AxisY.ConstantLines.Add(target);
ConstantLine targetMax = new ConstantLine();
targetMax.AxisValue = max;
//which min and max to show month
targetMax.Visible = true;
targetMax.Title.Text = "Current Max value is " + targetMax.AxisValue.ToString() + " " + lblBUnit.Text;
targetMax.Color = Color.Blue;
targetMax.LineStyle.Thickness = 2;
//((XYDiagram)chartBar.Diagram).AxisY.ConstantLines.Add(targetMax);
//}
}
/// <summary>
/// Generates the charts one by one.
/// </summary>
/// <param name="du"></param>
private void GenerateCharts(int du)
{
Balance bal = new Balance();
GeneralInfo info = new GeneralInfo();
info.LoadAll();
DataTable dtList = new DataTable();
DataTable dtAmc = new DataTable();
DataTable dtMOS = new DataTable();
DataTable dtIss = new DataTable();
DataTable dtRec = new DataTable();
DataTable dtBB = new DataTable();
//CALENDAR:
// DataTable dtCons = new DataTable();
string[] co = { "Ham", "Neh", "Mes", "Tek", "Hed", "Tah", "Tir", "Yek", "Meg", "Miz", "Gen", "Sen" };
//foreach(string s in co)
//{
dtList.Columns.Add("Month");
dtList.Columns.Add("Value");
dtList.Columns[1].DataType = typeof(Int64);
dtMOS.Columns.Add("Month");
dtMOS.Columns.Add("Value");
dtMOS.Columns[1].DataType = typeof(decimal);
dtAmc.Columns.Add("Month");
dtAmc.Columns.Add("Value");
dtAmc.Columns[1].DataType = typeof(Int64);
dtIss.Columns.Add("Month");
dtIss.Columns.Add("Value");
dtIss.Columns[1].DataType = typeof(Int64);
dtRec.Columns.Add("Month");
dtRec.Columns.Add("Value");
dtRec.Columns[1].DataType = typeof(Int64);
dtBB.Columns.Add("Month");
dtBB.Columns.Add("Value");
dtBB.Columns[1].DataType = typeof(Int64);
int[] mon = { 11, 12, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10 };
long[] cons = new long[12];
double[] amc = new double[12];
long[] con = new long[12];
long[] issval = new long[12];
DataTable dtBal = new DataTable();
IssueDoc issd = new IssueDoc();
Items recd = new Items();
YearEnd yEnd = new YearEnd();
Int64 bb = yEnd.GetBBalance(_year, _storeId, _itemId, 10);
object[] objBB = { "Ham", bb };
dtBB.Rows.Add(objBB);
//dtDate.Value = DateTime.Now;
//dtDate.CustomFormat = "MM/dd/yyyy";
//DateTime dtCurrent = ConvertDate.DateConverter(dtDate.Text);
for (int i = 0; i < mon.Length; i++)
{
int cMonth = _dtCurrent.Month;
//if (!(year == dtCurrent.Year && mon[i] > dtCurrent.Month && mon[i] < 11))
if (((mon[i] == 11 || mon[i] == 12) && (mon[i] <= cMonth || _year == _dtCurrent.Year)) || (mon[i] < 11 && mon[i] <= cMonth && _year == _dtCurrent.Year))
{
int yr = (mon[i] < 11) ? _year : _year - 1;
// dtBal = bal.GetSOH(itemId,storeId,mon[i],yr);
con[i] = ((du == 0) ? bal.GetSOH(_itemId, _storeId, mon[i], yr) : bal.GetDUSOH(_itemId, du, mon[i], yr));
object xSOH = null;
if (con[i] == 0)
{
for (int li = i; li >= 0; li--)
{
if (con[li] != 0)
{
xSOH = 0;
break;
}
}
}
else
xSOH = con[i];
object[] str = { co[i], xSOH };
amc[i] = ((du == 0) ? Builder.CalculateAverageConsumption(_itemId, _storeId, _dtCurrent.Subtract(TimeSpan.FromDays(180)), _dtCurrent, CalculationOptions.Monthly) : bal.CalculateDUAMC(_itemId, du, mon[i], yr, 0));//bal.CalculateAMC(_itemId, _storeId, mon[i], yr)
object xAmc = null;
if (amc[i] == 0)
{
for (int li = i; li >= 0; li--)
{
if (amc[li] != 0)
{
xAmc = 0;
break;
}
}
}
else
xAmc = amc[i];
object[] objAmc = { co[i], xAmc };
// for mos check the diff b/n null and zero
// And also mos = soh/amc right???
decimal mos = (amc[i] > 0) ? (Convert.ToDecimal(con[i]) / Convert.ToDecimal(amc[i])) : 0;
object[] objMos = { co[i], mos };
int fYear = (mon[i] < 11) ? yr : yr - 1;
issval[i] = ((du == 0) ? issd.GetIssuedQuantityByMonth(_itemId, _storeId, mon[i], yr) : issd.GetDUConsumptionByMonth(_itemId, du, mon[i], yr));
object xIss = null;
if (issval[i] == 0)
{
for (int li = i; li >= 0; li--)
{
if (issval[li] != 0)
{
xIss = 0;
break;
}
}
}
else
xIss = issval[i];
object[] objIss = { co[i], xIss };
Int64 recVal = ((du == 0) ? recd.GetQuantityReceiveByItemPerMonth(mon[i], _itemId, _storeId, yr) : issd.GetDUReceiveByMonth(_itemId, du, mon[i], yr));
object[] objrec = { co[i], recVal };
dtList.Rows.Add(str);
dtAmc.Rows.Add(objAmc);
dtMOS.Rows.Add(objMos);
dtIss.Rows.Add(objIss);
dtRec.Rows.Add(objrec);
}
}
// string[] str = { ((cons[0] != 0) ? cons[0].ToString("") : "0"), ((cons[1] != 0) ? cons[1].ToString() : "0"), ((cons[2] != 0) ? cons[2].ToString() : "0"), ((cons[3] != 0) ? cons[3].ToString() : "0"), ((cons[4] != 0) ? cons[4].ToString() : "0"), ((cons[5] != 0) ? cons[5].ToString() : "0"), ((cons[6] != 0) ? cons[6].ToString() : "0"), ((cons[7] != 0) ? cons[7].ToString() : "0"), ((cons[8] != 0) ? cons[8].ToString() : "0"), ((cons[9] != 0) ? cons[9].ToString() : "0"), ((cons[10] != 0) ? cons[10].ToString() : "0"), ((cons[11] != 0) ? cons[11].ToString() : "0")};
chartAmc.Series.Clear(); //AMC
chartComp.Series.Clear();//Activity
chartBar.Series.Clear(); //SOH
chartMOS.Series.Clear(); // MOS
consuTrend.Series.Clear();
Series ser = new Series("Stock On Hand", ViewType.Line);
ser.DataSource = dtList;
ser.ArgumentScaleType = ScaleType.Qualitative;
ser.ArgumentDataMember = "Month";
ser.ValueScaleType = ScaleType.Numerical;
ser.PointOptions.ValueNumericOptions.Format = NumericFormat.Number;
ser.PointOptions.ValueNumericOptions.Precision = 0;
ser.ValueDataMembers.AddRange(new string[] { "Value" });
chartBar.Series.Add(ser);
((XYDiagram)chartBar.Diagram).AxisY.NumericOptions.Format = NumericFormat.Number;
((XYDiagram)chartBar.Diagram).AxisY.NumericOptions.Precision = 0;
Series serB = new Series("Begining Balance", ViewType.Bar);
serB.DataSource = dtBB;
serB.ArgumentScaleType = ScaleType.Qualitative;
serB.ArgumentDataMember = "Month";
serB.ValueScaleType = ScaleType.Numerical;
serB.PointOptions.ValueNumericOptions.Format = NumericFormat.Number;
serB.PointOptions.ValueNumericOptions.Precision = 0;
serB.ValueDataMembers.AddRange(new string[] { "Value" });
chartComp.Series.Add(serB);
Series serRec = new Series("Received Qty", ViewType.Bar);
serRec.DataSource = dtRec;
serRec.ArgumentScaleType = ScaleType.Qualitative;
serRec.ArgumentDataMember = "Month";
serRec.ValueScaleType = ScaleType.Numerical;
serRec.PointOptions.ValueNumericOptions.Format = NumericFormat.Number;
serRec.PointOptions.ValueNumericOptions.Precision = 0;
serRec.ValueDataMembers.AddRange(new string[] { "Value" });
chartComp.Series.Add(serRec);
Series serAmc = new Series("AMC", ViewType.Line);
serAmc.DataSource = dtAmc;
serAmc.ArgumentScaleType = ScaleType.Qualitative;
serAmc.ArgumentDataMember = "Month";
serAmc.ValueScaleType = ScaleType.Numerical;
serAmc.PointOptions.ValueNumericOptions.Format = NumericFormat.Number;
serAmc.PointOptions.ValueNumericOptions.Precision = 0;
serAmc.ValueDataMembers.AddRange(new string[] { "Value" });
chartAmc.Series.Add(serAmc);
((XYDiagram)chartAmc.Diagram).AxisY.NumericOptions.Format = NumericFormat.Number;
((XYDiagram)chartAmc.Diagram).AxisY.NumericOptions.Precision = 0;
Series serIss = new Series("Issue Qty", ViewType.Bar);
serIss.DataSource = dtIss;
serIss.ArgumentScaleType = ScaleType.Qualitative;
serIss.ArgumentDataMember = "Month";
serIss.ValueScaleType = ScaleType.Numerical;
serIss.PointOptions.ValueNumericOptions.Format = NumericFormat.Number;
serIss.PointOptions.ValueNumericOptions.Precision = 0;
serIss.ValueDataMembers.AddRange(new string[] { "Value" });
chartComp.Series.Add(serIss);
//Int64 amcCurent = bal.CalculateAMC(_itemId, _storeId, _dtCurrent.Month, _dtCurrent.Year);
double amcCurent = Builder.CalculateAverageConsumption(_itemId, _storeId,
_dtCurrent.Subtract(TimeSpan.FromDays(180)),
_dtCurrent, CalculationOptions.Monthly);
double min = info.Min * amcCurent;
double max = info.Max * amcCurent;
Int64 nearEOP = Convert.ToInt64(amcCurent * (info.EOP + 0.25));
ConstantLine target = new ConstantLine();
ConstantLine targetEOP = new ConstantLine();
target.AxisValue = min;
//which min and max to show month
((XYDiagram)chartComp.Diagram).AxisY.ConstantLines.Clear();
target.Visible = true;
target.Title.Text = "Current Min value is " + Convert.ToInt64(target.AxisValue).ToString("#,###") + " " + lblBUnit.Text;
target.Color = Color.Red;
target.LineStyle.Thickness = 2;
target.LegendText = "Min";
((XYDiagram)chartComp.Diagram).AxisY.ConstantLines.Add(target);
targetEOP = new ConstantLine();
targetEOP.AxisValue = nearEOP;
//which min and max to show month
//((XYDiagram)chartBar.Diagram).AxisY.ConstantLines.Clear();
targetEOP.Visible = true;
targetEOP.Title.Text = "Current EOP value is " + Convert.ToInt64(targetEOP.AxisValue).ToString("#,###") + " " + lblBUnit.Text;
targetEOP.Color = Color.Yellow;
targetEOP.LineStyle.Thickness = 2;
targetEOP.LegendText = "EOP";
((XYDiagram)chartComp.Diagram).AxisY.ConstantLines.Add(targetEOP);
ConstantLine targetMax = new ConstantLine();
targetMax.AxisValue = max;
//which min and max to show month
targetMax.Visible = true;
targetMax.Title.Text = "Current Max value is " + Convert.ToInt64(targetMax.AxisValue).ToString("#,###") + " " + lblBUnit.Text;
targetMax.Color = Color.Blue;
targetMax.LineStyle.Thickness = 2;
targetMax.LegendText = "Max";
((XYDiagram)chartComp.Diagram).AxisY.ConstantLines.Add(targetMax);
Series sercons = new Series("Consumption", ViewType.Line);
sercons.DataSource = dtIss;
sercons.ArgumentScaleType = ScaleType.Qualitative;
sercons.ArgumentDataMember = "Month";
sercons.ValueScaleType = ScaleType.Numerical;
sercons.PointOptions.ValueNumericOptions.Format = NumericFormat.Number;
sercons.PointOptions.ValueNumericOptions.Precision = 0;
sercons.ValueDataMembers.AddRange(new string[] { "Value" });
consuTrend.Series.Add(sercons);
((XYDiagram)consuTrend.Diagram).AxisY.NumericOptions.Format = NumericFormat.Number;
((XYDiagram)consuTrend.Diagram).AxisY.NumericOptions.Precision = 0;
Series serSOH = new Series("SOH", ViewType.Bar);
serSOH.DataSource = dtList;
serSOH.ArgumentScaleType = ScaleType.Qualitative;
serSOH.ArgumentDataMember = "Month";
serSOH.ValueScaleType = ScaleType.Numerical;
serSOH.PointOptions.ValueNumericOptions.Format = NumericFormat.Number;
((XYDiagram)chartComp.Diagram).AxisY.NumericOptions.Format = NumericFormat.Number;
((XYDiagram)chartComp.Diagram).AxisY.NumericOptions.Precision = 0;
serSOH.PointOptions.ValueNumericOptions.Precision = 0;
serSOH.ValueDataMembers.AddRange(new string[] { "Value" });
chartComp.Series.Add(serSOH);
Series serMos = new Series("Month Of Stock", ViewType.Line);
serMos.DataSource = dtMOS;
serMos.ArgumentScaleType = ScaleType.Qualitative;
serMos.ArgumentDataMember = "Month";
serMos.ValueScaleType = ScaleType.Numerical;
serMos.PointOptions.ValueNumericOptions.Format = NumericFormat.FixedPoint;
serMos.PointOptions.ValueNumericOptions.Precision = 1;
serMos.ValueDataMembers.AddRange(new string[] { "Value" });
chartMOS.Series.Add(serMos);
if (Convert.ToInt32(((XYDiagram)chartMOS.Diagram).AxisY.Range.MaxValue) <= 12)
{
((XYDiagram)chartMOS.Diagram).AxisY.Range.MaxValue = 12;
}
//Int64 soh = bal.GetSOH(itemId,storeId,dtCurrent.Month,year);
//if (bal.RowCount > 0)
//{
//Int64 amcCurent = bal.CalculateAMC(_itemId, _storeId, _dtCurrent.Month, _year);
amcCurent = Builder.CalculateAverageConsumption(_itemId, _storeId,
_dtCurrent.Subtract(TimeSpan.FromDays(180)),
_dtCurrent, CalculationOptions.Monthly);
min = info.Min * amcCurent;
max = info.Max * amcCurent;
nearEOP = Convert.ToInt64(amcCurent * (info.EOP + 0.25));
target = new ConstantLine();
target.AxisValue = min;
//which min and max to show month
((XYDiagram)chartBar.Diagram).AxisY.ConstantLines.Clear();
target.Visible = true;
target.Title.Text = "Current Min value is " + Convert.ToInt64(target.AxisValue).ToString("#,###") + " " + lblBUnit.Text;
target.Color = Color.Red;
target.LineStyle.Thickness = 2;
target.LegendText = "Min";
((XYDiagram)chartBar.Diagram).AxisY.ConstantLines.Add(target);
targetEOP = new ConstantLine();
targetEOP.AxisValue = nearEOP;
//which min and max to show month
//((XYDiagram)chartBar.Diagram).AxisY.ConstantLines.Clear();
targetEOP.Visible = true;
targetEOP.Title.Text = "Current EOP value is " + Convert.ToInt64(targetEOP.AxisValue).ToString("#,###") + " " + lblBUnit.Text;
targetEOP.Color = Color.Yellow;
targetEOP.LineStyle.Thickness = 2;
targetEOP.LegendText = "EOP";
((XYDiagram)chartBar.Diagram).AxisY.ConstantLines.Add(targetEOP);
targetMax = new ConstantLine();
targetMax.AxisValue = max;
//which min and max to show month
targetMax.Visible = true;
targetMax.Title.Text = "Current Max value is " + Convert.ToInt64(targetMax.AxisValue).ToString("#,###") + " " + lblBUnit.Text;
targetMax.Color = Color.Blue;
targetMax.LineStyle.Thickness = 2;
targetMax.LegendText = "Max";
((XYDiagram)chartBar.Diagram).AxisY.ConstantLines.Add(targetMax);
ConstantLine targetMos = new ConstantLine();
ConstantLine targetMosMin = new ConstantLine();
((XYDiagram)chartMOS.Diagram).AxisY.ConstantLines.Clear();
targetMos = new ConstantLine();
targetMos.AxisValue = info.Max;
//which min and max to show month
targetMos.Visible = true;
targetMos.Title.Text = "Current Max is " + info.Max.ToString() + " months";
targetMos.Color = Color.Blue;
targetMos.LineStyle.Thickness = 2;
targetMos.LegendText = "Max";
((XYDiagram)chartMOS.Diagram).AxisY.ConstantLines.Add(targetMos);
targetMosMin = new ConstantLine();
targetMosMin.AxisValue = info.Min;
//which min and max to show month
targetMosMin.Visible = true;
targetMosMin.Title.Text = "Current Min is " + info.Min.ToString() + " months";
targetMosMin.Color = Color.Red;
targetMosMin.LineStyle.Thickness = 2;
targetMosMin.LegendText = "Max";
((XYDiagram)chartMOS.Diagram).AxisY.ConstantLines.Add(targetMosMin);
//}
// Generate the pie Chart for the Current SOH and EXpired Drugs
ReceiveDoc rec = new ReceiveDoc();
chartPie.Series.Clear();
Items itm = new Items();
object[] objExp = itm.GetExpiredQtyAmountItemsByID(_itemId, _storeId);
Int64 expAmount = Convert.ToInt64(objExp[0]);
Double expCost = Convert.ToDouble(objExp[1]);
object[] nearObj = itm.GetNearlyExpiredQtyAmountItemsByID(_itemId, _storeId);
Int64 nearExpAmount = Convert.ToInt64(nearObj[0]);
double nearExpCost = Convert.ToDouble(nearObj[1]);
Int64 soh = bal.GetSOH(_itemId, _storeId, _dtCurrent.Month, _dtCurrent.Year);
double sohPrice = bal.GetSOHAmount(_itemId, _storeId, _dtCurrent.Month, _dtCurrent.Year);
Int64 normal = (soh - nearExpAmount - expAmount);
Int64 nearExpiry = nearExpAmount;
Int64 expired = expAmount;
object[] obj = { normal, nearExpiry, expired };
DataTable dtSOHList = new DataTable();
dtSOHList.Columns.Add("Type");
dtSOHList.Columns.Add("Value");
dtSOHList.Columns[1].DataType = typeof(Int64);
double normalPrice = (sohPrice - nearExpCost - expAmount);
object[] oo = { "Normal : " + normalPrice.ToString("C"), obj[0] };
dtSOHList.Rows.Add(oo);
object[] oo3 = { "Expired : " + expCost.ToString("C"), obj[2] };
dtSOHList.Rows.Add(oo3);
object[] oo2 = { "Near Expiry : " + nearExpCost.ToString("C"), obj[1] };
dtSOHList.Rows.Add(oo2);
Series serExpired = new Series("pie", ViewType.Pie3D);
if (!(Convert.ToInt32(obj[0]) == 0 && Convert.ToInt32(obj[1]) == 0 && Convert.ToInt32(obj[2]) == 0))
{
serExpired.DataSource = dtSOHList;
serExpired.ArgumentScaleType = ScaleType.Qualitative;
serExpired.ArgumentDataMember = "Type";
serExpired.ValueScaleType = ScaleType.Numerical;
serExpired.ValueDataMembers.AddRange(new string[] { "Value" });
serExpired.PointOptions.PointView = PointView.ArgumentAndValues;
serExpired.LegendText = "Key";
serExpired.PointOptions.ValueNumericOptions.Format = NumericFormat.Percent;
serExpired.PointOptions.ValueNumericOptions.Precision = 0;
((PieSeriesLabel)serExpired.Label).Position = PieSeriesLabelPosition.TwoColumns;
// ((PieSeriesLabel)serExpired.Label).ColumnIndent = 2;
((PiePointOptions)serExpired.PointOptions).PointView = PointView.ArgumentAndValues;
// ((PiePointOptions)serExpired.PointOptions).Separator = " , ";
chartPie.Series.Add(serExpired);
chartPie.Size = new System.Drawing.Size(1000, 500);
}
}
/* private void GenerateBinCard()
{
ReceiveDoc rec = new ReceiveDoc();
IssueDoc iss = new IssueDoc();
Disposal dis = new Disposal();
DisposalReasons res = new DisposalReasons();
Balance bal = new Balance();
GeneralInfo info = new GeneralInfo();
YearEnd yEnd = new YearEnd();
Items itm = new Items();
info.LoadAll();
year = Convert.ToInt32(cboYear.SelectedItem);
DataTable dtRec = rec.GetAllTransaction(itemId,storeId,dtCurrent.Month,year);
DataTable dtIss = iss.GetTransactionByItemId(storeId, itemId, year);
DataTable dtDis = dis.GetTransactionByItemId(storeId, itemId, year);
Int64[] cStockout = { 0, 0, 0 };
Int64[] cOverStock = { 0, 0, 0 };
Int64[] cNearStockOut = { 0, 0, 0 };
Int64[] cBelowMin = { 0, 0, 0 };
//DateTime dtThree = dtCurrent.AddMonths(3);
DataTable dtbin = new DataTable();
string[] col = { "Date", "Ref. No", "Receive", "Issue", "Unit Price", "Balance", "Batch No", "Expiry Date","To / From"};
foreach (string str in col)
{
dtbin.Columns.Add(str);
}
int i = 0;
Int64 bBalance = 0;
dtDate.Value = DateTime.Now;
dtDate.CustomFormat = "MM/dd/yyyy";
dtCurrent = ConvertDate.DateConverter(dtDate.Text);
bBalance = yEnd.GetBBalance(year, storeId, itemId,dtCurrent.Month);
Int64 balanceAmount = bBalance;
Int64 mincon = 0;
Int64 maxcon = 0;
double eopcon = 0;
DateTime dtT = new DateTime();
string balanceAm = "";
txtBBalance.Text = bBalance.ToString();
string ddDate = "";
string batNo = "";
foreach (DataRow dvRec in dtRec.Rows)
{
i++;
if (Convert.ToInt32(dvRec["Transact"]) == 1)
{
rec.LoadByPrimaryKey(Convert.ToInt32(dvRec["ID"]));
balanceAmount = balanceAmount + Convert.ToInt64(dvRec["Quantity"]);
balanceAm = (balanceAmount > 0) ? balanceAmount.ToString("#,###") : "0";
itm.LoadByPrimaryKey(rec.ItemID);
if (itm.NeedExpiryBatch)
{
ddDate = rec.ExpDate.ToString("MMM dd,yyyy");
batNo = rec.BatchNo;
}
Supplier sup = new Supplier();
sup.LoadByPrimaryKey(rec.SupplierID);
object[] obj = { Convert.ToDateTime(dvRec["Date"]).ToString("MM dd,yyyy"), dvRec["RefNo"], Convert.ToInt64(dvRec["Quantity"]).ToString("#,###"), "", Convert.ToDouble(dvRec["Cost"]).ToString("C"), balanceAm, batNo, ddDate, sup.CompanyName};
dtbin.Rows.Add(obj);
//For stock Out
dtT = Convert.ToDateTime(dvRec["Date"]);
//int monb = (dtT.Month < 11) ? dtT.Month + 2 : ((dtT.Month == 11) ? 1 : 2);
//int yer = (dtT.Month < 11) ? dtT.Year : dtT.Year - 1;
Int64 bBal = bal.GetSOH(itemId, storeId, dtT.Month, dtT.Year);
Int64 bAmc = bal.CalculateAMC(itemId, storeId, dtT.Month, dtT.Year);
mincon = bAmc * info.Min;
maxcon = bAmc * info.Max;
eopcon = bAmc * info.EOP;
if (balanceAmount == 0)
{
if (Convert.ToDateTime(dvRec["Date"]) <= dtCurrent && Convert.ToDateTime(dvRec["Date"]) >= dtCurrent.Subtract(TimeSpan.FromDays(90)))
{
cStockout[0]++;
}
else if (Convert.ToDateTime(dvRec["Date"]) <= dtCurrent && Convert.ToDateTime(dvRec["Date"]) >= dtCurrent.Subtract(TimeSpan.FromDays(180)))
{
cStockout[1]++;
}
else if (Convert.ToDateTime(dvRec["Date"]) <= dtCurrent && Convert.ToDateTime(dvRec["Date"]) >= dtCurrent.Subtract(TimeSpan.FromDays(360)))
{
cStockout[2]++;
}
}
else if (balanceAmount > maxcon)
{
//For Over stock
if (Convert.ToDateTime(dvRec["Date"]) <= dtCurrent && Convert.ToDateTime(dvRec["Date"]) >= dtCurrent.Subtract(TimeSpan.FromDays(90)))
{
cOverStock[0]++;
}
else if (Convert.ToDateTime(dvRec["Date"]) <= dtCurrent && Convert.ToDateTime(dvRec["Date"]) >= dtCurrent.Subtract(TimeSpan.FromDays(180)))
{
cOverStock[1]++;
}
else if (Convert.ToDateTime(dvRec["Date"]) <= dtCurrent && Convert.ToDateTime(dvRec["Date"]) >= dtCurrent.Subtract(TimeSpan.FromDays(360)))
{
cOverStock[2]++;
}
}//For Below min
else if (balanceAmount > eopcon && balanceAmount <= mincon)
{
if (Convert.ToDateTime(dvRec["Date"]) <= dtCurrent && Convert.ToDateTime(dvRec["Date"]) >= dtCurrent.Subtract(TimeSpan.FromDays(90)))
{
cBelowMin[0]++;
}
else if (Convert.ToDateTime(dvRec["Date"]) <= dtCurrent && Convert.ToDateTime(dvRec["Date"]) >= dtCurrent.Subtract(TimeSpan.FromDays(180)))
{
cBelowMin[1]++;
}
else if (Convert.ToDateTime(dvRec["Date"]) <= dtCurrent && Convert.ToDateTime(dvRec["Date"]) >= dtCurrent.Subtract(TimeSpan.FromDays(360)))
{
cBelowMin[2]++;
}
}
else if (balanceAmount > 0 && balanceAmount < eopcon)
{
if (Convert.ToDateTime(dvRec["Date"]) <= dtCurrent && Convert.ToDateTime(dvRec["Date"]) >= dtCurrent.Subtract(TimeSpan.FromDays(90)))
{
cNearStockOut[0]++;
}
else if (Convert.ToDateTime(dvRec["Date"]) <= dtCurrent && Convert.ToDateTime(dvRec["Date"]) >= dtCurrent.Subtract(TimeSpan.FromDays(180)))
{
cNearStockOut[1]++;
}
else if (Convert.ToDateTime(dvRec["Date"]) <= dtCurrent && Convert.ToDateTime(dvRec["Date"]) >= dtCurrent.Subtract(TimeSpan.FromDays(360)))
{
cNearStockOut[2]++;
}
}
}else if(Convert.ToInt32(dvRec["Transact"]) == 0)
{
//DateTime dteIss = Convert.ToDateTime(drIss["Date"]);
//DateTime dteRec = Convert.ToDateTime(dvRec["Date"]);
//DateTime dTomorow = new DateTime(dtCurrent.Year, dtCurrent.Month, dtCurrent.Day + 1);
//DateTime dteNextRec = (i <= dtRec.Rows.Count - 1) ? Convert.ToDateTime(dtRec.Rows[i]["Date"]) : dTomorow;
iss.LoadByPrimaryKey(Convert.ToInt32(dvRec["ID"]));
try
{
rec.LoadByPrimaryKey(iss.RecievDocID);
}
catch
{
rec.GetTransactionByBatch(itemId, dvRec["BatchNo"].ToString(), storeId);
}
ReceivingUnits recUnit = new ReceivingUnits();
recUnit.LoadByPrimaryKey(iss.ReceivingUnitID);
string issuedTo = recUnit.Name;
balanceAmount = balanceAmount - Convert.ToInt64(dvRec["Quantity"]);
balanceAm = (balanceAmount > 0) ? balanceAmount.ToString("#,###") : "0";
itm.LoadByPrimaryKey(iss.ItemID);
if (itm.NeedExpiryBatch)
{
ddDate = ((rec.RowCount > 0) ? rec.ExpDate.ToString("MMM dd,yyyy") : ""); ;
batNo = dvRec["BatchNo"].ToString(); //rec.BatchNo;
}
else
{
ddDate = "";
batNo = "";
}
object[] obj = { Convert.ToDateTime(dvRec["Date"]).ToString("MM dd,yyyy"), dvRec["RefNo"], "", Convert.ToInt64(dvRec["Quantity"]).ToString("#,###"), Convert.ToDouble(dvRec["Cost"]).ToString("C"), balanceAm,batNo, ddDate,issuedTo};
dtbin.Rows.Add(obj);
//For stock Out
dtT = Convert.ToDateTime(dvRec["Date"]);
//int monb1 = (dtT.Month < 11) ? dtT.Month + 2 : ((dtT.Month == 11) ? 1 : 2);
//int yer1 = (dtT.Month < 11) ? dtT.Year : dtT.Year - 1;
Int64 bBal = bal.GetSOH(itemId, storeId, dtT.Month, dtT.Year);
Int64 bAmc = bal.CalculateAMC(itemId, storeId, dtT.Month, dtT.Year);
mincon = bAmc * info.Min;
maxcon = bAmc * info.Max;
eopcon = bAmc * info.EOP;
if (balanceAmount == 0)
{
if (Convert.ToDateTime(dvRec["Date"]) <= dtCurrent && Convert.ToDateTime(dvRec["Date"]) >= dtCurrent.Subtract(TimeSpan.FromDays(90)))
{
cStockout[0]++;
}
else if (Convert.ToDateTime(dvRec["Date"]) <= dtCurrent && Convert.ToDateTime(dvRec["Date"]) >= dtCurrent.Subtract(TimeSpan.FromDays(180)))
{
cStockout[1]++;
}
else if (Convert.ToDateTime(dvRec["Date"]) <= dtCurrent && Convert.ToDateTime(dvRec["Date"]) >= dtCurrent.Subtract(TimeSpan.FromDays(360)))
{
cStockout[2]++;
}
}
else if (balanceAmount > maxcon)
{
//For Over stock
if (Convert.ToDateTime(dvRec["Date"]) <= dtCurrent && Convert.ToDateTime(dvRec["Date"]) >= dtCurrent.Subtract(TimeSpan.FromDays(90)))
{
cOverStock[0]++;
}
else if (Convert.ToDateTime(dvRec["Date"]) <= dtCurrent && Convert.ToDateTime(dvRec["Date"]) >= dtCurrent.Subtract(TimeSpan.FromDays(180)))
{
cOverStock[1]++;
}
else if (Convert.ToDateTime(dvRec["Date"]) <= dtCurrent && Convert.ToDateTime(dvRec["Date"]) >= dtCurrent.Subtract(TimeSpan.FromDays(360)))
{
cOverStock[2]++;
}
}//For Below min
else if (balanceAmount > eopcon && balanceAmount <= mincon)
{
if (Convert.ToDateTime(dvRec["Date"]) <= dtCurrent && Convert.ToDateTime(dvRec["Date"]) >= dtCurrent.Subtract(TimeSpan.FromDays(90)))
{
cBelowMin[0]++;
}
else if (Convert.ToDateTime(dvRec["Date"]) <= dtCurrent && Convert.ToDateTime(dvRec["Date"]) >= dtCurrent.Subtract(TimeSpan.FromDays(180)))
{
cBelowMin[1]++;
}
else if (Convert.ToDateTime(dvRec["Date"]) <= dtCurrent && Convert.ToDateTime(dvRec["Date"]) >= dtCurrent.Subtract(TimeSpan.FromDays(360)))
{
cBelowMin[2]++;
}
}
else if (balanceAmount > 0 && balanceAmount < eopcon)
{
if (Convert.ToDateTime(dvRec["Date"]) <= dtCurrent && Convert.ToDateTime(dvRec["Date"]) >= dtCurrent.Subtract(TimeSpan.FromDays(90)))
{
cNearStockOut[0]++;
}
else if (Convert.ToDateTime(dvRec["Date"]) <= dtCurrent && Convert.ToDateTime(dvRec["Date"]) >= dtCurrent.Subtract(TimeSpan.FromDays(180)))
{
cNearStockOut[1]++;
}
else if (Convert.ToDateTime(dvRec["Date"]) <= dtCurrent && Convert.ToDateTime(dvRec["Date"]) >= dtCurrent.Subtract(TimeSpan.FromDays(360)))
{
cNearStockOut[2]++;
}
}
}
foreach (DataRow drDis in dtDis.Rows)
{
DateTime dteDis = Convert.ToDateTime(drDis["Date"]);
DateTime dteRec = Convert.ToDateTime(dvRec["Date"]);
res.LoadByPrimaryKey(Convert.ToInt32(drDis["ReasonId"]));
rec.GetTransactionByBatch(itemId,drDis["BatchNo"].ToString(),storeId);
DateTime dteNextRec = (i <= dtRec.Rows.Count - 1) ? Convert.ToDateTime(dtRec.Rows[i]["Date"]) : dtCurrent;
if ((dteRec <= dteDis) && (dteDis < dteNextRec))
{
if (Convert.ToBoolean(drDis["Losses"]))
{
balanceAmount = balanceAmount - Convert.ToInt64(drDis["Quantity"]);
balanceAm = (balanceAmount > 0) ? balanceAmount.ToString("#,###") : "0";
object[] objIss = { Convert.ToDateTime(drDis["Date"]).ToString("MM dd,yyyy"), drDis["RefNo"], "", Convert.ToInt64(drDis["Quantity"]).ToString("#,###"), Convert.ToDouble(drDis["Cost"]).ToString("C"), balanceAm, drDis["BatchNo"], rec.ExpDate.ToString("MMM dd,yyyy"), res.Reason};
dtbin.Rows.Add(objIss);
}
else
{
balanceAmount = balanceAmount + Convert.ToInt64(drDis["Quantity"]);
balanceAm = (balanceAmount > 0) ? balanceAmount.ToString("#,###") : "0";
object[] objIss2 = { Convert.ToDateTime(drDis["Date"]).ToString("MM dd,yyyy"), drDis["RefNo"], Convert.ToInt64(drDis["Quantity"]).ToString("#,###"), "", Convert.ToDouble(drDis["Cost"]).ToString("C"), balanceAm, drDis["BatchNo"], rec.ExpDate.ToString("MMM dd,yyyy"), res.Reason};
dtbin.Rows.Add(objIss2);
}
dtT = Convert.ToDateTime(dvRec["Date"]);
Int64 bAmc = bal.CalculateAMC(itemId, storeId, dtT.Month, dtT.Year);
mincon = bAmc * info.Min;
maxcon = bAmc * info.Max;
eopcon = bAmc * info.EOP;
if (balanceAmount == 0)
{
if (Convert.ToDateTime(dvRec["Date"]) <= dtCurrent && Convert.ToDateTime(dvRec["Date"]) >= dtCurrent.Subtract(TimeSpan.FromDays(90)))
{
cStockout[0]++;
}
else if (Convert.ToDateTime(dvRec["Date"]) <= dtCurrent && Convert.ToDateTime(dvRec["Date"]) >= dtCurrent.Subtract(TimeSpan.FromDays(180)))
{
cStockout[1]++;
}
else if (Convert.ToDateTime(dvRec["Date"]) <= dtCurrent && Convert.ToDateTime(dvRec["Date"]) >= dtCurrent.Subtract(TimeSpan.FromDays(360)))
{
cStockout[2]++;
}
}
else if (balanceAmount > maxcon)
{
//For Over stock
if (Convert.ToDateTime(dvRec["Date"]) <= dtCurrent && Convert.ToDateTime(dvRec["Date"]) >= dtCurrent.Subtract(TimeSpan.FromDays(90)))
{
cOverStock[0]++;
}
else if (Convert.ToDateTime(dvRec["Date"]) <= dtCurrent && Convert.ToDateTime(dvRec["Date"]) >= dtCurrent.Subtract(TimeSpan.FromDays(180)))
{
cOverStock[1]++;
}
else if (Convert.ToDateTime(dvRec["Date"]) <= dtCurrent && Convert.ToDateTime(dvRec["Date"]) >= dtCurrent.Subtract(TimeSpan.FromDays(360)))
{
cOverStock[2]++;
}
}//For Below min
else if (balanceAmount > eopcon && balanceAmount <= mincon)
{
if (Convert.ToDateTime(dvRec["Date"]) <= dtCurrent && Convert.ToDateTime(dvRec["Date"]) >= dtCurrent.Subtract(TimeSpan.FromDays(90)))
{
cBelowMin[0]++;
}
else if (Convert.ToDateTime(dvRec["Date"]) <= dtCurrent && Convert.ToDateTime(dvRec["Date"]) >= dtCurrent.Subtract(TimeSpan.FromDays(180)))
{
cBelowMin[1]++;
}
else if (Convert.ToDateTime(dvRec["Date"]) <= dtCurrent && Convert.ToDateTime(dvRec["Date"]) >= dtCurrent.Subtract(TimeSpan.FromDays(360)))
{
cBelowMin[2]++;
}
}
else if (balanceAmount > 0 && balanceAmount < eopcon)
{
if (Convert.ToDateTime(dvRec["Date"]) <= dtCurrent && Convert.ToDateTime(dvRec["Date"]) >= dtCurrent.Subtract(TimeSpan.FromDays(90)))
{
cNearStockOut[0]++;
}
else if (Convert.ToDateTime(dvRec["Date"]) <= dtCurrent && Convert.ToDateTime(dvRec["Date"]) >= dtCurrent.Subtract(TimeSpan.FromDays(180)))
{
cNearStockOut[1]++;
}
else if (Convert.ToDateTime(dvRec["Date"]) <= dtCurrent && Convert.ToDateTime(dvRec["Date"]) >= dtCurrent.Subtract(TimeSpan.FromDays(360)))
{
cNearStockOut[2]++;
}
}
}
}
}
transactionGrid.DataSource = dtbin;
//Stock Out
lblThreeStockout.Text = cStockout[0].ToString();
lblSixStockOut.Text = (cStockout[0] + cStockout[1]).ToString();
lblTwelveStockOut.Text = (cStockout[0] + cStockout[1] + cStockout[2]).ToString();
//Over Stock
lblThreeOverStock.Text = cOverStock[0].ToString();
lblSixOverStock.Text = (cOverStock[0] + cOverStock[1]).ToString();
lblTwelveOverStock.Text = (cOverStock[0] + cOverStock[1] + cOverStock[2]).ToString();
//Near eop
lblThreeNearStock.Text = cNearStockOut[0].ToString();
lblSixNearStock.Text = (cNearStockOut[0] + cNearStockOut[1]).ToString();
lblTwelveNear.Text = (cNearStockOut[0] + cNearStockOut[1] + cNearStockOut[2]).ToString();
//Below Min
lblThreeBelowMin.Text = cBelowMin[0].ToString();
lblSixBelowMin.Text = (cBelowMin[0] + cBelowMin[1]).ToString();
lblTwelveBelowMin.Text = (cBelowMin[0] + cBelowMin[1] + cBelowMin[2]).ToString();
}
*/
/// <summary>
/// Generates the bin card transaction
/// </summary>
private void GenerateBinCard()
{
#region NewCode
////Get the beginning balance.
//Int64 begBalance = 0;
//YearEnd yearEnd = new YearEnd();
//begBalance = yearEnd.GetBeginningBalance(_storeId, _itemId);
//txtBBalance.Text = begBalance.ToString();
////Get the bin card.
//Balance balance = new Balance();
//gridItemsList.DataSource = balance.GetBinCard(_storeId, _itemId);
//return;
#endregion
#region Old Code
ReceiveDoc rec = new ReceiveDoc();
IssueDoc iss = new IssueDoc();
Disposal dis = new Disposal();
DisposalReasons res = new DisposalReasons();
Balance bal = new Balance();
GeneralInfo info = new GeneralInfo();
YearEnd yEnd = new YearEnd();
Items itm = new Items();
info.LoadAll();
if (cboFiscalYear.SelectedItem == null)
PopulateBinCardYearCombo();
//_year = Convert.ToInt32(cboFiscalYear.SelectedItem);
_year = Convert.ToInt32(cboYear.SelectedItem);
int yer = _year;
//int mth = (_year > _dtCurrent.Year) ? _dtCurrent.Month : 10;
int mth = _dtCurrent.Month;
EthiopianDate.EthiopianDate ethioDate = new EthiopianDate.EthiopianDate(_year, 1, 1);
//if (_dtCurrent.Month < 11)
//{
// yer = _year;
//}
//else
//{
// yer = _year - 1;
//}
//DataTable dtRec = rec.GetAllTransaction(_itemId, _storeId, ethioDate.Month,ethioDate.Year);
DataTable dtRec = rec.GetAllTransaction(_itemId, _storeId, ethioDate.FiscalYear);
DataTable dtIss = iss.GetTransactionByItemId(_storeId, _itemId, ethioDate.FiscalYear);
DataTable dtDis = dis.GetTransactionByItemId(_storeId, _itemId, ethioDate.FiscalYear);
Int64[] cStockout = { 0, 0, 0 };
Int64[] cOverStock = { 0, 0, 0 };
Int64[] cNearStockOut = { 0, 0, 0 };
Int64[] cBelowMin = { 0, 0, 0 };
//DateTime dtThree = dtCurrent.AddMonths(3);
DataTable dtbin = new DataTable();
string[] col = { "Date", "RefNo", "Receive", "Issue", "Unit Price", "Balance", "Batch No", "Expiry Date", "ToFrom" };
foreach (string str in col)
{
dtbin.Columns.Add(str);
}
int i = 0;
Int64 bBalance = 0;
dtDate.Value = DateTime.Now;
dtDate.CustomFormat = "MM/dd/yyyy";
_dtCurrent = ConvertDate.DateConverter(dtDate.Text);
//bBalance = yEnd.GetBBalance(_year, _storeId, _itemId, _dtCurrent.Month);
bBalance = yEnd.GetBBalance(_year, _storeId, _itemId);
Int64 balanceAmount = bBalance;
DateTime dtT = new DateTime();
string balanceAm = "";
string ddDate = "";
string batNo = "";
foreach (DataRow dvRec in dtRec.Rows)
{
i++;
if (Convert.ToInt32(dvRec["Transact"]) == 1)
{
rec.LoadByPrimaryKey(Convert.ToInt32(dvRec["ID"]));
if (dvRec["Quantity"] == DBNull.Value)
{
dvRec["Quantity"] = 0;
}
balanceAmount = balanceAmount + Convert.ToInt64(dvRec["Quantity"]);
balanceAm = (balanceAmount > 0) ? balanceAmount.ToString("#,###") : "0";
itm.LoadByPrimaryKey(rec.ItemID);
if (itm.NeedExpiryBatch)
{
if (!rec.IsColumnNull("ExpDate"))
{
ddDate = rec.ExpDate.ToString("MMM dd,yyyy");
batNo = rec.BatchNo;
}
}
Supplier sup = new Supplier();
sup.LoadByPrimaryKey(rec.SupplierID);
object[] obj = { Convert.ToDateTime(dvRec["Date"]).ToString("MM dd,yyyy"), dvRec["RefNo"], Convert.ToInt64(dvRec["Quantity"]).ToString("#,###"), "", Convert.ToDouble(dvRec["Cost"]).ToString("C"), balanceAm, batNo, ddDate, sup.CompanyName };
dtbin.Rows.Add(obj);
//For stock Out
dtT = Convert.ToDateTime(dvRec["Date"]);
}
else if (Convert.ToInt32(dvRec["Transact"]) == 0)
{
iss.LoadByPrimaryKey(Convert.ToInt32(dvRec["ID"]));
try
{
rec.LoadByPrimaryKey(iss.RecievDocID);
}
catch
{
rec.GetTransactionByBatch(_itemId, dvRec["BatchNo"].ToString(), _storeId);
}
ReceivingUnits recUnit = new ReceivingUnits();
recUnit.LoadByPrimaryKey(iss.ReceivingUnitID);
string issuedTo = recUnit.Name;
balanceAmount = balanceAmount - Convert.ToInt64(dvRec["Quantity"]);
balanceAm = (balanceAmount > 0) ? balanceAmount.ToString("#,###") : "0";
itm.LoadByPrimaryKey(iss.ItemID);
if (itm.NeedExpiryBatch)
{
ddDate = ((rec.RowCount > 0) ? rec.ExpDate.ToString("MMM dd,yyyy") : ""); ;
batNo = dvRec["BatchNo"].ToString(); //rec.BatchNo;
}
else
{
ddDate = "";
batNo = "";
}
object[] obj = { Convert.ToDateTime(dvRec["Date"]).ToString("MM dd,yyyy"), dvRec["RefNo"], "", Convert.ToInt64(dvRec["Quantity"]).ToString("#,###"), Convert.ToDouble(dvRec["Cost"]).ToString("C"), balanceAm, batNo, ddDate, issuedTo };
dtbin.Rows.Add(obj);
//For stock Out
dtT = Convert.ToDateTime(dvRec["Date"]);
}
foreach (DataRow drDis in dtDis.Rows)
{
DateTime dteDis = Convert.ToDateTime(drDis["Date"]);
DateTime dteRec = Convert.ToDateTime(dvRec["Date"]);
res.LoadByPrimaryKey(Convert.ToInt32(drDis["ReasonId"]));
rec.GetTransactionByBatch(_itemId, drDis["BatchNo"].ToString(), _storeId);
DateTime dteNextRec = (i <= dtRec.Rows.Count - 1) ? Convert.ToDateTime(dtRec.Rows[i]["Date"]) : _dtCurrent;
if ((dteRec <= dteDis) && (dteDis < dteNextRec))
{
if (Convert.ToBoolean(drDis["Losses"]))
{
balanceAmount = balanceAmount - Convert.ToInt64(drDis["Quantity"]);
balanceAm = (balanceAmount > 0) ? balanceAmount.ToString("#,###") : "0";
if (rec.RowCount > 0)
{
object[] objIss = { Convert.ToDateTime(drDis["Date"]).ToString("MM dd,yyyy"), drDis["RefNo"], "", Convert.ToInt64(drDis["Quantity"]).ToString("#,###"), Convert.ToDouble(drDis["Cost"]).ToString("C"), balanceAm, drDis["BatchNo"], rec.ExpDate.ToString("MMM dd,yyyy"), res.Reason };
dtbin.Rows.Add(objIss);
}
}
else
{
balanceAmount = balanceAmount + Convert.ToInt64(drDis["Quantity"]);
balanceAm = (balanceAmount > 0) ? balanceAmount.ToString("#,###") : "0";
object[] objIss2 = { Convert.ToDateTime(drDis["Date"]).ToString("MM dd,yyyy"), drDis["RefNo"], Convert.ToInt64(drDis["Quantity"]).ToString("#,###"), "", Convert.ToDouble(drDis["Cost"]).ToString("C"), balanceAm, drDis["BatchNo"], rec.ExpDate.ToString("MMM dd,yyyy"), res.Reason };
dtbin.Rows.Add(objIss2);
}
dtT = Convert.ToDateTime(dvRec["Date"]);
}
}
}
gridItemsList.DataSource = dtbin;
#endregion
}
