//Convert DataTable To List method
public List <CategoriesClass> ConvertToList(DataTable dt)
{
List <CategoriesClass> Categorieslist = new List <CategoriesClass>();
for (int i = 0; i < dt.Rows.Count; i++)
{
CategoriesClass obj_Categories = new CategoriesClass();
if (Convert.ToString(dt.Rows[i]["Categoryid"]) != "")
{
obj_Categories.Categoryid = Convert.ToInt32(dt.Rows[i]["Categoryid"]);
}
if (Convert.ToString(dt.Rows[i]["Categoryname"]) != "")
{
obj_Categories.Categoryname = Convert.ToString(dt.Rows[i]["Categoryname"]);
}
if (Convert.ToString(dt.Rows[i]["Parentcategoryid"]) != "")
{
obj_Categories.Parentcategoryid = Convert.ToInt32(dt.Rows[i]["Parentcategoryid"]);
}
if (Convert.ToString(dt.Rows[i]["Categoryurl"]) != "")
{
obj_Categories.Categoryurl = Convert.ToString(dt.Rows[i]["Categoryurl"]);
}
if (Convert.ToString(dt.Rows[i]["Isfeaturedcategory"]) != "")
{
obj_Categories.Isfeaturedcategory = Convert.ToBoolean(dt.Rows[i]["Isfeaturedcategory"]);
}
if (Convert.ToString(dt.Rows[i]["Isactive"]) != "")
{
obj_Categories.Isactive = Convert.ToBoolean(dt.Rows[i]["Isactive"]);
}
if (Convert.ToString(dt.Rows[i]["Isdeleted"]) != "")
{
obj_Categories.Isdeleted = Convert.ToBoolean(dt.Rows[i]["Isdeleted"]);
}
if (Convert.ToString(dt.Rows[i]["Createdon"]) != "")
{
obj_Categories.Createdon = Convert.ToDateTime(dt.Rows[i]["Createdon"]);
}
if (Convert.ToString(dt.Rows[i]["Deletedon"]) != "")
{
obj_Categories.Deletedon = Convert.ToDateTime(dt.Rows[i]["Deletedon"]);
}
Categorieslist.Add(obj_Categories);
}
return(Categorieslist);
}
//update edited object
public CategoriesClass updateObject(CategoriesClass obj)
{
try
{
CategoriesClass oldObj = selectById(obj.Categoryid);
if (obj.Categoryname == null)
{
obj.Categoryname = oldObj.Categoryname;
}
if (obj.Parentcategoryid == null)
{
obj.Parentcategoryid = oldObj.Parentcategoryid;
}
if (obj.Categoryurl == null)
{
obj.Categoryurl = oldObj.Categoryurl;
}
if (obj.Isfeaturedcategory == null)
{
obj.Isfeaturedcategory = oldObj.Isfeaturedcategory;
}
if (obj.Isactive == null)
{
obj.Isactive = oldObj.Isactive;
}
if (obj.Isdeleted == null)
{
obj.Isdeleted = oldObj.Isdeleted;
}
if (obj.Createdon == null)
{
obj.Createdon = oldObj.Createdon;
}
if (obj.Deletedon == null)
{
obj.Deletedon = oldObj.Deletedon;
}
return(obj);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
//update data into database
public Int32?update(CategoriesClass obj)
{
try
{
obj_con.clearParameter();
createParameter(obj, DBTrans.Update);
obj_con.BeginTransaction();
obj_con.ExecuteNoneQuery("sp_Categories_update", CommandType.StoredProcedure);
obj_con.CommitTransaction();
return(obj.Categoryid = Convert.ToInt32(obj_con.getValue("@Categoryid")));
}
catch (Exception ex)
{
obj_con.RollbackTransaction();
throw new Exception("sp_Categories_update:" + ex.Message);
}
}
//Select Constructor
public CategoriesCtl(Int32?id)
{
obj_con = new ConnectionCls();
CategoriesClass obj_Cat = new CategoriesClass();
using (DataTable dt = selectdatatable(id))
{
if (dt.Rows.Count > 0)
{
obj_Cat.Categoryid = Convert.ToInt32(dt.Rows[0]["Categoryid"]);
obj_Cat.Categoryname = Convert.ToString(dt.Rows[0]["Categoryname"]);
obj_Cat.Parentcategoryid = Convert.ToInt32(dt.Rows[0]["Parentcategoryid"]);
obj_Cat.Categoryurl = Convert.ToString(dt.Rows[0]["Categoryurl"]);
obj_Cat.Isfeaturedcategory = Convert.ToBoolean(dt.Rows[0]["Isfeaturedcategory"]);
obj_Cat.Isactive = Convert.ToBoolean(dt.Rows[0]["Isactive"]);
obj_Cat.Isdeleted = Convert.ToBoolean(dt.Rows[0]["Isdeleted"]);
obj_Cat.Createdon = Convert.ToDateTime(dt.Rows[0]["Createdon"]);
obj_Cat.Deletedon = Convert.ToDateTime(dt.Rows[0]["Deletedon"]);
}
}
}
//create parameter
public void createParameter(CategoriesClass obj, DB_con.DBTrans trans)
{
try
{
obj_con.clearParameter();
if (Convert.ToString(obj.Categoryname) != "")
{
obj_con.addParameter("@Categoryname", string.IsNullOrEmpty(Convert.ToString(obj.Categoryname)) ? "" : obj.Categoryname);
}
else
{
obj_con.addParameter("@Categoryname", DBNull.Value);
}
if (Convert.ToString(obj.Parentcategoryid) != "")
{
obj_con.addParameter("@Parentcategoryid", string.IsNullOrEmpty(Convert.ToString(obj.Parentcategoryid)) ? 0 : obj.Parentcategoryid);
}
else
{
obj_con.addParameter("@Parentcategoryid", DBNull.Value);
}
if (Convert.ToString(obj.Categoryurl) != "")
{
obj_con.addParameter("@Categoryurl", string.IsNullOrEmpty(Convert.ToString(obj.Categoryurl)) ? "" : obj.Categoryurl);
}
else
{
obj_con.addParameter("@Categoryurl", DBNull.Value);
}
if (Convert.ToString(obj.Isfeaturedcategory) != "")
{
obj_con.addParameter("@Isfeaturedcategory", string.IsNullOrEmpty(Convert.ToString(obj.Isfeaturedcategory)) ? false : obj.Isfeaturedcategory);
}
else
{
obj_con.addParameter("@Isfeaturedcategory", 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.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.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.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.Categoryid) != "")
{
obj_con.addParameter("@Categoryid", Convert.ToInt32(obj.Categoryid), trans);
}
else
{
obj_con.addParameter("@Categoryid", DBNull.Value);
}
}
catch (Exception ex)
{
throw ex;
}
}