public string AddSoloReservationRecord(SoloReservation SoloReservationEntities) { try { SqlCommand cmd = new SqlCommand("AddNewSoloResDetails", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@IdSoloReservation", SoloReservationEntities.IdSoloReservation); cmd.Parameters.AddWithValue("@Name", SoloReservationEntities.Name); cmd.Parameters.AddWithValue("@Date", SoloReservationEntities.Date); cmd.Parameters.AddWithValue("@TimeSlot", SoloReservationEntities.TimeSlot); cmd.Parameters.AddWithValue("@Reason", SoloReservationEntities.Reason); cmd.Parameters.AddWithValue("@Seat", SoloReservationEntities.Seat); con.Open(); cmd.ExecuteNonQuery(); con.Close(); return("Data save Successfully"); } catch (Exception ex) { if (con.State == ConnectionState.Open) { con.Close(); } return(ex.Message.ToString()); } }
//get list of soloreservations filter with sql string. public static List <SoloReservation> getSoloReservations(string sql) { string connectionString = "Server=(localdb)\\mssqllocaldb;Database=NGTI;Trusted_Connection=True;MultipleActiveResultSets=true"; SqlConnection conn = new SqlConnection(connectionString); SqlCommand cmd = new SqlCommand(sql, conn); var model = new List <SoloReservation>(); conn.Open(); using (conn) { SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { var soloRes = new SoloReservation(); soloRes.IdSoloReservation = (int)rdr["IdSoloReservation"]; soloRes.Name = (string)rdr["Name"]; soloRes.Date = (DateTime)rdr["Date"]; soloRes.TimeSlot = (string)rdr["TimeSlot"]; soloRes.Reason = (string)rdr["Reason"]; soloRes.Seat = (string)rdr["Seat"]; model.Add(soloRes); } } conn.Close(); return(model); }