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 void AddFeedbackHistory(int feedback_id, string description, int site_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("@feedback_id", feedback_id, DbType.Int32);
db.AddParameter("@description", description, DbType.String);
db.AddParameter("@site_id", site_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_feedback_history_add", System.Data.CommandType.StoredProcedure);
}