public string AddGroupReservationRecord(GroupReservation GroupReservationEntities)
{
try
{
SqlCommand cmd = new SqlCommand("AddNewGroupResDetails", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@IdGroupReservation", GroupReservationEntities.IdGroupReservation);
cmd.Parameters.AddWithValue("@Name", GroupReservationEntities.Name);
cmd.Parameters.AddWithValue("@TeamName", GroupReservationEntities.Teamname);
cmd.Parameters.AddWithValue("@Date", GroupReservationEntities.Date);
cmd.Parameters.AddWithValue("@TimeSlot", GroupReservationEntities.TimeSlot);
cmd.Parameters.AddWithValue("@Reason", GroupReservationEntities.Reason);
cmd.Parameters.AddWithValue("@Seat", GroupReservationEntities.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());
}
}
public static GroupReservation getGroupReservation(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 GroupReservation();
conn.Open();
using (conn)
{
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
var res = new GroupReservation();
res.IdGroupReservation = (int)rdr["IdGroupReservation"];
res.Teamname = (string)rdr["Teamname"];
res.Name = (string)rdr["Name"];
res.Date = (DateTime)rdr["Date"];
res.TimeSlot = (string)rdr["TimeSlot"];
res.Reason = (string)rdr["Reason"];
res.Seat = (string)rdr["Seat"];
model = res;
}
}
conn.Close();
return(model);
}
