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