public static SurveyDet GetSurveyDetail(int wrid)
{
SurveyDet det = null;
List <SqlParameter> sqlParams = new List <SqlParameter>();
sqlParams.Add(new SqlParameter("@WRNumber", (Object)wrid));
DataSet ds = DBCommands.GetData("spn_GetSurvey_2_customersurvey", sqlParams);
if (ds != null && ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0)
{
//populate wr fieds
det = new SurveyDet();
DataRow row = ds.Tables[0].Rows[0];
//det.WRNumber = Convert.ToInt32(row["WRnumber"].ToString());
det.WONumber = Convert.ToInt32(row["WOnumber"].ToString());
det.CreatedOn = Convert.ToDateTime(row["DateTime"].ToString());
//if (row["RequesterPhone"].ToString() != "")
//{ det.RequesterPhone = row["RequesterPhone"].ToString(); }
////det.CreatedOn = Convert.ToDateTime(row["CreatedOn"].ToString());
//det.RequestedOn = Convert.ToDateTime(row["Requested"].ToString());
//det.RequestedBy = row["RequestedBy"].ToString();
//if (row["Shop"].ToString() != "")
//{ det.Shop = row["Shop"].ToString(); }
//if (row["Status"].ToString() != "")
//{ det.Status = row["Status"].ToString(); }
//if (row["Descriptions"].ToString() != "")
//{ det.Description = row["Descriptions"].ToString(); }
//if (row["Building"].ToString() != "")
//{ det.Building = row["Building"].ToString(); }
//if (row["Property"].ToString() != "")
//{ det.Property = row["Property"].ToString(); }
//if (row["Room"].ToString() != "")
//{ det.Room = row["Room"].ToString(); }
if (row["Comments"].ToString() != "")
{
det.Comments = row["Comments"].ToString();
}
det.Question5Ans = Convert.ToInt32(row["Question5"].ToString());
if (row["Question1"].ToString() != "")
{
det.Question1Ans = Convert.ToInt32(row["Question1"].ToString());
}
if (row["Question2"].ToString() != "")
{
det.Question2Ans = Convert.ToInt32(row["Question2"].ToString());
}
if (row["Question3"].ToString() != "")
{
det.Question3Ans = Convert.ToInt32(row["Question3"].ToString());
}
}
return(det);
}
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.";
}
}
}
}
