/* * Updates the stock-status for a copy * Returns true if the copy was updated, false if no copy was updated * Throws a DALException if something else went wrong */ public Boolean updateStockStatus(DvdCopy dvdCopy, Boolean in_stock) { SqlCommand command = null; using (var cnn = new SqlConnection(sDatabaseLocatie)) { command = new SqlCommand("UPDATE DvdCopy SET in_stock = @in_stock WHERE dvd_copy_id = @dvd_copy_id", cnn); command.Parameters.Add(new SqlParameter("@in_stock", in_stock)); command.Parameters.Add(new SqlParameter("@dvd_copy_id", dvdCopy.dvd_copy_id)); try { cnn.Open(); if (command.ExecuteNonQuery() > 0) { return(true); } return(false); } catch (Exception ex) { throw new DALException("Failed to update copy stock-status", ex); } finally { if (cnn != null) { cnn.Close(); } } } }
/**Deletes item from cart*/ protected void gvCart_RowDeleting(object sender, GridViewDeleteEventArgs e) { int index = Convert.ToInt32(e.RowIndex); //remove item from shoppingcart if (new ShoppingCartService().deleteByID(gvCart.Rows[index].Cells[1].Text)) //cell 1 = shoppingcart_item_id { //succes } try { //set copy as in_stock DvdCopyService dvdCopyService = new DvdCopyService(); DvdCopy dvdCopy = dvdCopyService.getByID(gvCart.Rows[index].Cells[3].Text); //Throws NoRecordException || DALException dvdCopyService.updateStockStatus(dvdCopy, true); //Throws NoRecordException || DALException //update gridview if (Session["user"] != null) { fillCartGridView(); } } catch (NoRecordException) { //No dvd was found } }
/* * Returns a dvdcopy based on an ID * Throws a NoRecordException if no records were found * Throws a DALException if something else went wrong */ public DvdCopy getByID(String copy_id) { SqlCommand command = null; SqlDataReader reader = null; using (var cnn = new SqlConnection(sDatabaseLocatie)) { command = new SqlCommand("SELECT * FROM DvdCopy WHERE dvd_copy_id = @dvd_copy_id", cnn); command.Parameters.Add(new SqlParameter("@dvd_copy_id", copy_id)); try { cnn.Open(); reader = command.ExecuteReader(); if (reader.HasRows) { DvdCopy dvdCopy = new DvdCopy(); while (reader.Read()) { dvdCopy = createDvdCopy(reader); //Throws NoRecordException } return(dvdCopy); } } catch (Exception ex) { if (ex is NoRecordException || ex is DALException) { throw; } throw new DALException("Failed to get copy by ID", ex); } finally { if (reader != null) { reader.Close(); } if (cnn != null) { cnn.Close(); } } throw new NoRecordException("No records were found - DvdCopyDAO getCopyWithId()"); } }
/* * Updates a dvdCopy * Returns true if copy was updated, false if no copy was updated * Throws DALException if something else went wrong */ public Boolean update(DvdCopy copy) { SqlCommand command = null; using (var cnn = new SqlConnection(sDatabaseLocatie)) { command = new SqlCommand("UPDATE DvdCopy " + "SET dvd_info_id = @dvd_info_id, copy_type_id = @copy_type_id, serialnumber = @serialnumber, note = @note, in_stock = @in_stock " + "WHERE dvd_copy_id = @dvd_copy_id", cnn); command.Parameters.Add(new SqlParameter("@dvd_info_id", copy.dvdinfo.dvd_info_id)); command.Parameters.Add(new SqlParameter("@copy_type_id", copy.type.id)); command.Parameters.Add(new SqlParameter("@serialnumber", copy.serialnumber)); command.Parameters.Add(new SqlParameter("@note", copy.note)); command.Parameters.Add(new SqlParameter("@in_stock", copy.in_stock)); command.Parameters.Add(new SqlParameter("@dvd_copy_id", copy.dvd_copy_id)); try { cnn.Open(); if (command.ExecuteNonQuery() > 0) { return(true); } return(false); } catch (Exception ex) { throw new DALException("Failed to update copy", ex); } finally { if (cnn != null) { cnn.Close(); } } } }
public Boolean updateStockStatus(DvdCopy dvdCopy, bool in_stock) { return(new DvdCopyDAO().updateStockStatus(dvdCopy, in_stock)); //Throws NoRecordException || DALException }
public Boolean updateCopy(DvdCopy copy) { return(new DvdCopyDAO().update(copy)); //Throws NoRecordException || DALException }