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