Exemplo n.º 1
0
 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());
     }
 }
Exemplo n.º 2
0
        //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);
        }