public Users GetByIdOrUsername(string pIdOrUsername) { Users user = new Users(); DataSet dataset = new DataSet(); string queryStr = string.Format("SELECT `UserId`, `Pwd`, `Status`, `RoleId` FROM user WHERE UserId = '{0}'", pIdOrUsername); PosService.DataQuery(Username, Password, queryStr, ref dataset, "x", ref errorString); if (!string.IsNullOrEmpty(errorString)) { return(null); } if (dataset.Tables["x"].Rows.Count > 0) { user.UserId = dataset.Tables["x"].Rows[0][UserColumn.UserId].ToString(); user.Pwd = dataset.Tables["x"].Rows[0][UserColumn.Pwd].ToString(); //user.LastLogin = dataset.Tables["x"].Rows[0][UserColumn.LastLogin].ToString(); user.Status = dataset.Tables["x"].Rows[0][UserColumn.Status].ToString(); //user.CreatedBy = dataset.Tables["x"].Rows[0][UserColumn.CreatedBy].ToString(); //user.CreatedDate = dataset.Tables["x"].Rows[0][UserColumn.CreatedDate].ToString(); //user.ModifiedBy = dataset.Tables["x"].Rows[0][UserColumn.ModifiedBy].ToString(); //user.ModifiedDate = dataset.Tables["x"].Rows[0][UserColumn.ModifiedDate].ToString(); user.RoleId = dataset.Tables["x"].Rows[0][UserColumn.RoleId].ToString(); } else { user = null; } return(user); }
public DataTable GetRoleOfUser(string roleId) { string queryStr = String.Format("SELECT * FROM role WHERE " + RoleColumn.RoleId + " = '{0}'", roleId); DataSet dataset = new DataSet(); PosService.DataQuery(Username, Password, queryStr, ref dataset, "x", ref errorString); if (string.IsNullOrEmpty(errorString)) { return(dataset.Tables["x"]); } else { return(null); } }
public DataTable GetRoles() { DataTable res = new DataTable(); DataSet ds = new DataSet(); string queryStr = "UPDATE role SET"; PosService.DataQuery(Username, Password, queryStr, ref ds, "roles", ref errorString); if (string.IsNullOrEmpty(errorString)) { res = ds.Tables[0]; } else { res = null; } return(res); }
/// <summary> /// Get all Users /// </summary> /// <returns></returns> public DataTable GetUsers(Users user) { DataTable dtUsers = new DataTable(); DataSet dataset = new DataSet(); string queryStr = "SELECT * FROM user"; PosService.DataQuery(user.UserId, user.Pwd.ToString(), queryStr, ref dataset, "x", ref errorString); if (!string.IsNullOrEmpty(errorString)) { return(null); } if (dataset.Tables["x"].Rows.Count > 0) { dtUsers = dataset.Tables["x"]; } return(dtUsers); }