public BusinessObjects.Purchase GetPurchaseAndPProdBySID(string connString, int StokcID)
{
try
{
string query = "select stock_id,sup_name, s_date,invoice_no from Purchase where stock_id=" + StokcID + "";
SqlConnection conn = DBHelper.GetConnection(connString);
conn.Open();
BusinessObjects.Purchase pObj = new BusinessObjects.Purchase();
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.grandTotal = getGrandTotal(pObj.stock_id, connString);
pObj.grandTotal = getGrandTotal_New(pObj.stock_id, connString);
//retreiving relevant stock_product detail based on stock id
BusinessObjects.purchase_product sp = new purchase_product();
sp.stock_id = pObj.stock_id;
pObj.StockProductList = sp.Get_stock_by_sid(connString);
}
conn.Close();
return(pObj);
}
catch (Exception ex)
{
throw ex;
}
}
public BusinessObjects.Purchase GetPurchaseByStockID(string connString, int StokcID)
{
try
{
string query = "select stock_id,sup_name, s_date,invoice_no from Purchase where stock_id=" + StokcID + "";
SqlConnection conn = DBHelper.GetConnection(connString);
conn.Open();
BusinessObjects.Purchase pObj = new BusinessObjects.Purchase();
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.grandTotal = getGrandTotal(pObj.stock_id, connString);
pObj.grandTotal = getGrandTotal_New(pObj.stock_id, connString);
}
conn.Close();
return(pObj);
}
catch (Exception ex)
{
throw ex;
}
}
public List <BusinessObjects.Purchase> GetPurchaseByPname(string connString, string pName)
{
try
{
string query = @"exec dbo.getPurchaseByProdName '" + pName + "' ";
// 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.Purchase> sList = new List <Purchase>();
SqlDataReader reader = DBHelper.ReadData(query, conn);
while (reader.Read())
{
BusinessObjects.Purchase pObj = new BusinessObjects.Purchase();
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.grandTotal = getGrandTotal_New(pObj.stock_id, connString);
sList.Add(pObj);
}
conn.Close();
return(sList);
}
catch (Exception ex)
{
throw ex;
}
}
