public List <Budget_Locations> SelectAll()
{
List <Budget_Locations> LocationsList = null;
try
{
string sSQL = "SELECT * FROM Locations";
DataSet ds = SqlHelper.ExecuteDataset(ConnectionString, CommandType.Text, sSQL);
if (ds.Tables[0].Rows.Count > 0)
{
LocationsList = new List <Budget_Locations>();
Budget_Locations location = null;
List <Detais> detailList = 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();
detailList = getDetails(location.LocationOID);
if (detailList != null)
{
location.LocationDetais = new List <Detais>();
location.LocationDetais = detailList;
}
LocationsList.Add(location);
}
}
}
catch (Exception ex) { }
return(LocationsList);
}
public List <Budget_Locations> SelectByProvince(string ProvinceCode)
{
List <Budget_Locations> locationList = null;
try
{
string sSQL = "SELECT * FROM Locations WHERE ProvinceCode=@ProvinceCode";
SqlParameter[] sqlParam = new SqlParameter[1];
sqlParam[0] = new SqlParameter("@ProvinceCode", SqlDbType.NVarChar);
sqlParam[0].Value = ProvinceCode;
DataSet ds = SqlHelper.ExecuteDataset(ConnectionString, CommandType.Text, sSQL, sqlParam);
if (ds.Tables[0].Rows.Count > 0)
{
locationList = new List <Budget_Locations>();
List <Detais> detailList = null;
Budget_Locations location = new Budget_Locations();
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();
detailList = getDetails(location.LocationOID);
if (detailList != null)
{
location.LocationDetais = detailList;
}
locationList.Add(location);
}
}
}
catch (Exception ex) { }
return(locationList);
}
public Budget_Locations SelectByOID(Guid guidLocationOID)
{
Budget_Locations location = null;
try
{
string sSQL = "SELECT * FROM Locations 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)
{
List <Detais> detailList = null;
location = new Budget_Locations();
location.LocationOID = new Guid(ds.Tables[0].Rows[0]["LocationOID"].ToString());
location.LocationCode = ds.Tables[0].Rows[0]["LocationCode"].ToString();
location.Phone = ds.Tables[0].Rows[0]["Phone"].ToString();
location.Fax = ds.Tables[0].Rows[0]["Fax"].ToString();
location.Email = ds.Tables[0].Rows[0]["Email"].ToString();
location.Latitude = ds.Tables[0].Rows[0]["Latitude"].ToString();
location.Longitude = ds.Tables[0].Rows[0]["Longitude"].ToString();
location.ProvinceCode = ds.Tables[0].Rows[0]["ProvinceCode"].ToString();
location.mfOpen = ds.Tables[0].Rows[0]["mfOpen"].ToString();
location.mfClose = ds.Tables[0].Rows[0]["mfClose"].ToString();
location.satOpen = ds.Tables[0].Rows[0]["satOpen"].ToString();
location.satClose = ds.Tables[0].Rows[0]["satClose"].ToString();
location.sunOpen = ds.Tables[0].Rows[0]["sunOpen"].ToString();
location.sunClose = ds.Tables[0].Rows[0]["sunClose"].ToString();
location.FileName = ds.Tables[0].Rows[0]["FileName"].ToString();
detailList = getDetails(location.LocationOID);
if (detailList != null)
{
location.LocationDetais = new List <Detais>();
location.LocationDetais = detailList;
}
}
}
catch (Exception ex) { }
return(location);
}