public PublisherDTO GetPublisherById(int publisherId) { PublisherDTO publisherDto = null; try { SqlDataReader reader = ConnectionManager.GetCommand("SP0401PI", new Dictionary<string, SqlDbType>() { { "@Param1", SqlDbType.Int } }, new List<object>() { publisherId }).ExecuteReader(); if (reader.Read()) { publisherDto = new PublisherDTO(); publisherDto.PublisherId = int.Parse(reader["PublisherID"].ToString()); publisherDto.PublisherName = reader["PublisherName"].ToString(); publisherDto.CreatedDate = (DateTime)reader["CreatedDate"]; publisherDto.UpdatedDate = (DateTime)reader["UpdatedDate"]; } reader.Close(); } catch (Exception e) { Log.Error("Error at PublisherDAO - GetPublisherByID", e); return null; } return publisherDto; }
public List<PublisherDTO> GetAllPublisher() { List<PublisherDTO> list = new List<PublisherDTO>(); try { SqlDataReader reader = ConnectionManager.GetCommand("SP0401ALL", new Dictionary<string, SqlDbType>() { }, new List<object>() { }).ExecuteReader(); while (reader.Read()) { PublisherDTO publisherDto = new PublisherDTO(); publisherDto.PublisherId = int.Parse(reader["PublisherID"].ToString()); publisherDto.PublisherName = reader["PublisherName"].ToString(); publisherDto.CreatedDate = (DateTime)reader["CreatedDate"]; publisherDto.UpdatedDate = (DateTime)reader["UpdatedDate"]; list.Add(publisherDto); } reader.Close(); } catch (Exception e) { Log.Error("Error at AuthorDAO - GetAllPublisher", e); return null; } return list; }
public CatalogueDTO GetCatalogueById(String isbn) { CatalogueDTO catalogueDto = null; try { SqlDataReader reader = ConnectionManager.GetCommand("SP0101ISBN", new Dictionary<string, SqlDbType>() { { "@Param1", SqlDbType.NVarChar } }, new List<object>() { isbn }).ExecuteReader(); if (reader.Read()) { catalogueDto = new CatalogueDTO(); PublisherDTO publisherDto = new PublisherDTO(); CategoryDTO categoryDto = new CategoryDTO(); catalogueDto.ISBN = reader["ISBN"].ToString(); catalogueDto.Title = reader["Title"].ToString(); // add code for get data publisherDto.PublisherId = int.Parse(reader["PublisherID"].ToString()); catalogueDto.Publisher = publisherDto; catalogueDto.ShortDescription = reader["ShortDescription"].ToString(); // add code for get data categoryDto.CategoryId = reader["CategoryID"].ToString(); catalogueDto.Category = categoryDto; catalogueDto.Language = reader["Language"].ToString(); catalogueDto.Year = int.Parse(reader["Year"].ToString()); catalogueDto.ExpandLimit = int.Parse(reader["ExpandLimit"].ToString()); catalogueDto.ExpandDateLimit = int.Parse(reader["ExpandDateLimit"].ToString()); catalogueDto.NumberOfCopies = int.Parse(reader["NumberOfCopies"].ToString()); catalogueDto.AvailableCopies = int.Parse(reader["AvailableCopies"].ToString()); catalogueDto.Price = float.Parse(reader["Price"].ToString()); catalogueDto.Image = reader["Image"].ToString(); catalogueDto.HitTime = int.Parse(reader["HitTime"].ToString()); catalogueDto.RentalTime = int.Parse(reader["RentalTime"].ToString()); catalogueDto.CreatedDate = (DateTime) reader["CreatedDate"]; catalogueDto.UpdatedDate = (DateTime) reader["UpdatedDate"]; } reader.Close(); } catch (Exception e) { Log.Error("Error at CatalogueDAO - GetCatalogueByID", e); return null; } return catalogueDto; }
public int DeletePublisher(PublisherDTO publisher) { try { ConnectionManager.GetCommand("SP0404", new Dictionary<string, SqlDbType>() { {"@Param1", SqlDbType.Int} }, new List<object>() { publisher.PublisherId }).ExecuteNonQuery(); } catch (Exception e) { Log.Error("Error at PublisherDAO - DeletePublisher", e); return 0; } return 1; }
private void btnSave_Click(object sender, EventArgs e) { PublisherBUS bus = new PublisherBUS(); if (String.IsNullOrEmpty(txtPublisherID.Text)) { if (String.IsNullOrEmpty(txtPublisherName.Text)) { MessageBox.Show(Resources.ADD_NULL_PUBLISHER_NAME); } else { PublisherDTO publisherDTO = new PublisherDTO() { PublisherName = txtPublisherName.Text, CreatedDate = DateTime.Now, UpdatedDate = DateTime.Now }; if (bus.InsertPublisher(publisherDTO) == 1) { MessageBox.Show(Resources.ADD_PUBLISHER_SUCCESS); lst.Add(publisherDTO); grdPublisher.RefreshDataSource(); } else { MessageBox.Show(Resources.ADD_PUBLISHER_FAIL); } } } else { if (String.IsNullOrEmpty(txtPublisherName.Text)) { MessageBox.Show(Resources.ADD_NULL_PUBLISHER_NAME); } else { PublisherDTO publisherDTO = (PublisherDTO)grvPublisher.GetFocusedRow(); publisherDTO.PublisherName = txtPublisherName.Text; if (bus.UpdatePublisher(publisherDTO) == 1) { MessageBox.Show(Resources.UPDATE_PUBLISHER_SUCCESS); grdPublisher.RefreshDataSource(); } else { MessageBox.Show(Resources.UPDATE_PUBLISHER_FAIL); } } } }
public int UpdatePublisher(PublisherDTO publisher) { PublisherDAO dao = new PublisherDAO(); return dao.UpdatePublisher(publisher); }
public int InsertPublisher(PublisherDTO publisher) { PublisherDAO dao = new PublisherDAO(); return dao.InsertPublisher(publisher); }
public int DeletePublisher(PublisherDTO publisher) { PublisherDAO dao = new PublisherDAO(); return dao.DeletePublisher(publisher); }
public int UpdatePublisher(PublisherDTO publisher) { publisher.UpdatedDate = DateTime.Now; try { ConnectionManager.GetCommand("SP0403", new Dictionary<string, SqlDbType>() { {"@Param1", SqlDbType.Int}, {"@Param2", SqlDbType.NVarChar}, {"@Param3", SqlDbType.DateTime}, {"@Param4", SqlDbType.DateTime} }, new List<object>() { publisher.PublisherId, publisher.PublisherName, publisher.CreatedDate, publisher.UpdatedDate }).ExecuteNonQuery(); } catch (Exception e) { Log.Error("Error at PublisherDAO - UpdatePublisher", e); return 0; } return 1; }
public List<PublisherDTO> SearchPublisher(string info) { List<PublisherDTO> list=new List<PublisherDTO>(); PublisherDTO publisherDTO; try { SqlDataReader reader = ConnectionManager.GetCommand("sp0005publisher", new Dictionary<string, SqlDbType>() { { "@publisher", SqlDbType.NVarChar } }, new List<object>() { info }).ExecuteReader(); while (reader.Read()) { publisherDTO = new PublisherDTO(); publisherDTO.PublisherId = int.Parse(reader["publisherID"].ToString()); publisherDTO.PublisherName = reader["publisherName"].ToString(); publisherDTO.CreatedDate = (DateTime)reader["CreatedDate"]; publisherDTO.UpdatedDate = (DateTime)reader["UpdatedDate"]; list.Add(publisherDTO); } reader.Close(); } catch (Exception e) { Log.Logger.Error("Error at AuthorDAO - GetAuthorByID", e); return null; } return list; }