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