public string PostCalibration(ListenDataRequest listenDataRequest)
{
string Message = "";
try
{
if (!HttpContext.Current.User.Identity.IsAuthenticated)
{
return(Messages.Authenticated);
}
if (listenDataRequest.bad_reason == "Scorecard Mismatch")
{
return("0");
}
Message = objCCInternalLayer.PostCalibration(listenDataRequest);
}
catch (Exception ex)
{
throw ex;
}
return(Message);
}
/// <summary>
/// PostListen
/// </summary>
/// <param name="LDR"></param>
/// <returns></returns>
public string PostListen(ListenDataRequest LDR)
{
string user = "******";
ListenDataPost LD = LDR.LD;
List <FormQScores> FQS = LDR.FQS;
List <FormQResponses> FQR = LDR.FQR;
List <FormQScoresOptions> FQSO = LDR.FQSO;
List <SystemComments> SC = LDR.SC;
List <ClerkedData> CD = LDR.CD;
DataTable listen_dt = new DataTable();
listen_dt.Columns.Add("reviewer", Type.GetType("System.String"));
listen_dt.Columns.Add("session_id", Type.GetType("System.String"));
listen_dt.Columns.Add("review_ID", Type.GetType("System.Int32"));
listen_dt.Columns.Add("Comments", Type.GetType("System.String"));
listen_dt.Columns.Add("appname", Type.GetType("System.String"));
listen_dt.Columns.Add("whisperID", Type.GetType("System.Int32"));
listen_dt.Columns.Add("QAwhisper", Type.GetType("System.Int32"));
listen_dt.Columns.Add("qa_start", Type.GetType("System.Int32"));
listen_dt.Columns.Add("qa_last_action", Type.GetType("System.Int32"));
listen_dt.Columns.Add("call_length", Type.GetType("System.Single"));
listen_dt.Columns.Add("copy_to_cali", Type.GetType("System.Int32"));
int whisperID = 0;
int QAwhisper = 0;
int.TryParse(LD.whisperID, out whisperID);
int.TryParse(LD.QAwhisper, out QAwhisper);
DataRow listen_dr = listen_dt.NewRow();
listen_dr["reviewer"] = user;
listen_dr["session_id"] = LD.session_id;
listen_dr["review_ID"] = LD.review_ID;
listen_dr["Comments"] = LD.Comments;
listen_dr["appname"] = LD.appname;
listen_dr["whisperID"] = whisperID;
listen_dr["QAwhisper"] = QAwhisper;
listen_dr["qa_start"] = LD.qa_start;
listen_dr["qa_last_action"] = LD.qa_last_action;
listen_dr["call_length"] = LD.call_length;
if (LD.copy_to_cali == false | LD.copy_to_cali == false | LD.copy_to_cali == false)
{
listen_dr["copy_to_cali"] = 0;
}
else
{
listen_dr["copy_to_cali"] = 1;
}
listen_dt.Rows.Add(listen_dr);
DataTable sc_dt = new DataTable();
sc_dt.Columns.Add("comment_who", Type.GetType("System.String"));
sc_dt.Columns.Add("comment", Type.GetType("System.String"));
sc_dt.Columns.Add("comment_type", Type.GetType("System.String"));
sc_dt.Columns.Add("comment_pos", Type.GetType("System.String"));
sc_dt.Columns.Add("comment_header", Type.GetType("System.String"));
foreach (var sc_item in SC)
{
DataRow sc_dr = sc_dt.NewRow();
sc_dr["comment_who"] = user;
sc_dr["comment"] = sc_item.comment;
sc_dr["comment_type"] = "Call";
if (sc_item.comment_pos != "")
{
sc_dr["comment_pos"] = sc_item.comment_pos;
}
sc_dr["comment_header"] = sc_item.comment_header;
sc_dt.Rows.Add(sc_dr);
}
DataTable FQS_dt = new DataTable();
FQS_dt.Columns.Add("q_position", Type.GetType("System.String"));
FQS_dt.Columns.Add("question_id", Type.GetType("System.Int32"));
FQS_dt.Columns.Add("question_result", Type.GetType("System.Int32"));
FQS_dt.Columns.Add("question_answered", Type.GetType("System.String"));
FQS_dt.Columns.Add("click_text", Type.GetType("System.String"));
FQS_dt.Columns.Add("other_answer_text", Type.GetType("System.String"));
FQS_dt.Columns.Add("view_link", Type.GetType("System.String"));
foreach (var fqs_item in FQS)
{
DataRow FQS_dr = FQS_dt.NewRow();
FQS_dr["q_position"] = fqs_item.q_position;
FQS_dr["question_id"] = fqs_item.question_id;
FQS_dr["question_result"] = 0;
FQS_dr["question_answered"] = fqs_item.question_answered;
FQS_dr["click_text"] = fqs_item.click_text;
FQS_dr["view_link"] = fqs_item.view_link;
FQS_dt.Rows.Add(FQS_dr);
}
DataTable FQR_dt = new DataTable();
FQR_dt.Columns.Add("question_id", Type.GetType("System.String"));
FQR_dt.Columns.Add("answer_id", Type.GetType("System.Int32"));
FQR_dt.Columns.Add("other_answer_text", Type.GetType("System.String"));
foreach (var fqr_item in FQR)
{
DataRow FQR_dr = FQR_dt.NewRow();
FQR_dr["question_id"] = fqr_item.question_id;
FQR_dr["answer_id"] = fqr_item.answer_id;
FQR_dr["other_answer_text"] = fqr_item.other_answer_text;
FQR_dt.Rows.Add(FQR_dr);
}
DataTable FQSO_dt = new DataTable();
FQSO_dt.Columns.Add("option_pos", Type.GetType("System.Int32"));
FQSO_dt.Columns.Add("option_value", Type.GetType("System.String"));
FQSO_dt.Columns.Add("question_id", Type.GetType("System.Int32"));
FQSO_dt.Columns.Add("orig_id", Type.GetType("System.Int32"));
foreach (var fqso_item in FQSO)
{
DataRow FQSO_dr = FQSO_dt.NewRow();
FQSO_dr["option_pos"] = fqso_item.option_pos;
FQSO_dr["option_value"] = fqso_item.option_value;
FQSO_dr["question_id"] = fqso_item.question_id;
FQSO_dr["orig_id"] = fqso_item.orig_id;
FQSO_dt.Rows.Add(FQSO_dr);
}
// Save additional clerked data
DataTable CD_dt = new DataTable();
CD_dt.Columns.Add("value_id", Type.GetType("System.Int32"));
CD_dt.Columns.Add("value_data", Type.GetType("System.String"));
CD_dt.Columns.Add("value_position", Type.GetType("System.String"));
foreach (var cd_item in CD)
{
DataRow CD_dr = CD_dt.NewRow();
CD_dr["value_id"] = cd_item.ID;
CD_dr["value_data"] = cd_item.data;
CD_dr["value_position"] = cd_item.position;
CD_dt.Rows.Add(CD_dr);
}
var sqlCon = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["CC_ProdConn"].ConnectionString);
using (var command = new SqlCommand("listenDataInsert"))
{
command.CommandType = CommandType.StoredProcedure;
command.CommandTimeout = 90;
//create your own data table
command.Parameters.Add(new SqlParameter("@ListenInsert", listen_dt));
command.Parameters.Add(new SqlParameter("@FQSInsert", FQS_dt));
command.Parameters.Add(new SqlParameter("@FQRInsert", FQR_dt));
command.Parameters.Add(new SqlParameter("@FQSOInsert", FQSO_dt));
command.Parameters.Add(new SqlParameter("@SCInsert", sc_dt));
command.Parameters.Add(new SqlParameter("@CDInsert", CD_dt));
//command.Parameters.Add(New SqlParameter("@KeywordInsert", KW_dt))
command.Connection = sqlCon;
sqlCon.Open();
try
{
command.ExecuteNonQuery();
}
catch (Exception ex)
{
throw ex;
}
}
return("success");
//DataTable dt = GetTable("select top 1 f_id from vwForm where review_id = '" + LD.review_ID + "' order by f_id desc");
//return dt.Rows(0).Item(0).ToString;
}
/// <summary>
/// PostListen
/// </summary>
/// <param name="LDR"></param>
/// <returns></returns>
public string PostListen(ListenDataRequest LDR)
{
ListenLayer listenLayer = new ListenLayer();
return(listenLayer.PostListen(LDR));
}
