public ActionResult EditRequest(string reqno)
{
using (var con = new SqlConnection(_connectionString))
{
var result = con.Query <EditRepairStatus>("GetDataByCCNO",
new { CC_NO = reqno }, commandType: CommandType.StoredProcedure).FirstOrDefault();
var Problem = con.Query <GetProblem_Child_Order_problem>("GetProblem_From_Child_Order_problem",
new { CC_NO = result.CcNo }, commandType: CommandType.StoredProcedure).ToList();
foreach (var item in Problem)
{
var result1 = con.Query <string>("select Problem from mstdeviceproblem WHERE ProblemId =@ProblemId ", new { @ProblemId = item.ProblemId }, commandType: CommandType.Text).FirstOrDefault();
//var ProblemName = con.Query<string>("select Problem from mstdeviceproblem where ProblemID@ProblemID", new { @ProblemID = item.ProblemId}, commandType: CommandType.Text).FirstOrDefault();
item.ProblemName = result1;
}
result.CallStatusList = new SelectList(dropdown.BindCallStatus(), "Value", "Text");
result.ProblemList = new SelectList(dropdown.BindMstDeviceProblem(), "Value", "Text");
if (Problem != null)
{
result.Pro = Problem;
}
else
{
new List <GetProblem_Child_Order_problem>();
}
return(View(result));
}
}