private List <Detais> getDetails(Guid guidLocationOID)
{
List <Detais> DetaisList = null;
try
{
string sSQL = "SELECT * FROM LocationDetails WHERE LocationOID=@LocationOID";
SqlParameter[] sqlParam = new SqlParameter[1];
sqlParam[0] = new SqlParameter("@LocationOID", SqlDbType.UniqueIdentifier);
sqlParam[0].Value = guidLocationOID;
DataSet ds = SqlHelper.ExecuteDataset(ConnectionString, CommandType.Text, sSQL, sqlParam);
if (ds.Tables[0].Rows.Count > 0)
{
DetaisList = new List <Detais>();
Detais detail = new Detais();
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
detail = new Detais();
detail.Culture = ds.Tables[0].Rows[i]["Culture"].ToString();
detail.Address = ds.Tables[0].Rows[i]["Address"].ToString();
detail.LocationName = ds.Tables[0].Rows[i]["LocationName"].ToString();
detail.Description = ds.Tables[0].Rows[i]["Description"].ToString();
DetaisList.Add(detail);
}
}
}
catch (Exception ex) { }
return(DetaisList);
}
public List <Budget_Locations> SelectByCulture(string Culture)
{
List <Budget_Locations> locationList = null;
try
{
string sSQL = "SELECT * FROM Locations";
DataSet ds = SqlHelper.ExecuteDataset(ConnectionString, CommandType.Text, sSQL);
if (ds.Tables[0].Rows.Count > 0)
{
locationList = new List <Budget_Locations>();
List <Detais> detailList = null;
Budget_Locations location = new Budget_Locations();
Detais detail = null;
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
location = new Budget_Locations();
location.LocationOID = new Guid(ds.Tables[0].Rows[i]["LocationOID"].ToString());
location.LocationCode = ds.Tables[0].Rows[i]["LocationCode"].ToString();
location.Phone = ds.Tables[0].Rows[i]["Phone"].ToString();
location.Fax = ds.Tables[0].Rows[i]["Fax"].ToString();
location.Email = ds.Tables[0].Rows[i]["Email"].ToString();
location.Latitude = ds.Tables[0].Rows[i]["Latitude"].ToString();
location.Longitude = ds.Tables[0].Rows[i]["Longitude"].ToString();
location.ProvinceCode = ds.Tables[0].Rows[i]["ProvinceCode"].ToString();
location.mfOpen = ds.Tables[0].Rows[i]["mfOpen"].ToString();
location.mfClose = ds.Tables[0].Rows[i]["mfClose"].ToString();
location.satOpen = ds.Tables[0].Rows[i]["satOpen"].ToString();
location.satClose = ds.Tables[0].Rows[i]["satClose"].ToString();
location.sunOpen = ds.Tables[0].Rows[i]["sunOpen"].ToString();
location.sunClose = ds.Tables[0].Rows[i]["sunClose"].ToString();
location.FileName = ds.Tables[0].Rows[i]["FileName"].ToString();
detail = getDetails(location.LocationOID).Find(x => x.Culture == Culture);
if (detail != null)
{
location.LocationDetais = new List <Detais>();
detailList = new List <Detais>();
detailList.Add(detail);
location.LocationDetais = detailList;
}
locationList.Add(location);
}
}
}
catch (Exception ex) { }
return(locationList);
}
