public DataSet GetSingleProductsDataSet()
{
objSQLdb = new SQLDB();
SqlParameter[] param = new SqlParameter[1];
DataSet ds = new DataSet();
try
{
param[0] = objSQLdb.CreateParameter("@sCompCode", DbType.String, CommonData.CompanyCode, ParameterDirection.Input);
ds = objSQLdb.ExecuteDataSet("SingleProductMasAll_Get", CommandType.StoredProcedure, param);
}
catch (Exception ex)
{
throw new Exception(ex.ToString());
}
finally
{
objSQLdb = null;
}
return(ds);
}
public DataSet UserBranchList(string strCompanCode)
{
objSQLdb = new SQLDB();
SqlParameter[] param = new SqlParameter[1];
DataSet ds = new DataSet();
try
{
param[0] = objSQLdb.CreateParameter("@sCompCode", DbType.String, strCompanCode, ParameterDirection.Input);
ds = objSQLdb.ExecuteDataSet("UserBranchMaster_Get", CommandType.StoredProcedure, param);
}
catch (Exception ex)
{
throw new Exception(ex.ToString());
}
finally
{
param = null;
objSQLdb = null;
}
return(ds);
}
