//Convert DataTable To List method
//Convert DataTable To object method
public AdminClass ConvertToOjbect(DataTable dt)
{
AdminClass obj_Admin = new AdminClass();
for (int i = 0; i < dt.Rows.Count; i++)
{
if (Convert.ToString(dt.Rows[i]["Adminid"]) != "")
{
obj_Admin.Adminid = Convert.ToInt32(dt.Rows[i]["Adminid"]);
}
if (Convert.ToString(dt.Rows[i]["Name"]) != "")
{
obj_Admin.Name = Convert.ToString(dt.Rows[i]["Name"]);
}
if (Convert.ToString(dt.Rows[i]["Username"]) != "")
{
obj_Admin.Username = Convert.ToString(dt.Rows[i]["Username"]);
}
if (Convert.ToString(dt.Rows[i]["Email"]) != "")
{
obj_Admin.Email = Convert.ToString(dt.Rows[i]["Email"]);
}
if (Convert.ToString(dt.Rows[i]["Password"]) != "")
{
obj_Admin.Password = Convert.ToString(dt.Rows[i]["Password"]);
}
if (Convert.ToString(dt.Rows[i]["Isactive"]) != "")
{
obj_Admin.Isactive = Convert.ToBoolean(dt.Rows[i]["Isactive"]);
}
if (Convert.ToString(dt.Rows[i]["Isdeleted"]) != "")
{
obj_Admin.Isdeleted = Convert.ToBoolean(dt.Rows[i]["Isdeleted"]);
}
if (Convert.ToString(dt.Rows[i]["Createdon"]) != "")
{
obj_Admin.Createdon = Convert.ToDateTime(dt.Rows[i]["Createdon"]);
}
if (Convert.ToString(dt.Rows[i]["Deletedon"]) != "")
{
obj_Admin.Deletedon = Convert.ToDateTime(dt.Rows[i]["Deletedon"]);
}
}
return(obj_Admin);
}
//update edited object
public AdminClass updateObject(AdminClass obj)
{
try
{
AdminClass oldObj = selectById(obj.Adminid);
if (obj.Name == null)
{
obj.Name = oldObj.Name;
}
if (obj.Username == null)
{
obj.Username = oldObj.Username;
}
if (obj.Email == null)
{
obj.Email = oldObj.Email;
}
if (obj.Password == null)
{
obj.Password = oldObj.Password;
}
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);
}
}
// Login
public DataTable CheckUserNamePass(AdminClass obj)
{
try
{
obj_con.clearParameter();
obj_con.BeginTransaction();
obj_con.addParameter("@Email", obj.Email);
obj_con.addParameter("@Password", obj.Password);
obj_con.ExecuteNoneQuery("sp_admin_CheckUserNamePassLogin", CommandType.StoredProcedure);
obj_con.CommitTransaction();
return(ConvertDatareadertoDataTable(obj_con.ExecuteReader("sp_admin_CheckUserNamePassLogin", CommandType.StoredProcedure)));
}
catch (Exception ex)
{
obj_con.RollbackTransaction();
throw new Exception("sp_admin_CheckUserNamePassLogin");
}
}
//update data into database
public Int32?update(AdminClass obj)
{
try
{
obj_con.clearParameter();
obj = updateObject(obj);
createParameter(obj, DBTrans.Update);
obj_con.BeginTransaction();
obj_con.ExecuteNoneQuery("sp_Admin_update", CommandType.StoredProcedure);
obj_con.CommitTransaction();
return(obj.Adminid = Convert.ToInt32(obj_con.getValue("@Adminid")));
}
catch (Exception ex)
{
obj_con.RollbackTransaction();
throw new Exception("sp_Admin_update:" + ex.Message);
}
}
//Select Constructor
public AdminCtl(Int32?id)
{
obj_con = new ConnectionCls();
AdminClass obj_Adm = new AdminClass();
using (DataTable dt = selectdatatable(id))
{
if (dt.Rows.Count > 0)
{
obj_Adm.Adminid = Convert.ToInt32(dt.Rows[0]["Adminid"]);
obj_Adm.Name = Convert.ToString(dt.Rows[0]["Name"]);
obj_Adm.Username = Convert.ToString(dt.Rows[0]["Username"]);
obj_Adm.Email = Convert.ToString(dt.Rows[0]["Email"]);
obj_Adm.Password = Convert.ToString(dt.Rows[0]["Password"]);
obj_Adm.Isactive = Convert.ToBoolean(dt.Rows[0]["Isactive"]);
obj_Adm.Isdeleted = Convert.ToBoolean(dt.Rows[0]["Isdeleted"]);
obj_Adm.Createdon = Convert.ToDateTime(dt.Rows[0]["Createdon"]);
obj_Adm.Deletedon = Convert.ToDateTime(dt.Rows[0]["Deletedon"]);
}
}
}
//create parameter
public void createParameter(AdminClass obj, DB_con.DBTrans trans)
{
try
{
obj_con.clearParameter();
if (Convert.ToString(obj.Name) != "")
{
obj_con.addParameter("@Name", string.IsNullOrEmpty(Convert.ToString(obj.Name)) ? "" : obj.Name);
}
else
{
obj_con.addParameter("@Name", DBNull.Value);
}
if (Convert.ToString(obj.Username) != "")
{
obj_con.addParameter("@Username", string.IsNullOrEmpty(Convert.ToString(obj.Username)) ? "" : obj.Username);
}
else
{
obj_con.addParameter("@Username", DBNull.Value);
}
if (Convert.ToString(obj.Email) != "")
{
obj_con.addParameter("@Email", string.IsNullOrEmpty(Convert.ToString(obj.Email)) ? "" : obj.Email);
}
else
{
obj_con.addParameter("@Email", DBNull.Value);
}
if (Convert.ToString(obj.Password) != "")
{
obj_con.addParameter("@Password", string.IsNullOrEmpty(Convert.ToString(obj.Password)) ? "" : obj.Password);
}
else
{
obj_con.addParameter("@Password", 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.Adminid) != "")
{
obj_con.addParameter("@Adminid", Convert.ToInt32(obj.Adminid), trans);
}
else
{
obj_con.addParameter("@Adminid", DBNull.Value);
}
}
catch (Exception ex)
{
throw ex;
}
}
