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