public void Update_Row_View(Common.AdvertizingDatum dm)
{
SqlParameter[] prms = new SqlParameter[2];
prms[0] = new SqlParameter("@id", dm.Id);
prms[1] = new SqlParameter("@row_view", dm.Row_View);
sh.ExecuteNonQuery("shop_advertizing_update_row_view", prms);
}
public bool Check_Row_View_Exist(Common.AdvertizingDatum dm)
{
if (dl.Check_Row_View_Exist(dm).Rows.Count > 1)
{
return(true);
}
else
{
return(false);
}
}
public void Update(Common.AdvertizingDatum dm)
{
SqlParameter[] prms = new SqlParameter[5];
prms[0] = new SqlParameter("@title", dm.Title);
prms[1] = new SqlParameter("@text", dm.Text);
prms[2] = new SqlParameter("@id", dm.Id);
prms[3] = new SqlParameter("@id_admin", dm.Id_Admin);
prms[4] = new SqlParameter("@show_page", dm.Show_Page);
sh.ExecuteNonQuery("shop_advertizing_Update", prms);
}
public void Insert(Common.AdvertizingDatum dm)
{
SqlParameter[] prms = new SqlParameter[6];
prms[0] = new SqlParameter("@title", dm.Title);
prms[1] = new SqlParameter("@text", dm.Text);
prms[2] = new SqlParameter("@date_send", dm.Date_Send);
prms[3] = new SqlParameter("@id_admin", dm.Id_Admin);
prms[4] = new SqlParameter("@show_page", dm.Show_Page);
prms[5] = new SqlParameter("@row_view", dm.Row_View);
sh.ExecuteNonQuery("shop_advertizing_insert", prms);
}
public bool Select_Advertizing_Number(Common.AdvertizingDatum dm)
{
DataTable dt = dl.Select_Advertizing_Number(dm);
if (dt.Rows.Count > 0)
{
dm.Text = dt.Rows[0]["text"].ToString();
dm.Show_Page = dt.Rows[0]["Show_Page"].ToString();
return(true);
}
else
{
return(false);
}
}
public void Insert(Common.AdvertizingDatum dm)
{
dl.Insert(dm);
}
public DataTable advertizing_show_check(Common.AdvertizingDatum dm)
{
return(dl.advertizing_show_check(dm));
}
public DataTable Select_page_One(Common.AdvertizingDatum dm)
{
return(dl.Select_page_One(dm));
}
public void Update(Common.AdvertizingDatum dm)
{
dl.Update(dm);
}
public void Update_Row_View(Common.AdvertizingDatum dm)
{
dl.Update_Row_View(dm);
}
public void Delete(Common.AdvertizingDatum dm)
{
dl.Delete(dm);
}
public DataTable advertizing_show_check(Common.AdvertizingDatum dm)
{
SqlParameter[] prms = new SqlParameter[1];
prms[0] = new SqlParameter("@row_view", dm.Row_View);
return(sh.ExecuteDataSet("shop_advertizing_check_show_page", prms));
}
public DataTable Select_Advertizing_Number(Common.AdvertizingDatum dm)
{
SqlParameter[] prms = new SqlParameter[1];
prms[0] = new SqlParameter("@row_view", dm.Row_View);
return(sh.ExecuteDataSet("shop_advertizing_select_row_view", prms));
}
public DataTable Select_page_One(Common.AdvertizingDatum dm)
{
SqlParameter[] prms = new SqlParameter[1];
prms[0] = new SqlParameter("@id_page", dm.Id);
return(sh.ExecuteDataSet("shop_advertizing_select_one", prms));
}
public void Delete(Common.AdvertizingDatum dm)
{
SqlParameter[] prms = new SqlParameter[1];
prms[0] = new SqlParameter("@id", dm.Id);
sh.ExecuteNonQuery("shop_advertizing_delete", prms);
}
