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; } }