public static int Update(RequesterStaging requesterstaging)
{
var r = DataFacade.GetDataRow("RequesterStagingUpdate",
new ParameterValue("RequesterID", requesterstaging.RequesterID),
new ParameterValue("Motivation", requesterstaging.Motivation),
new ParameterValue("SiteName", requesterstaging.SiteName),
new ParameterValue("SiteNumber", requesterstaging.SiteNumber),
new ParameterValue("EmailAddress", requesterstaging.EmailAddress),
new ParameterValue("ContactNo", requesterstaging.ContactNo),
new ParameterValue("RequesterName", requesterstaging.RequesterName)
);
return(Convert.ToInt32(r["RequesterID"]));
}
public static RequesterStaging RequesterStagingGet(string sitenumber)
{
var requesterstaging = new RequesterStaging();
var paramList = new List <ParameterValue> {
new ParameterValue("SiteNumber", sitenumber)
};
var r = DataFacade.GetDataRow("RequesterStagingGet",
paramList.ToArray());
if (r != null)
{
Populate(requesterstaging, r);
}
return(requesterstaging);
}
private static RequesterStaging Populate(RequesterStaging requesterstaging, DataRow dr)
{
if (dr["RequesterID"] != DBNull.Value)
{
requesterstaging.RequesterID = Convert.ToInt32(dr["RequesterID"]);
}
if (dr["RequestDate"] != DBNull.Value)
{
requesterstaging.RequestDate = Convert.ToDateTime(dr["RequestDate"]);
}
if (dr["Motivation"] != DBNull.Value)
{
requesterstaging.Motivation = Convert.ToString(dr["Motivation"]);
}
if (dr["SiteName"] != DBNull.Value)
{
requesterstaging.SiteName = Convert.ToString(dr["SiteName"]);
}
if (dr["SiteNumber"] != DBNull.Value)
{
requesterstaging.SiteNumber = Convert.ToString(dr["SiteNumber"]);
}
if (dr["EmailAddress"] != DBNull.Value)
{
requesterstaging.EmailAddress = Convert.ToString(dr["EmailAddress"]);
}
if (dr["ContactNo"] != DBNull.Value)
{
requesterstaging.ContactNo = Convert.ToString(dr["ContactNo"]);
}
if (dr["RequesterName"] != DBNull.Value)
{
requesterstaging.RequesterName = Convert.ToString(dr["RequesterName"]);
}
return(requesterstaging);
}
public static List <RequesterStaging> GetAll()
{
var paramList = new List <ParameterValue>();
var dataTable = DataFacade.GetDataTable("RequesterStagingGetAll",
paramList.ToArray());
var returnList = new List <RequesterStaging>();
foreach (DataRow r in dataTable.Rows)
{
var requesterstaging = new RequesterStaging();
Populate(requesterstaging, r);
returnList.Add(requesterstaging);
}
return(returnList);
}
public int Update(RequesterStaging requesterstaging)
{
return(RequesterStagingDao.Update(requesterstaging));
}
public int Add(RequesterStaging requesterstaging)
{
return(RequesterStagingDao.Add(requesterstaging));
}
