void CreateInventoryReport()
{
var ds = new StockMaster().GetDististinctItemsInStockMaster();
int i = 0;
var bl = new BlItemMaster();
var stk = new StockMaster();
var bls = new SalesManger();
foreach (DataRow stockmasterRow in ds.Rows)
{
var dr = (Ledgers.InventoryVariationRow) dt.NewRow();
dr[0] = i++;
var itm = stockmasterRow["ITEMNO"].ToString();
dr.ITEMNO = itm;
dr.ITEMNAME = bl.GetItemname(itm);
dr.OPENING = bls.GetOpeningQty(itm);
dr.RECEIVE = bls.GetReceivedQty(itm);
dr.RETURN = bls.GetReturnQty(itm);
dr.SALES = bls.GetSoldQty(itm);
dr.TRANSFER = bls.GetTransferedQty(itm);
dr.ADJQTY = bls.GetAdjQty(itm);
dr.ACTUAL = (dr.OPENING + dr.ADJQTY + dr.RECEIVE + (-1* dr.RETURN)) - (dr.SALES + dr.TRANSFER);
dr.INSTOCK = stk.GetAvailableQty(itm);
// dr.STOCKID = int.Parse(stockmasterRow["STOCKID"].ToString());
dt.Rows.Add(dr);
}
inventoryVariationBindingSource.DataSource = dt;
fixstkdiff = false;
}
private void simpleButton4_Click(object sender, EventArgs e)
{
string clnm = string.Empty;
ClsGetData.DelConsolidateinventoryDataTable();
dtcon = ClsGetData.GetConsolidateinventoryDataTable();
cONSOLIDATEINVENTORYBindingSource.DataSource = dtcon;
gridControl1.ResetBindings();
var storecnt = checkedComboBoxEdit1.Properties.GetCheckedItems().ToString().Split(',');
clnm = GetStorenames(storecnt);
SetGridVisibleIndex(storecnt);
//colPRGEN.VisibleIndex = 0;
//colItemname.VisibleIndex = 1;
//colItemno.VisibleIndex = 2;
//colbarcode.VisibleIndex = 3;
//colTOTAL.VisibleIndex = 4;
//colPURQTY.VisibleIndex = 5;
//foreach (var s in storecnt)
//{
// clnm += s + ",";
// gridView1.Columns[i+4].VisibleIndex = i;
// gridView1.Columns[i+4].Visible = true;
// gridView1.Columns[i+4].Caption = s;
// i++;
//}
var i = 0;
DsReports.ITEMLISTFORCONSOLIDATEINVDataTable dsitems = null;
if (lookUpEdit2.EditValue == null && txtbarcode.EditValue == null && LookupSupplier.EditValue ==null)
{
dsitems = ClsGetData.ItemListForConsolidateInv(0,string.Empty);
}
if (comboBoxEdit1.SelectedIndex == 0 && lookUpEdit2.EditValue!=null)
{
dsitems = ClsGetData.ItemListForConsolidateInv(1,lookUpEdit2.EditValue.ToString());
}
if (comboBoxEdit1.SelectedIndex == 1 && txtbarcode.EditValue != null)
{
dsitems = ClsGetData.ItemListForConsolidateInv(2, txtbarcode.Text);
}
if (comboBoxEdit1.SelectedIndex == 2 && LookupSupplier.EditValue != null)
{
dsitems = ClsGetData.ItemListForConsolidateInv(3, txtbarcode.Text);
}
repositoryItemProgressBar1.Maximum = dsitems.Count;
int k = 1;
var connew = Utils.Connectionstring.Split(';');
var bl = new StockMaster();
if (dsitems != null)
foreach (DsReports.ITEMLISTFORCONSOLIDATEINVRow d in dsitems.Rows)
{
progressBar1.EditValue = k;
Application.DoEvents();
k++;
i = 10;
var dr =(DsReports.CONSOLIDATEINVENTORYRow) dtcon.NewRow();
if(!d.IsSUPPLIERNAMENull())
dr.Suppliername = d.SUPPLIERNAME;
else
{
dr.Suppliername = "---";
}
dr.Itemname = d.ITEMNAME;
dr.Itemno = d.ITEMNO;
dr.ItemCategory = d.GROUPNAME;
dr.barcode = d.BARCODE;
dr.PURQTY = 0;
dr.RUNDATE = DateTime.Now.Date;
dr.PRGEN = false;
dr.COLNAMES = clnm;
var toqty = 0;
foreach (string ss in storecnt)
{
var str = connew[0] + ";" + "Initial Catalog =" + ss + ";" + connew[2] + ";" + connew[3] + ";" + connew[4] + ";";
var qty = bl.GetAvailableQty(d.ITEMNO, str, true);
toqty += qty;
dr[i] = qty;
dr.TOTAL = toqty;
i++;
}
dtcon.Rows.Add(dr);
}
cONSOLIDATEINVENTORYBindingSource.DataSource = dtcon;
// COMMON.ClsGetData.SaveCosolidateInventoryRun(dtcon);
}
public static int CheckStockAvailable(int stockid)
{
var cls = new StockMaster();
return cls.GetAvailableQty(stockid);
}
