//Convert DataTable To object method
public BusinessGalleryClass ConvertToOjbect(DataTable dt)
{
BusinessGalleryClass obj_BusinessGallery = new BusinessGalleryClass();
for (int i = 0; i < dt.Rows.Count; i++)
{
if (Convert.ToString(dt.Rows[i]["Businessgalleryid"]) != "")
{
obj_BusinessGallery.Businessgalleryid = Convert.ToInt32(dt.Rows[i]["Businessgalleryid"]);
}
if (Convert.ToString(dt.Rows[i]["Businessid"]) != "")
{
obj_BusinessGallery.Businessid = Convert.ToInt32(dt.Rows[i]["Businessid"]);
}
if (Convert.ToString(dt.Rows[i]["Imagename"]) != "")
{
obj_BusinessGallery.Imagename = Convert.ToString(dt.Rows[i]["Imagename"]);
}
if (Convert.ToString(dt.Rows[i]["Isactive"]) != "")
{
obj_BusinessGallery.Isactive = Convert.ToBoolean(dt.Rows[i]["Isactive"]);
}
if (Convert.ToString(dt.Rows[i]["Sequence"]) != "")
{
obj_BusinessGallery.Sequence = Convert.ToInt32(dt.Rows[i]["Sequence"]);
}
}
return(obj_BusinessGallery);
}
//update edited object
public BusinessGalleryClass updateObject(BusinessGalleryClass obj)
{
try
{
BusinessGalleryClass oldObj = selectById(obj.Businessgalleryid);
if (obj.Businessid == null)
{
obj.Businessid = oldObj.Businessid;
}
if (obj.Imagename == null)
{
obj.Imagename = oldObj.Imagename;
}
if (obj.Isactive == null)
{
obj.Isactive = oldObj.Isactive;
}
if (obj.Sequence == null)
{
obj.Sequence = oldObj.Sequence;
}
return(obj);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
//create parameter
public void createParameter(BusinessGalleryClass obj, DB_con.DBTrans trans)
{
try
{
obj_con.clearParameter();
if (Convert.ToString(obj.Businessid) != "")
{
obj_con.addParameter("@Businessid", string.IsNullOrEmpty(Convert.ToString(obj.Businessid)) ? 0 : obj.Businessid);
}
else
{
obj_con.addParameter("@Businessid", DBNull.Value);
}
if (Convert.ToString(obj.Imagename) != "")
{
obj_con.addParameter("@Imagename", string.IsNullOrEmpty(Convert.ToString(obj.Imagename)) ? "" : obj.Imagename);
}
else
{
obj_con.addParameter("@Imagename", 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.Sequence) != "")
{
obj_con.addParameter("@Sequence", string.IsNullOrEmpty(Convert.ToString(obj.Sequence)) ? 0 : obj.Sequence);
}
else
{
obj_con.addParameter("@Sequence", DBNull.Value);
}
if (Convert.ToString(obj.Businessgalleryid) != "")
{
obj_con.addParameter("@Businessgalleryid", Convert.ToInt32(obj.Businessgalleryid), trans);
}
else
{
obj_con.addParameter("@Businessgalleryid", DBNull.Value);
}
}
catch (Exception ex)
{
throw ex;
}
}
//Select Constructor
public BusinessGalleryCtl(Int32?id)
{
obj_con = new ConnectionCls();
BusinessGalleryClass obj_Bus = new BusinessGalleryClass();
using (DataTable dt = selectdatatable(id))
{
if (dt.Rows.Count > 0)
{
obj_Bus.Businessgalleryid = Convert.ToInt32(dt.Rows[0]["Businessgalleryid"]);
obj_Bus.Businessid = Convert.ToInt32(dt.Rows[0]["Businessid"]);
obj_Bus.Imagename = Convert.ToString(dt.Rows[0]["Imagename"]);
obj_Bus.Isactive = Convert.ToBoolean(dt.Rows[0]["Isactive"]);
obj_Bus.Sequence = Convert.ToInt32(dt.Rows[0]["Sequence"]);
}
}
}
//insert data into database
public Int32?insert(BusinessGalleryClass obj)
{
try
{
obj.Businessgalleryid = 0;
obj_con.clearParameter();
createParameter(obj, DBTrans.Insert);
obj_con.BeginTransaction();
obj_con.ExecuteNoneQuery("sp_BusinessGallery_insert", CommandType.StoredProcedure);
obj_con.CommitTransaction();
return(obj.Businessgalleryid = Convert.ToInt32(obj_con.getValue("@Businessgalleryid")));
}
catch (Exception ex)
{
obj_con.RollbackTransaction();
throw new Exception("sp_BusinessGallery_insert:" + ex.Message);
}
}
//Convert DataTable To List method
public List <BusinessGalleryClass> ConvertToList(DataTable dt)
{
List <BusinessGalleryClass> BusinessGallerylist = new List <BusinessGalleryClass>();
for (int i = 0; i < dt.Rows.Count; i++)
{
BusinessGalleryClass obj_BusinessGallery = new BusinessGalleryClass();
if (Convert.ToString(dt.Rows[i]["Businessgalleryid"]) != "")
{
obj_BusinessGallery.Businessgalleryid = Convert.ToInt32(dt.Rows[i]["Businessgalleryid"]);
}
if (Convert.ToString(dt.Rows[i]["Businessid"]) != "")
{
obj_BusinessGallery.Businessid = Convert.ToInt32(dt.Rows[i]["Businessid"]);
}
if (Convert.ToString(dt.Rows[i]["Imagename"]) != "")
{
obj_BusinessGallery.Imagename = Convert.ToString(dt.Rows[i]["Imagename"]);
}
if (Convert.ToString(dt.Rows[i]["Isactive"]) != "")
{
obj_BusinessGallery.Isactive = Convert.ToBoolean(dt.Rows[i]["Isactive"]);
}
if (Convert.ToString(dt.Rows[i]["Sequence"]) != "")
{
obj_BusinessGallery.Sequence = Convert.ToInt32(dt.Rows[i]["Sequence"]);
}
BusinessGallerylist.Add(obj_BusinessGallery);
}
return(BusinessGallerylist);
}
