public static bool IsApprover(TransmittalUserType pUserType, string pUsername) { bool blnReturn = false; if (pUserType == TransmittalUserType.GroupHead || pUserType == TransmittalUserType.SpecialDispatchApprover || pUserType == TransmittalUserType.SpecialDispatchApprover2) { using (SqlConnection cn = new SqlConnection(clsSystemConfigurations.ConnectionStringTransmittal)) { SqlCommand cmd = cn.CreateCommand(); if (pUserType == TransmittalUserType.GroupHead) { cmd.CommandText = "SELECT userlvl FROM CIS.TransmittalApprover WHERE userlvl='grouphead' AND username='******'"; } else if (pUserType == TransmittalUserType.SpecialDispatchApprover) { cmd.CommandText = "SELECT userlvl FROM CIS.TransmittalApprover WHERE userlvl='approver' AND username='******'"; } else if (pUserType == TransmittalUserType.SpecialDispatchApprover2) { cmd.CommandText = "SELECT userlvl FROM CIS.TransmittalApprover WHERE userlvl='approver2' AND username='******'"; } cn.Open(); SqlDataReader dr = cmd.ExecuteReader(); blnReturn = dr.Read(); dr.Close(); } } return(blnReturn); }
public static TransmittalUserType GetUserLevel(string pUsername) { TransmittalUserType tutReturn = TransmittalUserType.Requestor; using (SqlConnection cn = new SqlConnection(clsSystemConfigurations.ConnectionStringTransmittal)) { SqlCommand cmd = cn.CreateCommand(); cmd.CommandText = "SELECT userlvl FROM CIS.TransmittalApprover WHERE username='******'"; cn.Open(); SqlDataReader dr = cmd.ExecuteReader(); if (dr.Read()) { if (dr["userlvl"].ToString() == "grouphead") { tutReturn = TransmittalUserType.GroupHead; } else if (dr["userlvl"].ToString() == "approver") { tutReturn = TransmittalUserType.SpecialDispatchApprover; } else if (dr["userlvl"].ToString() == "approver2") { tutReturn = TransmittalUserType.SpecialDispatchApprover2; } } dr.Close(); } return(tutReturn); }