public List <BusinessObjects.Stock> GetOneStockByCatID(string connString, int catID)
{
try
{
string query = @"exec dbo.getProdIDByCatID " + catID + " ";
// string query = @"select stock_id,sup_name, s_date,invoice_no from _Stokc where stock_id=" + stock_id + "";
;
SqlConnection conn = DBHelper.GetConnection(connString);
conn.Open();
List <BusinessObjects.Stock> sList = new List <Stock>();
SqlDataReader reader = DBHelper.ReadData(query, conn);
while (reader.Read())
{
BusinessObjects.Stock pObj = new BusinessObjects.Stock();
pObj.stock_id = Convert.ToInt32(reader[0].ToString());
pObj.sup_name = reader[1].ToString();
pObj.s_date = Convert.ToDateTime(reader[2].ToString());
pObj.invoice_no = reader[3].ToString();
pObj.Sup_id = Convert.ToInt32(reader[4].ToString());
sList.Add(pObj);
}
conn.Close();
return(sList);
}
catch (Exception ex)
{
throw ex;
}
}
public List <BusinessObjects.Stock> GetStockListByPIDSalesReturn(string connString, int pids)
{
try
{
List <BusinessObjects.Stock> ProductList = new List <BusinessObjects.Stock>();
//string query = "select stock_id,sup_name, s_date,invoice_no from _Stokc";
string query = @"select stock_id, sup_name, s_date,invoice_no, Sup_id from _Stokc where stock_id in(select distinct(stock_id) from _stock_product where pid=" + pids + ")";
SqlConnection conn = DBHelper.GetConnection(connString);
conn.Open();
SqlDataReader reader = DBHelper.ReadData(query, conn);
while (reader.Read())
{
BusinessObjects.Stock pObj = new BusinessObjects.Stock();
pObj.stock_id = Convert.ToInt32(reader[0].ToString());
pObj.sup_name = reader[1].ToString();
pObj.s_date = Convert.ToDateTime(reader[2].ToString());
pObj.invoice_no = reader[3].ToString();
pObj.Sup_id = Convert.ToInt32(reader[4].ToString());
ProductList.Add(pObj);
}
conn.Close();
return(ProductList);
}
catch (Exception ex)
{
throw ex;
}
}
public BusinessObjects.Stock GetOneStock(string connString)
{
try
{
string query = @"select stock_id,sup_name, s_date,invoice_no, Sup_id from _Stokc where stock_id=" + stock_id + "";
;
SqlConnection conn = DBHelper.GetConnection(connString);
conn.Open();
BusinessObjects.Stock pObj = new BusinessObjects.Stock();
SqlDataReader reader = DBHelper.ReadData(query, conn);
while (reader.Read())
{
pObj.stock_id = Convert.ToInt32(reader[0].ToString());
pObj.sup_name = reader[1].ToString();
pObj.s_date = Convert.ToDateTime(reader[2].ToString());
pObj.invoice_no = reader[3].ToString();
pObj.Sup_id = Convert.ToInt32(reader[4].ToString());
}
conn.Close();
return(pObj);
}
catch (Exception ex)
{
throw ex;
}
}
public List <BusinessObjects.Stock> GetStockList(string connString)
{
try
{
List <BusinessObjects.Stock> ProductList = new List <BusinessObjects.Stock>();
string query = "select stock_id,sup_name, s_date,invoice_no,Sup_id from _Stokc";
SqlConnection conn = DBHelper.GetConnection(connString);
conn.Open();
SqlDataReader reader = DBHelper.ReadData(query, conn);
while (reader.Read())
{
BusinessObjects.Stock pObj = new BusinessObjects.Stock();
pObj.stock_id = Convert.ToInt32(reader[0].ToString());
pObj.sup_name = reader[1].ToString();
pObj.s_date = Convert.ToDateTime(reader[2].ToString());
pObj.invoice_no = reader[3].ToString();
pObj.Sup_id = Convert.ToInt32(reader[4].ToString());
//retreiving relevant stock_product detail based on stock id
BusinessObjects.stock_product sp = new stock_product();
sp.stock_id = pObj.stock_id;
pObj.StockProductList = sp.Get_stock_by_sid(connString);
ProductList.Add(pObj);
}
conn.Close();
return(ProductList);
}
catch (Exception ex)
{
throw ex;
}
}
