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