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);
}
