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); }