public static RequestDet GetSurveyRequestDetail(int id)
{
RequestDet req = null;
List <SqlParameter> sqlParams = new List <SqlParameter>();
sqlParams.Add(new SqlParameter("@WRNumber", (Object)id));
DataSet ds = DBCommands.GetData("spn_GetSurvey_1_customersurvey", sqlParams);
if (ds != null && ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0)
{
//populate wr fieds
req = new RequestDet();
DataRow row = ds.Tables[0].Rows[0];
req.WONumber = Convert.ToInt32(row["WOnumber"].ToString());
req.RequestedOn = Convert.ToDateTime(row["Requested"].ToString());
req.RequestedBy = row["RequestedBy"].ToString();
if (row["Comments"].ToString() != "")
{
req.Comments = row["Comments"].ToString();
}
if (row["Descriptions"].ToString() != "")
{
req.Description = row["Descriptions"].ToString();
}
if (row["Building"].ToString() != "")
{
req.Building = row["Building"].ToString();
}
if (row["Shop"].ToString() != "")
{
req.Shop = row["Shop"].ToString();
}
if (row["Property"].ToString() != "")
{
req.Property = row["Property"].ToString();
}
if (row["Status"].ToString() != "")
{
req.Status = row["Status"].ToString();
}
if (row["Room"].ToString() != "")
{
req.RequesterRoom = row["Room"].ToString();
}
if (row["RequesterPhone"].ToString() != "")
{
req.RequesterPhone = row["RequesterPhone"].ToString();
}
}
return(req);
}
protected void Page_Load(object sender, EventArgs e)
{
int wrID = ((Request.QueryString["wonumber"] == null) || (Request.QueryString["wonumber"] == "")) ? -1 : Int32.Parse(Request.QueryString["wonumber"]);
if (!Page.IsPostBack)
{
if (wrID > 0)
{
RequestDet rdet = RequestLogic.GetRequestDetail(wrID);
if (rdet != null)
{
lbNoRequestMessage.Text = string.Empty;
lbWRNumber.Text = wrID.ToString();
lbDescription.Text = rdet.Description;
lbBuilding.Text = rdet.RequesterBuilding;
lbRoom.Text = rdet.RequesterRoom;
lbRequestedOn.Text = rdet.RequestedOn.ToString();
lbRequestedBy.Text = rdet.RequestedBy;
lbShop.Text = rdet.RequestedBy;
lbStatus.Text = rdet.Status;
lbReqComments.Text = rdet.Comments;
lbCustomerName.Text = rdet.RequestedBy;
lbCustomerPhone.Text = rdet.RequesterPhone;
}
else
{
lbNoRequestMessage.Text = "No service request information.";
}
SurveyDet sdet = SurveyLogic.GetSurveyDetail(wrID);
if (sdet != null)
{
lbNoSurveyMessage.Text = string.Empty;
lbWONumber.Text = sdet.WONumber.ToString();
lbCreatedOn.Text = sdet.CreatedOn.ToString();
lbQuestion5Ans.Text = sdet.Question5Ans.ToString();
lbQuestion1Ans.Text = sdet.Question1Ans.ToString();
lbQuestion2Ans.Text = sdet.Question2Ans.ToString();
lbQuestion3Ans.Text = sdet.Question3Ans.ToString();
lbComments.Text = sdet.Comments;
}
else
{
lbNoSurveyMessage.Text = "No survey response found.";
}
}
}
}
private void LoadWRDetail(int wrId)
{
//Descriptions, RequestedBy, RequesterPhone, Property, Building, Room, Requested, WOnumber, Shop, Status, Comments
RequestDet wrdet = RequestLogic.GetRequestDetail(wrId);
lbWRnumber.Text = wrId.ToString();
if (wrdet != null)
{
//#region "Display Read Only WR Info"
lbRequestedOn.Text = wrdet.RequestedOn.ToShortDateString();
lbBuilding.Text = wrdet.Building;
lbRoom.Text = wrdet.RequesterRoom;
lbName.Text = wrdet.RequestedBy;
lbPhone.Text = wrdet.RequesterPhone;
lbComments.Text = wrdet.Comments;
lbDescription.Text = wrdet.Description;
}
}
