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);
}
//get work location building list by property
public static DataSet BuildingListByProperty(string property)
{
List <SqlParameter> sqlParams = new List <SqlParameter>();
SqlParameter spProperty = new SqlParameter("@Property", property);
sqlParams.Add(spProperty);
//get data from database
return(DBCommands.GetData("spn_GetBuildingList_Property_59000", sqlParams));
}
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);
}
public static DataSet GetRequesterInstitute()
{
//get data from database
return(DBCommands.GetData("spn_GetInstitute_59000", null));
}
public static DataSet GetBuildingList()
{
//get data from database
return(DBCommands.GetData("spn_GetBuildingList_59000", null));
}
public static DataSet GetProperties()
{
//get data from
return(DBCommands.GetData("spn_GetProperty_59000", null));
}
public static DataSet GetLookupCollectionDataSet(string storeProcedure, List <SqlParameter> sqlParams)
{
return(DBCommands.GetData(storeProcedure, sqlParams));
}
