public int Update(Object.Book book) { using (SqlConnection con = new SqlConnection(SharedMethods.getConnectionString())) { SqlCommand cmd = new SqlCommand("spUpdateBook_tblBook", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Id", book.Id); cmd.Parameters.AddWithValue("@Name", book.Name); cmd.Parameters.AddWithValue("@Grade", book.Grade); cmd.Parameters.AddWithValue("@PublisherId", book.PublisherId); cmd.Parameters.AddWithValue("@SubjectId", book.SubjectId); cmd.Parameters.AddWithValue("@PublishedYear", book.PublishedYear); cmd.Parameters.AddWithValue("@Quantity", book.Quantity); SqlParameter Result = new SqlParameter("@ResultNumber", DbType.Int32); Result.Direction = ParameterDirection.Output; cmd.Parameters.Add(Result); con.Open(); cmd.ExecuteNonQuery(); con.Close(); return((int)Result.Value); } }
public void Delete(int Id, out string Message, out System.Drawing.Color Color) { Object.Book book = new Object.Book(); book.Id = Id; int ResultNumber = crud.Delete(book); message.Delete(ResultNumber, out Message, out Color); }
public int Delete(Object.Book book) { using (SqlConnection con = new SqlConnection(SharedMethods.getConnectionString())) { SqlCommand cmd = new SqlCommand("Delete From tblBook Where Id = @Id", con); cmd.CommandType = CommandType.Text; cmd.Parameters.AddWithValue("@Id", book.Id); con.Open(); return(cmd.ExecuteNonQuery()); } }
public void Create(string Name, int PublisherId, int Grade, int SubjectId, int PublishedYear, int Quantity, out string Message, out System.Drawing.Color Color) { Object.Book book = new Object.Book(); book.Name = Name; book.PublisherId = PublisherId; book.Grade = Grade; book.PublishedYear = PublishedYear; book.SubjectId = SubjectId; book.Quantity = Quantity; int ResultNumber = crud.Create(book); message.Create(ResultNumber, out Message, out Color); }