public DataSet StockLedgerReport() { object[,] Parameters = new object[, ] { { "@date", AsonDate }, { "@ProductID", ProductID } }; DataSet ds = new DataSet(); General.DBActions db = new General.DBActions(); ds = db.ExecuteQuery("SelecStockLedgerReport", Parameters); return(ds); }
public DataSet ItemWiserReport() { object[,] Parameters = new object[, ] { { "@fromdate", fromdate }, { "@todate", todate }, { "@TransactionType", TransactionType } }; DataSet ds = new DataSet(); General.DBActions db = new General.DBActions(); ds = db.ExecuteQuery("ItemWiseStockReport", Parameters); return(ds); }
public DataSet LoadVoucherNo() { object[,] Parameters = new object[, ] { { "@TransactionType", TransactionType } }; DataSet ds = new DataSet(); DBActions db = new General.DBActions(); ds = db.ExecuteQuery("GetMaxofLastVoucherNo", Parameters); return(ds); }
public DataSet LoadProductList() { object[,] Parameters = new object[, ] { { "@ProductName", ProductName } }; DataSet ds = new DataSet(); DBActions db = new General.DBActions(); ds = db.ExecuteQuery("LoadProducListonGridView", Parameters); return(ds); }
public DataSet SelectTransRegisterReport() { object[,] Parameters = new object[, ] { { "@fromdate", fromdate }, { "@todate", todate }, { "@TransactionType", TransactionType }, { "@ProductGroupID", ProductGroupID }, { "@ProductID", ProductID } }; DataSet ds = new DataSet(); General.DBActions db = new General.DBActions(); ds = db.ExecuteQuery("SelectTransRegisterReport", Parameters); return(ds); }
public DataSet LoadEditDetails() { object Id = 0; object[,] Parameters = new object[, ] { { "@VoucherNumber", VoucherNumber }, { "@TransactionType", TransactionType } }; DataSet ds = new DataSet(); DBActions db = new General.DBActions(); ds = db.ExecuteQuery("LoadEditDetails", Parameters); return(ds); }
public DataSet SelecInvdetails() { object Id = 0; object[,] Parameters = new object[, ] { { "@ProductCode", pcode } }; DataSet ds = new DataSet(); DBActions db = new General.DBActions(); ds = db.ExecuteQuery("SelectProductDetails", Parameters); return(ds); }
public int ValidateUsers() { object[,] Parameters = new object[, ] { { "@UserName", UserName }, { "@Password", Passwd } }; DataSet ds = new DataSet(); DBActions db = new General.DBActions(); ds = db.ExecuteQuery("SelectUserByUserNameAndPassword", Parameters); int result = 0; if (ds.Tables[0].Rows.Count > 0) { result = 1; } return(result); }