public JobSiteDTO GetSitesBySiteID(int siteID)
{
JobSiteDTO item = new JobSiteDTO();
try
{
SqlParameter param = new SqlParameter("SiteID", siteID);
DataTable dtUser = SqlClientRMXProd.ExecuteDataTable("udsp_GetSiteBySiteID", new SqlParameter[] { param });
if (dtUser != null && dtUser.Rows.Count > 0)
{
item.Address = dtUser.Rows[0]["Address"].ToString(); //
item.Coaxial = dtUser.Rows[0]["Coaxial"].ToString(); //
item.CreationDate = dtUser.Rows[0]["CreationDate"].ToString();
item.Customer = dtUser.Rows[0]["Customer"].ToString(); //
item.DeviceRegistration = dtUser.Rows[0]["DeviceRegistration"].ToString(); //
item.Dispensers = dtUser.Rows[0]["Dispensers"].ToString(); //
item.FacilityName = dtUser.Rows[0]["FacilityName"].ToString(); //
item.MarketingManager = dtUser.Rows[0]["MarketingManager"].ToString(); //
item.MeterCount = dtUser.Rows[0]["MeterCount"].ToString(); //
item.ModifiedDate = dtUser.Rows[0]["ModifiedDate"].ToString();
item.PhoneNumber = dtUser.Rows[0]["PhoneNumber"].ToString(); //
item.PicturesFiles = dtUser.Rows[0]["Pictures/Files"].ToString(); //
item.RSM = dtUser.Rows[0]["RSM"].ToString(); //
item.SiteEmail = dtUser.Rows[0]["SiteEmail"].ToString(); //
item.StateID = dtUser.Rows[0]["StateID"].ToString();
item.Tanks = dtUser.Rows[0]["Tanks"].ToString();
item.UniqueID = dtUser.Rows[0]["UniqueID"].ToString();
item.WeightsAndMeasuresCertificateNumber = dtUser.Rows[0]["WeightsAndMeasuresCertificateNumber"].ToString();
item.WMCertificateImage = dtUser.Rows[0]["WMCertificateImage"].ToString();
}
}
catch (Exception ex)
{ }
return(item);
}
public JobSiteDTO GetSitesBySiteID(int siteID)
{
if (_user == null)
{
_user = new UserService();
}
JobSiteDTO site = _user.GetSitesBySiteID(siteID);
return(site);
}
public List <JobSiteDTO> GetSites()
{
List <JobSiteDTO> list = new List <JobSiteDTO>();
try
{
DataTable dtUser = SqlClientRMXProd.ExecuteDataTable("udsp_GetSite");
if (dtUser != null && dtUser.Rows.Count > 0)
{
int i = 0;
foreach (DataRow row in dtUser.Rows)
{
// if (dtUser != null && dtUser.Rows.Count > 0)
// {
JobSiteDTO item = new JobSiteDTO();
item.Address = dtUser.Rows[i]["Address"].ToString(); //
item.Coaxial = dtUser.Rows[i]["Coaxial"].ToString(); //
item.CreationDate = dtUser.Rows[i]["CreationDate"].ToString();
item.Customer = dtUser.Rows[i]["Customer"].ToString(); //
item.DeviceRegistration = dtUser.Rows[i]["DeviceRegistration"].ToString(); //
item.Dispensers = dtUser.Rows[i]["Dispensers"].ToString(); //
item.FacilityName = dtUser.Rows[i]["FacilityName"].ToString(); //
item.MarketingManager = dtUser.Rows[i]["MarketingManager"].ToString(); //
item.MeterCount = dtUser.Rows[i]["MeterCount"].ToString(); //
item.ModifiedDate = dtUser.Rows[i]["ModifiedDate"].ToString();
item.PhoneNumber = dtUser.Rows[i]["PhoneNumber"].ToString(); //
item.PicturesFiles = dtUser.Rows[i]["Pictures/Files"].ToString(); //
item.RSM = dtUser.Rows[i]["RSM"].ToString(); //
item.SiteEmail = dtUser.Rows[i]["SiteEmail"].ToString(); //
item.StateID = dtUser.Rows[i]["StateID"].ToString();
item.Tanks = dtUser.Rows[i]["Tanks"].ToString();
item.UniqueID = dtUser.Rows[i]["UniqueID"].ToString();
item.WeightsAndMeasuresCertificateNumber = dtUser.Rows[i]["WeightsAndMeasuresCertificateNumber"].ToString();
item.WMCertificateImage = dtUser.Rows[i]["WMCertificateImage"].ToString();
list.Add(item);
}
}
}
catch (Exception ex)
{ }
return(list);
}
