/// <summary>
/// Saves User Preferences for specified user. USES TEST BACKEND.
/// </summary>
/// <param name="u"></param>
/// <returns></returns>
public static int UpdateUser(UserPrefs u)
{
using (SqlDataAdapter sql = new SqlDataAdapter())
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ISISConnectionString"].ConnectionString))
{
conn.Open();
sql.UpdateCommand = new SqlCommand("proc_updateUser", conn)
{
CommandType = CommandType.StoredProcedure
};
sql.UpdateCommand.Parameters.AddWithValue("@userid", u.userid);
sql.UpdateCommand.Parameters.AddWithValue("@accessLevel", u.accessLevel);
sql.UpdateCommand.Parameters.AddWithValue("@reportPath", u.ReportPath);
sql.UpdateCommand.Parameters.AddWithValue("@reportPrompt", u.reportPrompt);
sql.UpdateCommand.Parameters.AddWithValue("@wordingNumbers", u.wordingNumbers);
try
{
sql.UpdateCommand.ExecuteNonQuery();
}
catch (Exception)
{
return(1);
}
}
return(0);
}
/// <summary>
/// Saves a filter for the provided user.
/// </summary>
/// <param name="formName"></param>
/// <param name="filter"></param>
/// <param name="position"></param>
/// <param name="user"></param>
/// <returns></returns>
public static int SaveSession(string formName, string filter, int position, UserPrefs user)
{
using (SqlDataAdapter sql = new SqlDataAdapter())
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ISISConnectionString"].ConnectionString))
{
conn.Open();
sql.UpdateCommand = new SqlCommand("proc_saveSession", conn)
{
CommandType = CommandType.StoredProcedure
};
sql.UpdateCommand.Parameters.AddWithValue("@formname", formName);
sql.UpdateCommand.Parameters.AddWithValue("@filter", filter);
sql.UpdateCommand.Parameters.AddWithValue("@position", position);
sql.UpdateCommand.Parameters.AddWithValue("@personnelID", user.userid);
try
{
sql.UpdateCommand.ExecuteNonQuery();
}
catch (Exception)
{
return(1);
}
}
return(0);
}
//
// Users
//
/// <summary>
/// Returns the user profile for the specified username.
/// </summary>
/// <param name="username"></param>
/// <returns></returns>
public static UserPrefs GetUser(string username)
{
UserPrefs u;
string query = "SELECT * FROM Users.FN_GetUserPrefs (@username)";
using (SqlDataAdapter sql = new SqlDataAdapter())
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ISISConnectionString"].ConnectionString))
{
conn.Open();
sql.SelectCommand = new SqlCommand(query, conn);
sql.SelectCommand.Parameters.AddWithValue("@username", username);
try
{
using (SqlDataReader rdr = sql.SelectCommand.ExecuteReader())
{
rdr.Read();
u = new UserPrefs
{
userid = (int)rdr["PersonnelID"],
Username = (string)rdr["username"],
accessLevel = (AccessLevel)rdr["AccessLevel"],
ReportPath = (string)rdr["ReportFolder"],
reportPrompt = (bool)rdr["ReportPrompt"],
wordingNumbers = (bool)rdr["WordingNumbers"],
commentDetails = (int)rdr["CommentDetails"]
};
}
}
catch (Exception)
{
return(null);
}
}
return(u);
}
//
// Fill Methods
//
/// <summary>
/// Populates the Survey Entry filters for the provided user.
/// </summary>
/// <param name="user"></param>
public static void FillUserSurveyFilters(UserPrefs user)
{
string query = "SELECT * FROM Users.FN_GetUserFilters(@id)";
string se1 = "4C1"; string seb1 = "4C1"; string seg1 = "4C1";
string se2 = "4C1"; string seb2 = "4C1"; string seg2 = "4C1";
string se3 = "4C1"; string seb3 = "4C1"; string seg3 = "4C1";
using (SqlDataAdapter sql = new SqlDataAdapter())
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ISISConnectionString"].ConnectionString))
{
conn.Open();
sql.SelectCommand = new SqlCommand(query, conn);
sql.SelectCommand.Parameters.AddWithValue("@id", user.userid);
try
{
using (SqlDataReader rdr = sql.SelectCommand.ExecuteReader())
{
while (rdr.Read())
{
if ((string)rdr["FormName"] == "frmSurveyEntry")
{
se1 = (string)rdr["Filter"];
}
else if ((string)rdr["FormName"] == "frmSurveyEntry2")
{
se2 = (string)rdr["Filter"];
}
else if ((string)rdr["FormName"] == "frmSurveyEntry3")
{
se3 = (string)rdr["Filter"];
}
if ((string)rdr["FormName"] == "sfrmSurveyEntryBrown")
{
seb1 = (string)rdr["Filter"];
}
else if ((string)rdr["FormName"] == "sfrmSurveyEntryBrown2")
{
seb2 = (string)rdr["Filter"];
}
else if ((string)rdr["FormName"] == "sfrmSurveyEntryBrown3")
{
seb3 = (string)rdr["Filter"];
}
if ((string)rdr["FormName"] == "sfrmSurveyEntryGreen")
{
seg1 = (string)rdr["Filter"];
}
else if ((string)rdr["FormName"] == "sfrmSurveyEntryGreen2")
{
seg2 = (string)rdr["Filter"];
}
else if ((string)rdr["FormName"] == "sfrmSurveyEntryGreen3")
{
seg3 = (string)rdr["Filter"];
}
}
}
}
catch (Exception)
{
}
}
user.SurveyEntryCodes.Add(se1);
user.SurveyEntryCodes.Add(se2);
user.SurveyEntryCodes.Add(se3);
user.SurveyEntryBrown.Add(seb1);
user.SurveyEntryBrown.Add(seb2);
user.SurveyEntryBrown.Add(seb3);
user.SurveyEntryGreen.Add(seg1);
user.SurveyEntryGreen.Add(seg2);
user.SurveyEntryGreen.Add(seg3);
}
