public DataTable Get_CompanyMaster(int CompanyMasterId, ref PaginationInfo pager)
{
List <SqlParameter> sqlParam = new List <SqlParameter>();
sqlParam.Add(new SqlParameter("@CompanyId", CompanyMasterId));
DataTable dt = _sqlRepo.ExecuteDataTable(sqlParam, StoredProcedureEnum.sp_Get_CompanyMaster.ToString(), CommandType.StoredProcedure);
return(CommonMethods.GetPaginatedTable(dt, ref pager));
}
public DataTable GetWarehouses(string warhouseName, ref PaginationInfo pager)
{
List <SqlParameter> sqlParam = new List <SqlParameter>();
sqlParam.Add(new SqlParameter("@WarehouseName", warhouseName));
DataTable dt = _sqlHelper.ExecuteDataTable(sqlParam, StoredProcedureEnum.sp_Get_Warehouse.ToString(), CommandType.StoredProcedure);
return(CommonMethods.GetPaginatedTable(dt, ref pager));
}
public List <ContactPersonInfo> Get_ContactPersonMasters(ref PaginationInfo pager)
{
List <ContactPersonInfo> ContPerInfos = new List <ContactPersonInfo>();
DataTable dt = _sqlRepo.ExecuteDataTable(null, StoredProcedureEnum.sp_Get_ContactPersonMaster.ToString(), CommandType.StoredProcedure);
foreach (DataRow dr in CommonMethods.GetRows(dt, ref pager))
{
ContPerInfos.Add(Get_ContactPersonMaster_Values(dr));
}
return(ContPerInfos);
}
public DataTable GetCountries(string countryCode, string countryName, ref PaginationInfo pager)
{
List <SqlParameter> sqlParam = new List <SqlParameter>();
sqlParam.Add(new SqlParameter("@CountryCode", countryCode));
sqlParam.Add(new SqlParameter("@CountryName", countryName));
DataTable dt = _sqlHelper.ExecuteDataTable(sqlParam, StoredProcedureEnum.sp_Get_Countries.ToString(), CommandType.StoredProcedure);
return(CommonMethods.GetPaginatedTable(dt, ref pager));
}
public DataTable GetBranches(int companyId, string BranchName, ref PaginationInfo pager)
{
List <SqlParameter> sqlParam = new List <SqlParameter>();
sqlParam.Add(new SqlParameter("@CompanyId", companyId));
sqlParam.Add(new SqlParameter("@BranchName", BranchName));
DataTable dt = _sqlHelper.ExecuteDataTable(sqlParam, StoredProcedureEnum.sp_Get_Branches.ToString(), CommandType.StoredProcedure);
return(CommonMethods.GetPaginatedTable(dt, ref pager));
}
public DataTable GetDepartments(string departmentInfoName, ref PaginationInfo pager)
{
List <SqlParameter> sqlParam = new List <SqlParameter>();
sqlParam.Add(new SqlParameter("@DepartmentName", departmentInfoName));
DataTable dt = _sqlHelper.ExecuteDataTable(sqlParam, StoredProcedureEnum.sp_Get_Deparments.ToString(), CommandType.StoredProcedure);
return(CommonMethods.GetPaginatedTable(dt, ref pager));
}