public List <interviewmodel> GetData(string query) { interviewList = new List <interviewmodel>(); string strConnString = ConfigurationManager.ConnectionStrings["mvcapp_connection"].ConnectionString; using (SqlConnection conn = new SqlConnection(strConnString)) { using (var cmd = conn.CreateCommand()) { cmd.CommandText = query; cmd.Connection.Open(); using (var r = cmd.ExecuteReader()) { interviewmodel inv; while (r.Read()) { inv = new interviewmodel(); inv.Gender = r.GetString(0); inv.Title = r.GetString(1); inv.Occupation = r.GetString(2); inv.Company = r.GetString(3); inv.GivenName = r.GetString(4); inv.MiddleInitial = r.GetString(5); inv.Surname = r.GetString(6); inv.BloodType = r.GetString(7); inv.EmailAddress = r.GetString(8); interviewList.Add(inv); } } } } return(interviewList); }
public JsonResult AddInterview(interviewmodel inv) { string status = ""; bool success = false; try { string connectionString = ConfigurationManager.ConnectionStrings["mvcapp_connection"].ConnectionString; using (SqlConnection connection = new SqlConnection(connectionString)) { connection.Open(); using (SqlCommand command = connection.CreateCommand()) { command.CommandText = "INSERT INTO TBL_INTERVIEW(Gender,Title,Occupation,Company,GivenName," + "MiddleInitial,Surname,BloodType,EmailAddress) " + "VALUES( @Gender,@Title,@Occupation,@Company,@GivenName, " + "@MiddleInitial,@Surname,@BloodType,@EmailAddress)"; command.Parameters.AddWithValue("@Gender", inv.Gender); command.Parameters.AddWithValue("@Title", inv.Title); command.Parameters.AddWithValue("@Occupation", inv.Occupation); command.Parameters.AddWithValue("@Company", inv.Company); command.Parameters.AddWithValue("@GivenName", inv.GivenName); command.Parameters.AddWithValue("@MiddleInitial", inv.MiddleInitial); command.Parameters.AddWithValue("@Surname", inv.Surname); command.Parameters.AddWithValue("@BloodType", inv.BloodType); command.Parameters.AddWithValue("@EmailAddress", inv.EmailAddress); command.ExecuteNonQuery(); if (interviewList == null) { interviewList = new List <interviewmodel>(); } interviewList.Add(inv); status = "Save success"; success = true; } } } catch (SqlException ex) { status = "Save failed. " + ex.Message; success = false; } catch (Exception ex) { status = "Save failed. " + ex.Message; success = false; } return(new JsonResult { Data = new { status = status, success = success } }); }