public Tracker.Entity.web.User GetUserByPhoneOrByMail(string phone, string email)
{
DBConnect db = new DBConnect();
DataSet ds = db.Select(string.Format("select * from tblUser where Phone='{0}' or Email='{0}'", phone, email));
Tracker.Entity.web.User user = null;
if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
user = new Entity.web.User
{
uid = int.Parse(ds.Tables[0].Rows[0]["uid"].ToString()),
details = ds.Tables[0].Rows[0]["details"].ToString(),
Email = ds.Tables[0].Rows[0]["Email"].ToString(),
Phone = ds.Tables[0].Rows[0]["Phone"].ToString(),
suspDt = ds.Tables[0].Rows[0]["suspDt"].ToString() != "" ?
DateTime.Parse(ds.Tables[0].Rows[0]["suspDt"].ToString()) : DateTime.MinValue
}
}
;
return(user);
}
public Tracker.Entity.web.User GetUser(int id)
{
DBConnect db = new DBConnect();
DataSet ds = db.Select("select * from tblUser where uid=" + id.ToString());
Tracker.Entity.web.User user = null;
if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
user = new Entity.web.User
{
uid = int.Parse(ds.Tables[0].Rows[0]["uid"].ToString()),
details = ds.Tables[0].Rows[0]["details"].ToString(),
Email = ds.Tables[0].Rows[0]["Email"].ToString(),
Phone = ds.Tables[0].Rows[0]["Phone"].ToString(),
suspDt = ds.Tables[0].Rows[0]["suspDt"].ToString() != "" ?
DateTime.Parse(ds.Tables[0].Rows[0]["suspDt"].ToString()) : DateTime.MinValue
}
}
;
return(user);
}
