public static Newspaper getNewspaperByNewspaperId(int newspaperID)
{
DataSet data = DBClass.SelectCommand("exec spGetNewspapersByNewspaperId " + newspaperID);
if (data.Tables[0].Rows.Count == 0)
{
return(null);
}
else
{
DataRow row = data.Tables[0].Rows[0];
Newspaper news = new Newspaper();
news.NewspaperId = Convert.ToInt32(row[0].ToString());
news.Period = row[1].ToString();
news.ItemId = Convert.ToInt32(row[2].ToString());
return(news);
}
}
public static void UpdateNewspaper(Newspaper news)//Update
{
DBClass.InsertCommand("exec spUpdateNEWSPAPER " + news.NewspaperId + " , '" + news.Period + "'");
}
public static void InsertNewspaper(Newspaper news)//Insert
{
DBClass.InsertCommand("exec spInsertNEWSPAPER '" + news.Period + "', " + news.ItemId);
}
