public Publisher GetPublisherDeatils(int SpecialID)
{
Publisher publisher = null;
SqlParameter[] Params = { new SqlParameter("@PublisherID", SpecialID) };
using (DataTable table = DataProvider.ExecuteParamatizedSelectCommand("sp_ViewPublisher",
CommandType.StoredProcedure, Params))
{
if (table.Rows.Count == 1)
{
DataRow row = table.Rows[0];
publisher = new Publisher();
publisher.PublisherID = Convert.ToInt32(row["PublisherID"]);
publisher.Name = row["Name"].ToString();
}
}
return publisher;
}
public List<Publisher> CheckDuplicatePublisher(string name)
{
List<Publisher> publisherList = null;
SqlParameter[] Params = { new SqlParameter("@Name", name) };
using (DataTable table = DataProvider.ExecuteParamatizedSelectCommand("sp_CheckDuplicatePublisher", CommandType.StoredProcedure, Params))
{
if(table.Rows.Count > 0)
{
publisherList = new List<Publisher>();
foreach (DataRow row in table.Rows)
{
Publisher publisher = new Publisher();
publisher.PublisherID = Convert.ToInt32(row["PublisherID"]);
publisher.Name = row["Name"].ToString();
publisherList.Add(publisher);
}
}
}
return publisherList;
}
public List<Publisher> GetPublisherList()
{
List<Publisher> PublisherList = null;
using (DataTable table = DataProvider.ExecuteSelectCommand("sp_ViewAllPublishers", //*Note
CommandType.StoredProcedure))
{
if (table.Rows.Count > 0)
{
PublisherList = new List<Publisher>();
foreach (DataRow row in table.Rows)
{
Publisher publisher = new Publisher();
publisher.PublisherID = Convert.ToInt32(row["PublisherID"]);
publisher.Name = row["Publisher"].ToString();
PublisherList.Add(publisher);
}
}
}
return PublisherList;
}
public bool AddPublisher(Publisher publisher)
{
PublisherHandler myHandler = new PublisherHandler(); return myHandler.InsertPublisher(publisher);
}
public bool UpdatePublisher(Publisher publisher)
{
PublisherHandler myHandler = new PublisherHandler(); return myHandler.UpdatePublisher(publisher);
}
public bool InsertPublisher(Publisher publisher)
{
SqlParameter[] Params = new SqlParameter[]
{
new SqlParameter("@Name", publisher.Name)
};
return DataProvider.ExecuteNonQuery("sp_InsertPublisher", CommandType.StoredProcedure,
Params);
}
public bool UpdatePublisher(Publisher publisher)
{
SqlParameter[] Params = new SqlParameter[]
{
new SqlParameter("@PublisherID", publisher.PublisherID ),
new SqlParameter("@Name", publisher.Name),
};
return DataProvider.ExecuteNonQuery("sp_UpdatePublisher", CommandType.StoredProcedure,
Params);
}
