private EntityHandler.User ConvertToObject(DataRow row)
{
EntityHandler.User obj = new EntityHandler.User();
try
{
obj.CreateDate = Convert.ToDateTime(row["CreateDate"].ToString());
obj.CreateUser = Convert.ToInt32(row["CreateUser"].ToString());
obj.UserID = Convert.ToInt32(row["UserID"].ToString());
obj.HostID = row["HostID"].ToString();
obj.ModifiedDate = Convert.ToDateTime(row["ModifiedDate"].ToString());
obj.ModifiedUser = Convert.ToInt32(row["ModifiedUser"].ToString());
obj.Status = Convert.ToInt32(row["Status"].ToString());
obj.Designation = row["Designation"].ToString();
obj.FName = row["FName"].ToString();
obj.LName = row["LName"].ToString();
obj.UserName = row["Username"].ToString();
obj.Password = row["Password"].ToString();
obj.LastVisit = Convert.ToDateTime(row["LastVisit"].ToString());
}
catch (Exception ex)
{ }
return(obj);
}
private EntityHandler.User ConvertToObject(DataRow row)
{
EntityHandler.User obj = new EntityHandler.User();
try
{
obj.CreateDate = Convert.ToDateTime(row["CreateDate"].ToString());
obj.CreateUser = Convert.ToInt32(row["CreateUser"].ToString());
obj.UserID = Convert.ToInt32(row["UserID"].ToString());
obj.HostID = row["HostID"].ToString();
obj.ModifiedDate = Convert.ToDateTime(row["ModifiedDate"].ToString());
obj.ModifiedUser = Convert.ToInt32(row["ModifiedUser"].ToString());
obj.Status = Convert.ToInt32(row["Status"].ToString());
obj.Designation = row["Designation"].ToString();
obj.FName = row["FName"].ToString();
obj.LName = row["LName"].ToString();
obj.UserName = row["Username"].ToString();
obj.Password = row["Password"].ToString();
obj.LastVisit = Convert.ToDateTime(row["LastVisit"].ToString());
}
catch (Exception ex)
{ }
return obj;
}
public bool Delete(EntityHandler.User obj)
{
bool Status = false;
try
{
Status = new DataAccessHandler.User().Delete(obj);
}
catch (Exception ex)
{ }
return(Status);
}
public DataTable SelectAll(EntityHandler.User obj)
{
DataTable dt = new DataTable();
try
{
string SqlCommand = "";
dt = new DALBase().Select(SqlCommand);
}
catch (Exception ex)
{ }
return(dt);
}
public bool Delete(EntityHandler.User obj)
{
bool Status = false;
try
{
string SqlCommand = "";
Status = new DALBase().Update(SqlCommand);
}
catch (Exception ex)
{ }
return(Status);
}
public List <EntityHandler.User> SelectAll(EntityHandler.User obj)
{
List <EntityHandler.User> listobj = new List <EntityHandler.User>();
try
{
DataTable dt = new DataAccessHandler.User().SelectAll(obj);
for (int i = 0; i < dt.Rows.Count; i++)
{
listobj.Add(ConvertToObject(dt.Rows[i]));
}
}
catch (Exception ex)
{ }
return(listobj);
}
