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();
}
}
