public List <HCM_Location> GetAllLocations() { List <HCM_Location> location_list = new List <HCM_Location>(); HCM_Location location_obj = new HCM_Location(); try { using (SqlConnection sql_obj = new SqlConnection()) { sql_obj.ConnectionString = sql.GetConnection(); sql_obj.Open(); using (SqlCommand cmd = new SqlCommand("HCM_PROC_GetAllLocations", sql_obj)) { cmd.CommandType = CommandType.StoredProcedure; cmd.CommandTimeout = 0; SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); sql_obj.Close(); if (dt.Rows.Count > 0) { for (var i = 0; i < dt.Rows.Count; i++) { location_obj = new HCM_Location(); location_obj.LocationID = Convert.ToInt32(dt.Rows[i]["LocationID"]); location_obj.Country.Region.RegionID = Convert.ToInt32(dt.Rows[i]["RegionID"]); location_obj.Country.Region.RegionName = Convert.ToString(dt.Rows[i]["RegionName"]); location_obj.Country.Region.RegionCode = Convert.ToString(dt.Rows[i]["RegionCode"]); location_obj.LocationName = Convert.ToString(dt.Rows[i]["LocationName"]); location_obj.Country.CountryID = Convert.ToInt32(dt.Rows[i]["CountryID"]); location_obj.Country.CountryName = Convert.ToString(dt.Rows[i]["CountryName"]); location_obj.LocationDescription = Convert.ToString(dt.Rows[i]["LocationDescription"]); location_obj.Status = Convert.ToBoolean(dt.Rows[i]["Status"]); location_list.Add(location_obj); } } } } } catch (Exception ex) { throw ex; } return(location_list); }
public List <HCM_Location> GetLocationBasedOnCountries(string CountryID) { List <HCM_Location> location_list = new List <HCM_Location>(); HCM_Location location_obj = new HCM_Location(); try { using (SqlConnection sql_obj = new SqlConnection()) { sql_obj.ConnectionString = sql.GetConnection(); sql_obj.Open(); using (SqlCommand cmd = new SqlCommand("HCM_PROC_GetLocationsBasedOnCountryID", sql_obj)) { cmd.CommandType = CommandType.StoredProcedure; cmd.CommandTimeout = 0; cmd.Parameters.AddWithValue("@CountryID", Convert.ToInt32(CountryID)); SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); sql_obj.Close(); if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { location_obj = new HCM_Location(); location_obj.LocationID = Convert.ToInt32(dt.Rows[i]["LocationID"]); location_obj.LocationName = Convert.ToString(dt.Rows[i]["LocationName"]); location_list.Add(location_obj); } } } } } catch (Exception ex) { throw ex; } return(location_list); }