public static int AddBookType(BookType bookType) { dbConnector connector = new dbConnector(); int result = 0; try { SqlCommand cmd = new SqlCommand("spAddBookType", connector.GetConnection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@BookTypeID", bookType.BookTypeID); cmd.Parameters.AddWithValue("@BookTypeName", bookType.BookTypeName); cmd.Parameters.AddWithValue("@Memo", bookType.Memo); connector.OpenConnection(); result = cmd.ExecuteNonQuery(); } catch (Exception e) { MessageBox.Show("Error in Inserting data"); } finally { connector.CloseConnection(); } return(result); }
public static int SaveBookType(BookType bookType) { dbConnector connector = new dbConnector(); int result = 0; try { SqlCommand cmd = new SqlCommand("spSaveBookType", connector.GetConnection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@BookTypeID", bookType.BookTypeID); cmd.Parameters.AddWithValue("@BookTypeName", bookType.BookTypeName); cmd.Parameters.AddWithValue("Memo", bookType.Memo); connector.OpenConnection(); result = cmd.ExecuteNonQuery(); } catch (Exception e) { Console.WriteLine(e); throw; } finally { connector.CloseConnection(); } return(result); }
public static List <BookType> GetBookTypes() { dbConnector connector = new dbConnector(); try { List <BookType> bookTypes = new List <BookType>(); SqlCommand cmd = new SqlCommand("spGetBookType", connector.GetConnection); cmd.CommandType = CommandType.StoredProcedure; connector.OpenConnection(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { BookType bookType = new BookType(); bookType.BookTypeID = Convert.ToInt32(reader["BookTypeID"]); bookType.BookTypeName = reader["BookTypeName"].ToString(); bookType.Memo = reader["Memo"].ToString(); bookTypes.Add(bookType); } return(bookTypes); } catch (Exception e) { Console.WriteLine(e); throw; } finally { connector.CloseConnection(); } }