public DataTable GetStockData(string strProduct, DateTime fromDate, DateTime toDate)
{
tblStockRegisterTableAdapter adp = new tblStockRegisterTableAdapter();
DataTable dt = adp.GetData(strProduct, fromDate, toDate);
return(dt);
}
public string GetCurrentBalance(string strProductName)
{
tblStockRegisterTableAdapter adp = new tblStockRegisterTableAdapter();
string strCurrentBalance = "";
foreach (var x in adp.GetCurrentBalanceData(strProductName))
{
strCurrentBalance = x.intBalance.ToString();
}
return(strCurrentBalance);
}
public string PutDataStock(List <NewProduct> records)
{
try
{
tblStockTableAdapter adp = new tblStockTableAdapter();
tblStockRegisterTableAdapter adp2 = new tblStockRegisterTableAdapter();
foreach (var x in records)
{
adp.PutStockData(x.strName, x.intQuantity, x.strRemark);
adp2.PutBalanceData(x.strName, x.intQuantity, x.strRemark);
}
return("New Product Is Added Successfully.");
}
catch (Exception e)
{
return("error");
}
}
