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