public void AddUserMapping(string user_id, int team_id)
{
db_helper db = new db_helper(db_helper.ConnectionStr.HelpdeskConnStr);
db.AddParameter("@user_id", user_id, DbType.String);
db.AddParameter("@team_id", team_id, DbType.Int32);
db.ExecuteNonQuery("[spe_t_user_team_mapping_add]", System.Data.CommandType.StoredProcedure);
}
public void AddFeedback(string description, string user_id, string user_name, int site_id)
{
db_helper db = new db_helper(db_helper.ConnectionStr.HelpdeskConnStr);
db.AddParameter("@description", description, DbType.String);
db.AddParameter("@user_id", user_id, DbType.String);
db.AddParameter("@user_name", user_name, DbType.String);
db.AddParameter("@site_id", site_id, DbType.Int32);
db.ExecuteNonQuery("[app].[spe_feedback_add]", System.Data.CommandType.StoredProcedure);
}
public bool ValidateUser(string user_id, string application_id)
{
bool is_valid = false;
DataView dv = new DataView();
db_helper db = new db_helper(db_helper.ConnectionStr.vAppUsersConnStr);
db.AddParameter("@user_id", user_id, DbType.String);
db.AddParameter("@application_id", application_id, DbType.String);
dv = db.ExecuteDataView("spe_sso_validateuserforapp", System.Data.CommandType.StoredProcedure);
if (dv.Table.Rows.Count > 0)
{
is_valid = true;
}
return(is_valid);
}
public void AddIssueHistory(int issue_id, string description, int site_id, int company_id,
string assigned_to_account_manager, string assigned_to_current_owner, string comments, int status_id, string last_modified_by, string priority)
{
int i = 0;
db_helper db = new db_helper(db_helper.ConnectionStr.HelpdeskConnStr);
db.AddParameter("@issue_id", issue_id, DbType.Int32);
db.AddParameter("@description", description, DbType.String);
db.AddParameter("@site_id", site_id, DbType.Int32);
db.AddParameter("@company_id", company_id, DbType.Int32);
db.AddParameter("@assigned_to_account_manager", assigned_to_account_manager, DbType.String);
db.AddParameter("@assigned_to_current_owner", assigned_to_current_owner, DbType.String);
db.AddParameter("@comments", comments, DbType.String);
db.AddParameter("@status_id", status_id, DbType.Int32);
db.AddParameter("@priority", priority, DbType.String);
db.AddParameter("@last_modified_by", last_modified_by, DbType.String);
i = db.ExecuteNonQuery("spe_t_issue_history_add", System.Data.CommandType.StoredProcedure);
}
public DataView GetLatestIssueHistory(int issue_id)
{
DataView dv = new DataView();
db_helper db = new db_helper(db_helper.ConnectionStr.HelpdeskConnStr);
db.AddParameter("@issue_id", issue_id, DbType.Int32);
dv = db.ExecuteDataView("spe_t_issue_history_get_latest", System.Data.CommandType.StoredProcedure);
return(dv);
}
public DataView ListFeedback(int id)
{
DataView dv = new DataView();
db_helper db = new db_helper(db_helper.ConnectionStr.HelpdeskConnStr);
db.AddParameter("@id", id, DbType.Int32);
dv = db.ExecuteDataView("spe_t_feedback_list", System.Data.CommandType.StoredProcedure);
return(dv);
}
public DataView GetUserDetails(string user_id)
{
DataView dv = new DataView();
db_helper db = new db_helper(db_helper.ConnectionStr.HelpdeskConnStr);
db.AddParameter("@user_id", user_id, DbType.String);
dv = db.ExecuteDataView("[spe_t_user_details]", System.Data.CommandType.StoredProcedure);
return(dv);
}
public DataView SiteList(string userId)
{
DataView dv = new DataView();
//Need to change when going live
//---------------------------------
//db_helper db = new db_helper(db_helper.ConnectionStr.HelpdeskConnStr);
db_helper db = new db_helper(db_helper.ConnectionStr.HelpdeskConnStrLive);
//-------------------------------
db.AddParameter("@user_id", userId, DbType.String);
dv = db.ExecuteDataView("[dbo].[spe_t_site_list]", System.Data.CommandType.StoredProcedure);
return(dv);
}