public static List <stockreconcolitation> GetStockReconcolitationList()
{
stockreconcolitation stk;
List <stockreconcolitation> StockList = new List <stockreconcolitation>();
try
{
string query = "";
SqlConnection conn = new SqlConnection(Login.connString);
query = "select a.STOCKITEMID,b.Name,a.QUANTITYRECEIPT,a.QUANTITYISSUE,a.PRESENTSTOCK " +
" from ViewStockReconciliationTotal a,StockItem b where a.STOCKITEMID=b.StockItemID " +
//////" and a.StoreLocation='" +Main.MainStore+"'"+
" order by a.STOCKITEMID";
SqlCommand cmd = new SqlCommand(query, conn);
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
stk = new stockreconcolitation();
stk.StockItemID = reader.GetString(0);
stk.StockItemName = reader.GetString(1);
stk.Reciept = reader.IsDBNull(2) ? 0 : reader.GetDouble(2);
stk.Issue = reader.IsDBNull(3) ? 0 : reader.GetDouble(3);
stk.PresentStock = reader.IsDBNull(4) ? 0 : reader.GetDouble(4);
StockList.Add(stk);
}
conn.Close();
}
catch (Exception ex)
{
MessageBox.Show("Error querying Stock Reconcolitation Main");
}
return(StockList);
}
public static List <stockreconcolitation> GetStockReconcolitationDetailList(string stockid)
{
stockreconcolitation stk;
List <stockreconcolitation> StockList = new List <stockreconcolitation>();
try
{
string query = "";
SqlConnection conn = new SqlConnection(Login.connString);
query = "select b.DOCUMENTDATE,b.DOCUMENTID,b.DOCUMENTNO,b.QUANTITYRECEIPT,b.QUANTITYISSUE " +
" from ViewPresentTotalStock a, ViewStockReconciliation b where " +
" a.STOCKITEMID = b.StockItemID and b.STOCKITEMID = '" + stockid + "' " +
" and a.StoreLocation='" + Main.MainStore + "'" +
" order by b.DocumentDate,b.DocumentID";
SqlCommand cmd = new SqlCommand(query, conn);
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
stk = new stockreconcolitation();
stk.DocumentDate = reader.GetDateTime(0);
stk.DocumentID = reader.GetString(1);
stk.DocumentNo = reader.IsDBNull(2) ? 0 : reader.GetInt32(2);
stk.Reciept = reader.IsDBNull(3) ? 0 : reader.GetDouble(3);
stk.Issue = reader.IsDBNull(4) ? 0 : reader.GetDouble(4);
StockList.Add(stk);
}
conn.Close();
}
catch (Exception ex)
{
MessageBox.Show("Error querying Stock Reconcolitation Details");
}
return(StockList);
}