// GET: Customer_complaint public ActionResult Customer_Complaint(Customer_Complaint obj) { try { Customer_Complaint _Complaint = new Customer_Complaint(); ViewBag.Related = cmplnt_DAL.DrpRelated(obj); } catch (Exception e) { ViewBag.Exception = e; } return(View()); }
//DropDown code public List <Customer_Complaint> DrpRelated(Customer_Complaint obj) { List <Customer_Complaint> list = new List <Customer_Complaint>(); SqlConnection con = new SqlConnection(strConnLive); try { con.Open(); SqlCommand cmd = new SqlCommand("inCore.dbo.Usp_Customer_complaint", con); cmd.CommandType = CommandType.StoredProcedure; SqlDataAdapter da = new SqlDataAdapter(cmd); cmd.Parameters.AddWithValue("@Mode", "DrpRelated"); DataSet ds = new DataSet(); da.Fill(ds); if (ds.Tables[0].Rows.Count > 0) { foreach (DataRow item in ds.Tables[0].Rows) { Customer_Complaint cust = new Customer_Complaint(); cust.Complaindesc = item["Complaindesc"].ToString(); cust.complaincode = item["complaincode"].ToString(); list.Add(cust); } } } catch (Exception) { return(null); } finally { con.Close(); } return(list); }