public List <BusinessObjects.StockReturn_BS> GetAll(string connString) { try { //get_stock_return List <BusinessObjects.StockReturn_BS> CatetList = new List <BusinessObjects.StockReturn_BS>(); string query = "select table_id,prd_id,stock_id,descrip,adjusted,quantity,Date_ from stock_return"; SqlConnection conn = DBHelper.GetConnection(connString); conn.Open(); SqlDataReader reader = DBHelper.ReadData(query, conn); while (reader.Read()) { BusinessObjects.StockReturn_BS pObj = new BusinessObjects.StockReturn_BS(); pObj.table_id = Convert.ToInt32(reader[0].ToString()); pObj.prd_id = Convert.ToInt32(reader[1].ToString()); pObj.stock_id = Convert.ToInt32(reader[2].ToString()); pObj.descrip = reader[3].ToString(); pObj.adjusted = Convert.ToInt32(reader[4].ToString()); pObj.quantity = Convert.ToInt32(reader[5].ToString()); pObj.Date_ = Convert.ToDateTime(reader[6].ToString()); CatetList.Add(pObj); } conn.Close(); return(CatetList); } catch (Exception ex) { throw ex; } }
public List <BusinessObjects.StockReturn_BS> GetAllProcInnjerJoin(string connString) { try { string query = @"exec get_stock_return"; //get_stock_return List <BusinessObjects.StockReturn_BS> CatetList = new List <BusinessObjects.StockReturn_BS>(); SqlConnection conn = DBHelper.GetConnection(connString); conn.Open(); SqlDataReader reader = DBHelper.ReadData(query, conn); while (reader.Read()) { BusinessObjects.StockReturn_BS pObj = new BusinessObjects.StockReturn_BS(); pObj.table_id = Convert.ToInt32(reader[0].ToString()); pObj.prd_id = Convert.ToInt32(reader[1].ToString()); pObj.product_name = reader[2].ToString(); pObj.stock_id = Convert.ToInt32(reader[4].ToString()); pObj.descrip = reader[5].ToString(); pObj.adjusted = Convert.ToInt32(reader[6].ToString()); pObj.quantity = Convert.ToInt32(reader[7].ToString()); pObj.sup_name = reader[8].ToString(); pObj.Date_ = Convert.ToDateTime(reader[9].ToString()); pObj.stock_date = Convert.ToDateTime(reader[10].ToString()); pObj.invoice_no = reader[10].ToString(); CatetList.Add(pObj); } conn.Close(); return(CatetList); ; } catch (Exception ex) { throw ex; } }
void loadData() { try{ List <BusinessObjects.StockReturn_BS> stockReturnList = new List <BusinessObjects.StockReturn_BS>(); BusinessObjects.StockReturn_BS stockReturn = new BusinessObjects.StockReturn_BS(); GlobalStockReturnList = stockReturnList = stockReturn.GetAllProcInnjerJoin(con); tblStockReturn.Rows.Clear(); int i = 0; foreach (BusinessObjects.StockReturn_BS item in stockReturnList) { tblStockReturn.Rows.Add(); tblStockReturn.Rows[i].Cells[0].Value = item.prd_id.ToString(); tblStockReturn.Rows[i].Cells[1].Value = item.product_name; tblStockReturn.Rows[i].Cells[2].Value = item.stock_id.ToString(); tblStockReturn.Rows[i].Cells[3].Value = item.stock_date.ToString(); tblStockReturn.Rows[i].Cells[4].Value = item.sup_name.ToString(); if (item.adjusted == 0) { tblStockReturn.Rows[i].Cells[5].Value = "Stock Return (-)"; } else if (item.adjusted == 1) { tblStockReturn.Rows[i].Cells[5].Value = "Stock Adjusted (+)"; } tblStockReturn.Rows[i].Cells[6].Value = item.quantity.ToString(); tblStockReturn.Rows[i].Cells[7].Value = item.Date_.ToString(); tblStockReturn.Rows[i].Cells[8].Value = "View"; tblStockReturn.Rows[i].Cells[9].Value = item.descrip.ToString(); i++; } } catch (Exception ex) { MetroMessageBox.Show(this, "! System Error . Code 104. " + ex.Message, "System Message", MessageBoxButtons.OK, MessageBoxIcon.Error); } }