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