public Common.Setting Select()
{
Common.Setting inf = new Common.Setting();
DataTable tbl = new DAL.Setting().SelectAll();
inf.google_search = "";
inf.help_shoping = "";
inf.webgozar = "";
if (tbl.Rows.Count > 0)
{
if (tbl.Rows[0]["google_search"] != null)
{
inf.google_search = tbl.Rows[0]["google_search"].ToString();
}
if (tbl.Rows[0]["help_shoping"] != null)
{
inf.help_shoping = tbl.Rows[0]["help_shoping"].ToString();
}
if (tbl.Rows[0]["webgozar"] != null)
{
inf.webgozar = tbl.Rows[0]["webgozar"].ToString();
}
}
return(inf);
}
private void Update(Common.Setting inf)
{
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("help_shoping", inf.help_shoping),
new SqlParameter("webgozar", inf.webgozar),
new SqlParameter("google_search", inf.google_search)
};
ExecuteNonQuery("shop_setting_Update", parameters);
}
public void Save(Common.Setting inf)
{
if (SelectAll().Rows.Count == 0)
{
Insert(inf);
}
else
{
Update(inf);
}
}
public void Save(Common.Setting inf)
{
if (inf.google_search == null)
{
inf.google_search = "";
}
if (inf.help_shoping == null)
{
inf.help_shoping = "";
}
if (inf.webgozar == null)
{
inf.webgozar = "";
}
new DAL.Setting().Save(inf);
}
