private LiveHelp ValidateLiveHelpInput(LiveHelp liveHelpInput) { try { #region LiveHelpID #endregion #region MemberID //if (liveHelpInput.MemberID == 0 || liveHelpInput.MemberID == null) //{ // liveHelpInput.MemberID = GetDefaultMemberID(liveHelpInput.Language); //} #endregion #region UserName #endregion #region CreatedBy if (liveHelpInput.CreatedBy == null || liveHelpInput.CreatedBy == string.Empty) { liveHelpInput.CreatedBy = "NoCaseOwner"; } #endregion #region CreatedDate if (liveHelpInput.CreatedDate == DateTime.MinValue) { liveHelpInput.CreatedDate = DateTime.Now; } #endregion #region OperatorUserName if (liveHelpInput.OperatorUserName == null || liveHelpInput.OperatorUserName == string.Empty) { liveHelpInput.OperatorUserName = "******"; } #endregion #region OperatorEmail #endregion #region Chat_Type //NEED to VERIFY Default Value if (liveHelpInput.Chat_Type == null || liveHelpInput.Chat_Type == string.Empty) { liveHelpInput.Chat_Type = "Others"; } #endregion #region Summary_Of_Chat if (liveHelpInput.Summary_Of_Chat == null) { liveHelpInput.Summary_Of_Chat = ""; } #endregion #region Customer_Language #endregion #region Customer_IP #endregion #region CUstomer_ISP #endregion #region Browser_Name #endregion #region Browser_Platform #endregion #region Language if (liveHelpInput.Language == null || liveHelpInput.LastModifiedBy == string.Empty) { //Defaults to English User liveHelpInput.Language = ""; } #endregion #region ParentID //if (liveHelpInput.ParentID == null || liveHelpInput.ParentID == string.Empty) //{ // liveHelpInput.ParentID = "0"; //} #endregion #region RecordTypeID //switch (liveHelpInput.RecordTypeID) //{ // case 1: // case 9: // case 10: // case 11: // case 12: // break; // //Default the value to 1 "CS Cases" // default: // liveHelpInput.RecordTypeID = 1; // break; //} #endregion #region Status switch (liveHelpInput.Status) { //case 1: //case 2: //case 4: //case 5: //case 6: // break; ////Default the value to 1 "Open" //default: // liveHelpInput.Status = 1; // break; } #endregion #region Origin switch (liveHelpInput.Origin) { ////Needs to be updated with PROD values //case 7: //case 8: //case 9: //case 10: //case 144: //case 145: //case 228: //case 229: //case 230: //case 231: //case 232: //case 332: //case 333: //case 334: // break; ////Default to LiveHelpNowID as of UAT //default: // liveHelpInput.Origin = 334; // break; } #endregion #region Subject //if (liveHelpInput.Subject == null || liveHelpInput.Subject == string.Empty) //{ // //liveHelpInput.Subject = "LiveHelpCase_" + liveHelpInput.MemberID.ToString() + "_" + liveHelpInput.Ticket_ID + "_" + DateTime.Now.ToString("F"); // liveHelpInput.Subject = "LiveHelpNow|Case: " + liveHelpInput.Ticket_ID + "|Member: " + liveHelpInput.MemberID.ToString(); //} #endregion #region Description //if (liveHelpInput.Description == null || liveHelpInput.Description == string.Empty) //{ // liveHelpInput.Description = "LiveHelpNow|Case: " + liveHelpInput.Ticket_ID + "|Member: " + liveHelpInput.MemberID.ToString(); //} #endregion #region HasCommentsUnreadByOwner //Currently defaulst to 0 - false #endregion #region Ticket_ID //if (liveHelpInput.Ticket_ID == null || liveHelpInput.Ticket_ID == string.Empty) //{ // liveHelpInput.Ticket_ID = "LH" + liveHelpInput.MemberID.ToString() + "_" + DateTime.Now.ToString(); //} //else //{ // liveHelpInput.Ticket_ID = "LH" + liveHelpInput.Ticket_ID; //} #endregion #region Complain //Currently defaults to 0 - "No" #endregion #region Type //switch (liveHelpInput.Type) //{ // case 14: // case 15: // case 16: // case 17: // case 18: // case 19: // case 20: // case 21: // case 22: // case 23: // case 24: // case 25: // case 26: // case 27: // break; // //Default the value to 19 "Others" // default: // liveHelpInput.Type = 19; // break; //} #endregion #region Sub_Type //switch (liveHelpInput.Sub_Type) //{ // case 29: // case 30: // case 31: // case 32: // case 33: // case 34: // case 35: // case 36: // case 37: // case 38: // case 39: // case 40: // case 41: // case 42: // case 43: // case 44: // case 45: // case 46: // case 47: // case 48: // case 49: // case 50: // case 51: // case 52: // case 53: // case 54: // case 55: // case 56: // case 57: // case 58: // case 59: // case 60: // case 61: // case 62: // case 63: // case 64: // case 65: // case 66: // case 67: // case 68: // case 69: // case 70: // case 71: // case 72: // case 73: // case 74: // case 75: // case 76: // case 77: // case 78: // case 79: // case 80: // case 81: // case 82: // case 83: // case 84: // case 85: // case 86: // case 87: // case 88: // case 89: // case 90: // case 91: // case 92: // case 93: // case 94: // case 95: // case 96: // case 97: // case 98: // case 99: // case 100: // case 101: // case 102: // case 103: // case 104: // case 105: // case 106: // case 107: // case 108: // case 109: // case 110: // case 111: // case 112: // case 113: // case 114: // case 115: // case 147: // case 148: // case 149: // case 150: // case 151: // case 152: // case 153: // case 154: // case 155: // case 156: // case 157: // case 158: // case 159: // case 160: // case 161: // case 162: // case 163: // case 164: // case 165: // case 166: // case 167: // case 168: // case 169: // case 170: // case 171: // case 172: // case 173: // case 174: // case 175: // case 176: // case 177: // case 178: // case 179: // case 180: // case 181: // case 182: // case 183: // case 184: // case 185: // case 186: // case 187: // break; // //Default the value to 68 "Others" // default: // liveHelpInput.Sub_Type = 68; // break; //} #endregion #region Referral_Detail //switch (liveHelpInput.Referral_Detail) //{ // case 116: // case 0: // break; // //Default the value to 116 "Others" // default: // liveHelpInput.Referral_Detail = 116; // break; //} #endregion #region HowDoTheyFeelAboutUs //switch (liveHelpInput.HowDoTheyFeelAboutUs) //{ // case 117: // case 118: // case 119: // break; // //Default the value to 119 "No Comment" // default: // liveHelpInput.HowDoTheyFeelAboutUs = 119; // break; //} #endregion #region LastModifiedBy //if (liveHelpInput.LastModifiedBy == null || liveHelpInput.LastModifiedBy == string.Empty) //{ // liveHelpInput.LastModifiedBy = liveHelpInput.CreatedBy; //} #endregion return liveHelpInput; } catch (Exception Ex) { throw Ex; } }
public void CreateCaseViaLiveHelp(LiveHelp lhInput) { try { LiveHelp lhRet = new LiveHelp(); //WriteLogToFile("Validating LiveHelp values.", ConfigurationManager.AppSettings["logPathLocation"].ToString(), ConfigurationManager.AppSettings["logFileName"].ToString()); WriteLogToFile("Validating LiveHelp values.", ConfigurationManager.AppSettings["logPathLocation"].ToString(), ConfigurationManager.AppSettings["logFileName"].ToString().Replace(".txt", DateTime.Now.ToString("yyyyMMdd") + ".txt")); lhRet = ValidateLiveHelpInput(lhInput); //WriteLogToFile("Validation Successful LiveHelp values.", ConfigurationManager.AppSettings["logPathLocation"].ToString(), ConfigurationManager.AppSettings["logFileName"].ToString()); WriteLogToFile("Validation Successful LiveHelp values.", ConfigurationManager.AppSettings["logPathLocation"].ToString(), ConfigurationManager.AppSettings["logFileName"].ToString().Replace(".txt", DateTime.Now.ToString("yyyyMMdd") + ".txt")); InsertLiveHelpData_to_LiveHelpTable(lhRet); } catch (Exception Ex) { throw Ex; } }
private void InsertLiveHelpData_to_LiveHelpTable(LiveHelp lhInput) { try { //WriteLogToFile("Preparing Insert to Database", ConfigurationManager.AppSettings["logPathLocation"].ToString(), ConfigurationManager.AppSettings["logFileName"].ToString()); WriteLogToFile("Preparing Insert to Database", ConfigurationManager.AppSettings["logPathLocation"].ToString(), ConfigurationManager.AppSettings["logFileName"].ToString().Replace(".txt", DateTime.Now.ToString("yyyyMMdd") + ".txt")); string tempConn = ConfigurationManager.AppSettings["connCRMMS1"].ToString(); //string connCRMstr = tempConn.Replace("[xxx]", "testpass"); string connCRMstr = tempConn.Replace("[xxx]", Encryption.Decrypt(ConfigurationManager.AppSettings["connCRMMS1_Password"].ToString())); using (SqlConnection connection = new SqlConnection(connCRMstr)) { //using (SqlCommand cmd = new SqlCommand("[dbo].[spTLiveHelpInsert_CheckMemberID]", connection)) using (SqlCommand cmd = new SqlCommand("[dbo].[spTLiveHelpData_Insert_Ext]", connection)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@liveHelpID", SqlDbType.BigInt).Value = lhInput.LiveHelpID; cmd.Parameters.Add("@operatorID", SqlDbType.BigInt).Value = lhInput.OperatorID; if (lhInput.MemberID == null) { cmd.Parameters.Add("@memberid", SqlDbType.BigInt).Value = DBNull.Value; } else { cmd.Parameters.Add("@memberid", SqlDbType.BigInt).Value = lhInput.MemberID; } cmd.Parameters.Add("@userName", SqlDbType.VarChar, 50).Value = lhInput.UserName; cmd.Parameters.Add("@createdDate", SqlDbType.DateTime).Value = lhInput.CreatedDate; cmd.Parameters.Add("@createdBy", SqlDbType.VarChar, 50).Value = lhInput.CreatedBy; cmd.Parameters.Add("@operatorUserName", SqlDbType.VarChar, 100).Value = lhInput.OperatorUserName; cmd.Parameters.Add("@operatorEmail", SqlDbType.VarChar, 200).Value = lhInput.OperatorEmail; cmd.Parameters.Add("@chat_type", SqlDbType.VarChar, 50).Value = lhInput.Chat_Type; cmd.Parameters.Add("@summary_of_chat", SqlDbType.NVarChar).Value = lhInput.Summary_Of_Chat; cmd.Parameters.Add("@customer_language", SqlDbType.VarChar, 50).Value = lhInput.Customer_Language; cmd.Parameters.Add("@customer_IP", SqlDbType.VarChar, 50).Value = lhInput.Customer_IP; cmd.Parameters.Add("@customer_ISP", SqlDbType.VarChar, 500).Value = lhInput.Customer_ISP; cmd.Parameters.Add("@browser_name", SqlDbType.VarChar, 100).Value = lhInput.Browser_Name; cmd.Parameters.Add("@browser_platform", SqlDbType.VarChar, 100).Value = lhInput.Browser_Platform; cmd.Parameters.Add("@language", SqlDbType.VarChar, 50).Value = lhInput.Language; //cmd.Parameters.Add("@memberid", SqlDbType.BigInt).Value = lhInput.MemberID; //cmd.Parameters.Add("@ParentID", SqlDbType.VarChar, 15).Value = lhInput.ParentID; //cmd.Parameters.Add("@RecordTypeID", SqlDbType.BigInt).Value = lhInput.RecordTypeID; //cmd.Parameters.Add("@Status", SqlDbType.BigInt).Value = lhInput.Status; //cmd.Parameters.Add("@Origin", SqlDbType.BigInt).Value = lhInput.Origin; //cmd.Parameters.Add("@Subject", SqlDbType.NVarChar, 300).Value = lhInput.Subject; //cmd.Parameters.Add("@Description", SqlDbType.NVarChar).Value = lhInput.Description; //cmd.Parameters.Add("@HasCommentsUnreadByOwner", SqlDbType.Bit).Value = lhInput.HasCommentsUnreadByOwner; //cmd.Parameters.Add("@createdBy", SqlDbType.VarChar, 50).Value = lhInput.CreatedBy; //cmd.Parameters.Add("@CreatedDate", SqlDbType.DateTime).Value = lhInput.CreatedDate; //cmd.Parameters.Add("@Ticket_ID", SqlDbType.VarChar, 50).Value = lhInput.Ticket_ID; //cmd.Parameters.Add("@Complain", SqlDbType.Bit).Value = lhInput.Complain; //cmd.Parameters.Add("@Type", SqlDbType.BigInt).Value = lhInput.Type; //cmd.Parameters.Add("@Sub_Type", SqlDbType.VarChar, 100).Value = lhInput.Sub_Type; //cmd.Parameters.Add("@Referral_Detail", SqlDbType.BigInt).Value = lhInput.Referral_Detail; //cmd.Parameters.Add("@HowDoTheyFeelAboutUs", SqlDbType.BigInt).Value = lhInput.HowDoTheyFeelAboutUs; //cmd.Parameters.Add("@Summary_Of_Chat", SqlDbType.NVarChar).Value = lhInput.Summary_Of_Chat; //cmd.Parameters.Add("@LastModifiedBy", SqlDbType.VarChar, 50).Value = lhInput.LastModifiedBy; //cmd.Parameters.Add("@Language", SqlDbType.VarChar, 50).Value = lhInput.Language; //WriteLogToFile("Opening Database Connection...", ConfigurationManager.AppSettings["logPathLocation"].ToString(), ConfigurationManager.AppSettings["logFileName"].ToString()); WriteLogToFile("Opening Database Connection...", ConfigurationManager.AppSettings["logPathLocation"].ToString(), ConfigurationManager.AppSettings["logFileName"].ToString().Replace(".txt", DateTime.Now.ToString("yyyyMMdd") + ".txt")); connection.Open(); //WriteLogToFile("Connection Successful.", ConfigurationManager.AppSettings["logPathLocation"].ToString(), ConfigurationManager.AppSettings["logFileName"].ToString()); WriteLogToFile("Connection Successful.", ConfigurationManager.AppSettings["logPathLocation"].ToString(), ConfigurationManager.AppSettings["logFileName"].ToString().Replace(".txt", DateTime.Now.ToString("yyyyMMdd") + ".txt")); object val = cmd.ExecuteScalar(); cmd.Parameters.Clear(); //WriteLogToFile("Insert Successful", ConfigurationManager.AppSettings["logPathLocation"].ToString(), ConfigurationManager.AppSettings["logFileName"].ToString()); WriteLogToFile("Insert Successful", ConfigurationManager.AppSettings["logPathLocation"].ToString(), ConfigurationManager.AppSettings["logFileName"].ToString().Replace(".txt", DateTime.Now.ToString("yyyyMMdd") + ".txt")); } } } catch (Exception Ex) { //WriteLogToFile("Exception in Database Insert: " + Ex.Message + Ex.StackTrace, ConfigurationManager.AppSettings["logPathLocation"].ToString(), ConfigurationManager.AppSettings["logFileName"].ToString()); WriteLogToFile("Exception in Database Insert: " + Ex.Message + Ex.StackTrace, ConfigurationManager.AppSettings["logPathLocation"].ToString(), ConfigurationManager.AppSettings["logFileName"].ToString().Replace(".txt", DateTime.Now.ToString("yyyyMMdd") + ".txt")); throw Ex; } }
//[HttpPost] public ActionResult CreateCaseViaLiveHelp_Ext() { try { LiveHelp lh = new LiveHelp(); LiveHelpMethods lhm = new LiveHelpMethods(); //lhm.WriteLogToFile("Log_" + DateTime.Now.ToString(), ConfigurationManager.AppSettings["logPathLocation"].ToString(), ConfigurationManager.AppSettings["logFileName"].ToString()); lhm.WriteLogToFile("Log_" + DateTime.Now.ToString(), ConfigurationManager.AppSettings["logPathLocation"].ToString(), ConfigurationManager.AppSettings["logFileName"].ToString().Replace(".txt", DateTime.Now.ToString("yyyyMMdd") + ".txt")); //lhm.WriteLogToFile("Call to Method Successful", ConfigurationManager.AppSettings["logPathLocation"].ToString(), ConfigurationManager.AppSettings["logFileName"].ToString()); lhm.WriteLogToFile("Call to Method Successful", ConfigurationManager.AppSettings["logPathLocation"].ToString(), ConfigurationManager.AppSettings["logFileName"].ToString().Replace(".txt", DateTime.Now.ToString("yyyyMMdd") + ".txt")); System.IO.StreamReader reader = new System.IO.StreamReader(HttpContext.Request.InputStream); lh = JsonConvert.DeserializeObject<LiveHelp>(reader.ReadToEnd()); lhm.CreateCaseViaLiveHelp(lh); return View(); } catch (Exception Ex) { LiveHelpMethods lhm = new LiveHelpMethods(); //lhm.WriteLogToFile("Exception in CreateCaseViaLiveHelp: " + Ex.Message + Ex.StackTrace, ConfigurationManager.AppSettings["logPathLocation"].ToString(), ConfigurationManager.AppSettings["logFileName"].ToString()); lhm.WriteLogToFile("Exception in CreateCaseViaLiveHelp: " + Ex.Message + Ex.StackTrace, ConfigurationManager.AppSettings["logPathLocation"].ToString(), ConfigurationManager.AppSettings["logFileName"].ToString().Replace(".txt", DateTime.Now.ToString("yyyyMMdd") + ".txt")); return View(); } }