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; } }