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