public static ValidationResult AddSurveyDetails(string reqby, string reqphone, string comments, int wrnumber, int Question1Ans, int Question2Ans, int Question3Ans, int Question5Ans)
{
List <SqlParameter> sqlParams = new List <SqlParameter>();
sqlParams.Add(new SqlParameter("@WRNumber", (Object)wrnumber));
sqlParams.Add(new SqlParameter("@Question1Ans", Question1Ans < 0 ? DBNull.Value : (Object)Question1Ans));
sqlParams.Add(new SqlParameter("@Question2Ans", Question2Ans < 0 ? DBNull.Value : (Object)Question2Ans));
sqlParams.Add(new SqlParameter("@Question3Ans", Question3Ans < 0 ? DBNull.Value : (Object)Question3Ans));
sqlParams.Add(new SqlParameter("@Question5Ans", Question5Ans < 0 ? DBNull.Value : (Object)Question5Ans));
sqlParams.Add(new SqlParameter("@RequestedBy", reqby));
sqlParams.Add(new SqlParameter("@RequesterPhone", (string.IsNullOrEmpty(reqphone)) ? DBNull.Value : (Object)reqphone));
sqlParams.Add(new SqlParameter("@Comments", (string.IsNullOrEmpty(comments)) ? DBNull.Value : (Object)comments));
//SqlParameter outNewWOnum = new SqlParameter("@Res", SqlDbType.Int);
//outNewWOnum.Direction = ParameterDirection.Output;
//sqlParams.Add(outNewWOnum);
ValidationResult vr = DBCommands.ExecuteNonQueryWithResReturn("spn_AddResponse_CustomerSurvey", sqlParams);
//if (vr.Success)
//{
// //if no error, update id
// details.WONumber = Convert.ToInt32(outNewWOnum.Value);
// details.ConstructionNum = outConstructionNum.Value.ToString();
//}
return(vr);
}
