//Convert DataTable To List method
public List <WebsiteBannerClass> ConvertToList(DataTable dt)
{
List <WebsiteBannerClass> WebsiteBannerlist = new List <WebsiteBannerClass>();
for (int i = 0; i < dt.Rows.Count; i++)
{
WebsiteBannerClass obj_WebsiteBanner = new WebsiteBannerClass();
if (Convert.ToString(dt.Rows[i]["Websitebannerid"]) != "")
{
obj_WebsiteBanner.Websitebannerid = Convert.ToInt32(dt.Rows[i]["Websitebannerid"]);
}
if (Convert.ToString(dt.Rows[i]["Bannername"]) != "")
{
obj_WebsiteBanner.Bannername = Convert.ToString(dt.Rows[i]["Bannername"]);
}
if (Convert.ToString(dt.Rows[i]["BannerImage"]) != "")
{
obj_WebsiteBanner.BannerImage = Convert.ToString(dt.Rows[i]["BannerImage"]);
}
if (Convert.ToString(dt.Rows[i]["Isactive"]) != "")
{
obj_WebsiteBanner.Isactive = Convert.ToBoolean(dt.Rows[i]["Isactive"]);
}
if (Convert.ToString(dt.Rows[i]["Sequence"]) != "")
{
obj_WebsiteBanner.Sequence = Convert.ToInt32(dt.Rows[i]["Sequence"]);
}
if (Convert.ToString(dt.Rows[i]["Bannertextline1"]) != "")
{
obj_WebsiteBanner.Bannertextline1 = Convert.ToString(dt.Rows[i]["Bannertextline1"]);
}
if (Convert.ToString(dt.Rows[i]["Bannertextline2"]) != "")
{
obj_WebsiteBanner.Bannertextline2 = Convert.ToString(dt.Rows[i]["Bannertextline2"]);
}
WebsiteBannerlist.Add(obj_WebsiteBanner);
}
return(WebsiteBannerlist);
}
//Select Constructor
public WebsiteBannerCtl(Int32?id)
{
obj_con = new ConnectionCls();
WebsiteBannerClass obj_Web = new WebsiteBannerClass();
using (DataTable dt = selectdatatable(id))
{
if (dt.Rows.Count > 0)
{
obj_Web.Websitebannerid = Convert.ToInt32(dt.Rows[0]["Websitebannerid"]);
obj_Web.Bannername = Convert.ToString(dt.Rows[0]["Bannername"]);
obj_Web.Isactive = Convert.ToBoolean(dt.Rows[0]["Isactive"]);
obj_Web.Sequence = Convert.ToInt32(dt.Rows[0]["Sequence"]);
obj_Web.Bannertextline1 = Convert.ToString(dt.Rows[0]["Bannertextline1"]);
obj_Web.Bannertextline2 = Convert.ToString(dt.Rows[0]["Bannertextline2"]);
}
}
}
//update data into database
public Int32?update(WebsiteBannerClass obj)
{
try
{
obj_con.clearParameter();
obj = updateObject(obj);
createParameter(obj, DBTrans.Update);
obj_con.BeginTransaction();
obj_con.ExecuteNoneQuery("sp_WebsiteBanner_update", CommandType.StoredProcedure);
obj_con.CommitTransaction();
return(obj.Websitebannerid = Convert.ToInt32(obj_con.getValue("@Websitebannerid")));
}
catch (Exception ex)
{
obj_con.RollbackTransaction();
throw new Exception("sp_WebsiteBanner_update:" + ex.Message);
}
}
//Convert DataTable To object method
public WebsiteBannerClass ConvertToOjbect(DataTable dt)
{
WebsiteBannerClass obj_WebsiteBanner = new WebsiteBannerClass();
for (int i = 0; i < dt.Rows.Count; i++)
{
if (Convert.ToString(dt.Rows[i]["Websitebannerid"]) != "")
{
obj_WebsiteBanner.Websitebannerid = Convert.ToInt32(dt.Rows[i]["Websitebannerid"]);
}
if (Convert.ToString(dt.Rows[i]["Bannername"]) != "")
{
obj_WebsiteBanner.Bannername = Convert.ToString(dt.Rows[i]["Bannername"]);
}
if (Convert.ToString(dt.Rows[i]["BannerImage"]) != "")
{
obj_WebsiteBanner.BannerImage = Convert.ToString(dt.Rows[i]["BannerImage"]);
}
if (Convert.ToString(dt.Rows[i]["Isactive"]) != "")
{
obj_WebsiteBanner.Isactive = Convert.ToBoolean(dt.Rows[i]["Isactive"]);
}
if (Convert.ToString(dt.Rows[i]["Sequence"]) != "")
{
obj_WebsiteBanner.Sequence = Convert.ToInt32(dt.Rows[i]["Sequence"]);
}
if (Convert.ToString(dt.Rows[i]["Bannertextline1"]) != "")
{
obj_WebsiteBanner.Bannertextline1 = Convert.ToString(dt.Rows[i]["Bannertextline1"]);
}
if (Convert.ToString(dt.Rows[i]["Bannertextline2"]) != "")
{
obj_WebsiteBanner.Bannertextline2 = Convert.ToString(dt.Rows[i]["Bannertextline2"]);
}
}
return(obj_WebsiteBanner);
}
//update edited object
public WebsiteBannerClass updateObject(WebsiteBannerClass obj)
{
try
{
WebsiteBannerClass oldObj = selectById(obj.Websitebannerid);
if (obj.Bannername == null)
{
obj.Bannername = oldObj.Bannername;
}
if (obj.BannerImage == null)
{
obj.BannerImage = oldObj.BannerImage;
}
if (obj.Isactive == null)
{
obj.Isactive = oldObj.Isactive;
}
if (obj.Sequence == null)
{
obj.Sequence = oldObj.Sequence;
}
if (obj.Bannertextline1 == null)
{
obj.Bannertextline1 = oldObj.Bannertextline1;
}
if (obj.Bannertextline2 == null)
{
obj.Bannertextline2 = oldObj.Bannertextline2;
}
return(obj);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
//create parameter
public void createParameter(WebsiteBannerClass obj, DB_con.DBTrans trans)
{
try
{
obj_con.clearParameter();
if (Convert.ToString(obj.Createdon) != "")
{
obj_con.addParameter("@createdon", string.IsNullOrEmpty(Convert.ToString(obj.Createdon)) ? Convert.ToDateTime("1900-01-01") : obj.Createdon);
}
else
{
obj_con.addParameter("@createdon", DBNull.Value);
}
if (Convert.ToString(obj.Deletedby) != "")
{
obj_con.addParameter("@deletedby", string.IsNullOrEmpty(Convert.ToString(obj.Deletedby)) ? 0 : obj.Deletedby);
}
else
{
obj_con.addParameter("@deletedby", DBNull.Value);
}
if (Convert.ToString(obj.Isdeleted) != "")
{
obj_con.addParameter("@isdeleted", string.IsNullOrEmpty(Convert.ToString(obj.Isdeleted)) ? false : obj.Isdeleted);
}
else
{
obj_con.addParameter("@isdeleted", DBNull.Value);
}
if (Convert.ToString(obj.Deletedon) != "")
{
obj_con.addParameter("@deletedon", string.IsNullOrEmpty(Convert.ToString(obj.Deletedon)) ? Convert.ToDateTime("1900-01-01") : obj.Deletedon);
}
else
{
obj_con.addParameter("@deletedon", DBNull.Value);
}
if (Convert.ToString(obj.Bannername) != "")
{
obj_con.addParameter("@Bannername", string.IsNullOrEmpty(Convert.ToString(obj.Bannername)) ? "" : obj.Bannername);
}
else
{
obj_con.addParameter("@Bannername", DBNull.Value);
}
if (Convert.ToString(obj.BannerImage) != "")
{
obj_con.addParameter("@BannerImage", string.IsNullOrEmpty(Convert.ToString(obj.BannerImage)) ? "" : obj.BannerImage);
}
else
{
obj_con.addParameter("@BannerImage", DBNull.Value);
}
if (Convert.ToString(obj.Isactive) != "")
{
obj_con.addParameter("@Isactive", string.IsNullOrEmpty(Convert.ToString(obj.Isactive)) ? false : obj.Isactive);
}
else
{
obj_con.addParameter("@Isactive", DBNull.Value);
}
if (Convert.ToString(obj.Bannertextline1) != "")
{
obj_con.addParameter("@Bannertextline1", string.IsNullOrEmpty(Convert.ToString(obj.Bannertextline1)) ? "" : obj.Bannertextline1);
}
else
{
obj_con.addParameter("@Bannertextline1", DBNull.Value);
}
if (Convert.ToString(obj.Bannertextline2) != "")
{
obj_con.addParameter("@Bannertextline2", string.IsNullOrEmpty(Convert.ToString(obj.Bannertextline2)) ? "" : obj.Bannertextline2);
}
else
{
obj_con.addParameter("@Bannertextline2", DBNull.Value);
}
if (Convert.ToString(obj.Sequence) != "")
{
obj_con.addParameter("@Sequence", Convert.ToInt32(obj.Sequence));
}
else
{
obj_con.addParameter("@Sequence", DBNull.Value);
}
if (Convert.ToString(obj.Websitebannerid) != "")
{
obj_con.addParameter("@Websitebannerid", Convert.ToInt32(obj.Websitebannerid), trans);
}
else
{
obj_con.addParameter("@Websitebannerid", DBNull.Value);
}
}
catch (Exception ex)
{
throw ex;
}
}