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 }