public static bool Insert(BookingLight booklight) { bool status = false; try { using (SqlConnection con = new SqlConnection(conString)) { if (con.State == ConnectionState.Closed) { con.Open(); } string qyery = "Insert into BookingLight(CustomerId,LightType,LightNameID) " + "Values(@CustomerId,@LightType,@LightNameID)"; SqlCommand cmd = new SqlCommand(qyery, con); cmd.Parameters.Add(new SqlParameter("@CustomerId", booklight.CustomerId)); cmd.Parameters.Add(new SqlParameter("@LightType", booklight.LightType)); cmd.Parameters.Add(new SqlParameter("@LightNameID", booklight.LightNameID)); // cmd.Parameters.Add(new SqlParameter("@LightId", booklight.LightId)); cmd.ExecuteNonQuery(); if (con.State == ConnectionState.Open) { con.Close(); } status = true; } } catch (Exception ex) { throw ex; } return(status); }
public static bool Update(string CustomerId, BookingLight booklight) { bool status = false; try { using (SqlConnection con = new SqlConnection(conString)) { if (con.State == ConnectionState.Closed) { con.Open(); } string query = "UPDATE BookingLight SET LightType=@LightType, LightNameID=@LightNameID " + "WHERE CustomerId=@CustomerId"; SqlCommand cmd = new SqlCommand(query, con); cmd.Parameters.Add(new SqlParameter("@CustomerId", booklight.CustomerId)); cmd.Parameters.Add(new SqlParameter("@LightType", booklight.LightType)); cmd.Parameters.Add(new SqlParameter("@LightNameID", booklight.LightNameID)); //cmd.Parameters.Add(new SqlParameter("@LightId", booklight.LightId)); cmd.ExecuteNonQuery(); if (con.State == ConnectionState.Open) { con.Close(); } status = true; } } catch (Exception ex) { throw ex; } return(status); }
public static List <BookingLight> GetAll() { List <BookingLight> booklightlist = new List <BookingLight>(); try { using (SqlConnection con = new SqlConnection(conString)) { if (con.State == ConnectionState.Closed) { con.Open(); } string query = "SELECT * FROM BookingLight"; SqlCommand cmd = new SqlCommand(query, con); SqlDataReader reader = cmd.ExecuteReader(); if (reader != null) { if (reader.HasRows) { while (reader.Read()) { BookingLight booklight = new BookingLight() { LightType = reader["LightType"].ToString(), LightNameID = reader["LightNameID"].ToString(), CustomerId = int.Parse(reader["CustomerId"].ToString()), //LightId = int.Parse(reader["LightId"].ToString()) }; booklightlist.Add(booklight); } reader.Close(); } } if (con.State == ConnectionState.Open) { con.Close(); } } } catch (Exception ex) { throw ex; } return(booklightlist); }