// For Underwriter
public DataSet SaveApprovedUnderwriterContacts(ClientContacts objContacts)
{
dataAccess = new DataAccess();
Object[] parameters = new Object[] { objContacts.ClientId,
objContacts.ClientForModule };
return(dataAccess.LoadDataSet(parameters, "P_SaveApprovedUnderwriterContacts", "ApprovedContacts"));
}
public JsonResult ClientContactsJSON(int ClientID, FormCollection fc)
{
int ID = Convert.ToInt32(fc["id"]);
string FieldToSort = fc["sidx"];
string strSortOrder = fc["sord"];
SortDirection SortOrder;
if (FieldToSort == "id" || FieldToSort == "Action" || FieldToSort == "ClientContactEmail" || FieldToSort == "LastLoginDate" || FieldToSort == "DeliveryMethod" || FieldToSort == "IsPrimaryBillingContact" || FieldToSort == "ClientContactStatus")
{
FieldToSort = "ClientContactName";
}
if (strSortOrder == "desc")
{
SortOrder = SortDirection.Descending;
}
else
{
SortOrder = SortDirection.Ascending;
}
int RowsPerPage = Convert.ToInt32(fc["rows"]);
int CurrentPage = Convert.ToInt32(fc["page"]);
int StartRow = ((CurrentPage - 1) * RowsPerPage) + 1;
int EndRow = StartRow + RowsPerPage - 1;
var result = ClientContacts.GetClientContactsFromClientID(ClientID);
Array rows = (from question in result.Order(FieldToSort, SortOrder)
select new
{
i = question.ClientContactID,
cell = new string[] { question.ClientContactID.ToString(),
question.ClientContactEmail,
question.ClientContactName,
question.LastLoginDate,
question.DeliveryMethod,
(question.IsPrimaryBillingContact ? "Primary" : (question.IsBillingContact ? "Secondary" : "None")),
(question.ClientContactStatus ? "Active" : "Inactive") }
}
).Skip(StartRow - 1).Take(RowsPerPage).ToArray();
int totalRows = result.Count;
var ret = new JsonResult
{
Data = new
{
page = CurrentPage,
records = totalRows,
rows = rows,
total = Math.Ceiling(Convert.ToDouble((double)totalRows / (double)RowsPerPage))
}
};
return(ret);
}
public DataSet getContactList(ClientContacts objContacts)
{
dataAccess = new DataAccess();
Object[] parameters = new Object[3] {
objContacts.ClientId, objContacts.ClientForModule, objContacts.ContactId
};
//Object[] parameters = new Object[3] { objSOB.SOBId, objSOB.SOBName, objSOB.Status };
return(dataAccess.LoadDataSet(parameters, "P_pol_ClientContactDetails_Select", "ContactsList"));
}
//Use this method to send to a Billing Contact and lookup the message text from a message template
public static void SendEmailToClientContactFromTemplate(int _MessageActionType, int _MessageTemplateClientID, string _MessageTemplateName, int _ClientID, int _ToClientContactID, int _FromUserID,
string _Subject, Dictionary <string, string> _MessageValues)
{
// Thread t1 = new Thread(delegate ()
// {
//var User = Users.GetUserFromUserID(_ToUserID);
var ClientContact = ClientContacts.GetClientContactFromClientContactID(_ToClientContactID);
if (ClientContact == null)
{
return; //Error
}
string EmailTo = ClientContact.BillingContactEmail;
if (String.IsNullOrEmpty(EmailTo))
{
return; //Error
}
string UserFullName = ClientContact.ClientContactFirstName + " " + ClientContact.ClientContactLastName;
string FromName = System.Configuration.ConfigurationManager.AppSettings["BillingEmailName"];
string FromEmail = System.Configuration.ConfigurationManager.AppSettings["BillingEmail"];
string MessageBody = ScreeningONESendMail.GetMessageTemplate(_MessageTemplateClientID, _MessageTemplateName, _MessageValues);
int FromUserType = 1;
if (_FromUserID == 0)
{
FromUserType = 3;
}
if (MessageBody != null)
{
Guid?MessageGUID = Messages.AddMessage(_MessageActionType, _Subject, MessageBody, _ToClientContactID, 2, _FromUserID, FromUserType, EmailTo);
SendEmailAsScreeningOne(EmailTo, _Subject, MessageBody, true, MessageGUID, UserFullName, FromEmail, FromName);
}
//});
//t1.IsBackground = true;
//t1.Start();
}
private DataSet ApproveClient(object objEntity)
{
string strMessage = "";
clsUnApprovedInfo objXMLEntity = (clsUnApprovedInfo)(objEntity);
// implement the logic here
clsClientMaster objClient = new clsClientMaster();
clsClientManager objClientBI = new clsClientManager();
DataSet dsApprove = new DataSet();
clsXmlUnApprovedInfo xmlInfo = new clsXmlUnApprovedInfo();
xmlInfo = (clsXmlUnApprovedInfo)BusinessObjectLayer.Common.SerializeDeserialize.DeserializeAnObject(objXMLEntity.RecData, xmlInfo.GetType());
DataMapper.Map(xmlInfo, objClient, false, "RecData");
if (ProcessMasterInfo.EntityStatus == CLIENT_STATUS_APPROVED)
{
objClient.RecId = 0;
objClient.ClientId = objXMLEntity.RecForId;
objClient.ClientForModule = objXMLEntity.RecForModule;
objClient.ClientCode = objXMLEntity.Code;
dsApprove = objClientBI.SaveClient(objClient);
strMessage = Convert.ToString(dsApprove.Tables[0].Rows[0][0]);
#region Save Contacts
ClientContacts objContacts = new ClientContacts();
objContacts.ClientId = objXMLEntity.RecForId;
objContacts.ClientForModule = objXMLEntity.RecForModule;
DataSet dsContacts = objClientBI.SaveApprovedContacts(objContacts);
if (dsContacts.Tables[0].Rows[0][0].ToString().ToLower().IndexOf("success") > 0)
{
strMessage = strMessage + "<br>" + Convert.ToString(dsContacts.Tables[0].Rows[0][0]);
}
#endregion
}
//else
// dsApprove = objClientBI.SaveUnApprovedInfo(objClient);
objClientBI = null;
xmlInfo = null;
return(dsApprove);
}
public ActionResult SecurityUserSettings(int id)
{
Security_Users viewSecuritySetup = new Security_Users();
viewSecuritySetup.userlist = Clients.GetClientUsers(viewSecuritySetup.ClientID);
if (id != 0)
{
ClientContact clientContact = ClientContacts.GetClientContactFromUserID(id);
viewSecuritySetup.username = clientContact.LoginUserName;
viewSecuritySetup.UserID = clientContact.UserID;
if (viewSecuritySetup.username != null)
{
MembershipUser mu = Provider.GetUser(viewSecuritySetup.username, false);
if (mu != null)
{
viewSecuritySetup.IsApproved = mu.IsApproved;
}
else
{
viewSecuritySetup.IsApproved = true;
}
}
else
{
viewSecuritySetup.username = "";
viewSecuritySetup.IsApproved = true;
}
}
else
{
viewSecuritySetup.username = "";
viewSecuritySetup.IsApproved = true;
}
return(View(viewSecuritySetup));
}
public ActionResult BillingMessage(string CntMsgMessageSubject, string CntMsgMessageCategory)
{
if (String.IsNullOrEmpty(CntMsgMessageSubject))
{
CntMsgMessageSubject = "";
}
if (String.IsNullOrEmpty(CntMsgMessageCategory))
{
CntMsgMessageCategory = "";
}
BillingMessage_Details viewBillingMessageDetails = new BillingMessage_Details();
MembershipUser currentuser = Membership.Provider.GetUser(User.Identity.Name, true);
var contactresults = ClientContacts.GetClientContactFromUserName(currentuser.UserName);
if (contactresults.ClientContactID == 0 || contactresults.ClientContactID == null)
{
viewBillingMessageDetails.CntMsgClientContactID = 0;
viewBillingMessageDetails.CntMsgMessageFromName = "unknown";
viewBillingMessageDetails.CntMsgMessageFromEmail = "unknown";
viewBillingMessageDetails.CntMsgMessageFromPhone = "unknown";
}
else
{
viewBillingMessageDetails.CntMsgClientContactID = contactresults.ClientContactID;
viewBillingMessageDetails.CntMsgMessageFromName = contactresults.ClientContactFirstName + " " + contactresults.ClientContactLastName;
viewBillingMessageDetails.CntMsgMessageFromEmail = contactresults.ClientContactEmail;
viewBillingMessageDetails.CntMsgMessageFromPhone = contactresults.ClientContactBusinessPhone;
}
if (contactresults.ClientID == 0 || contactresults.ClientID == null)
{
viewBillingMessageDetails.CntMsgClientID = 0;
viewBillingMessageDetails.CntMsgClientName = "unknown";
}
else
{
viewBillingMessageDetails.CntMsgClientID = contactresults.ClientID;
var clientresults = Clients.GetClient(contactresults.ClientID);
if (clientresults.ClientName == null)
{
viewBillingMessageDetails.CntMsgClientName = "unknown";
}
else
{
viewBillingMessageDetails.CntMsgClientName = clientresults.ClientName;
}
}
viewBillingMessageDetails.CntMsgMessageToName = ConfigurationManager.AppSettings["CompanyName"] + " Billing Dept.";
#if DEBUG_EMAIL
viewBillingMessageDetails.CntMsgMessageToEmail = "*****@*****.**";
#else
viewBillingMessageDetails.CntMsgMessageToEmail = ConfigurationManager.AppSettings["billingemail"];
#endif
viewBillingMessageDetails.CntMsgMessageCategory = CntMsgMessageCategory;
viewBillingMessageDetails.CntMsgMessageSubject = CntMsgMessageSubject;
viewBillingMessageDetails.CntMsgMessageBody = "";
return(View(viewBillingMessageDetails));
}
public JsonResult BillingMessage(int CntMsgClientID, string CntMsgClientName, int CntMsgClientContactID,
string CntMsgMessageSubject, string CntMsgMessageFromName, string CntMsgMessageBody, string CntMsgMessageToName,
string CntMsgMessageFromEmail, string CntMsgMessageToEmail, string CntMsgMessageCategory, string CntMsgMessageFromPhone)
{
BillingMessage_Details viewBillingMessageDetails = new BillingMessage_Details();
viewBillingMessageDetails.CntMsgClientID = CntMsgClientID;
viewBillingMessageDetails.CntMsgClientName = CntMsgClientName;
viewBillingMessageDetails.CntMsgClientContactID = CntMsgClientContactID;
viewBillingMessageDetails.CntMsgMessageSubject = CntMsgMessageSubject;
viewBillingMessageDetails.CntMsgMessageFromName = CntMsgMessageFromName;
viewBillingMessageDetails.CntMsgMessageBody = CntMsgMessageBody;
viewBillingMessageDetails.CntMsgMessageToName = CntMsgMessageToName;
viewBillingMessageDetails.CntMsgMessageFromEmail = CntMsgMessageFromEmail;
viewBillingMessageDetails.CntMsgMessageToEmail = CntMsgMessageToEmail;
viewBillingMessageDetails.CntMsgMessageCategory = CntMsgMessageCategory;
viewBillingMessageDetails.CntMsgMessageFromPhone = CntMsgMessageFromPhone;
ClientContact userresult = ClientContacts.GetClientContactFromClientContactID(CntMsgClientContactID);
Dictionary <string, string> messagevalues = new Dictionary <string, string>();
messagevalues.Add("[[COMPANYNAME]]", CntMsgClientName);
messagevalues.Add("[[USERNAME]]", CntMsgMessageFromName);
messagevalues.Add("[[USEREMAIL]]", CntMsgMessageFromEmail);
messagevalues.Add("[[MESSAGECATEGORY]]", CntMsgMessageCategory);
messagevalues.Add("[[USERPHONE]]", CntMsgMessageFromPhone);
messagevalues.Add("[[MESSAGEBODY]]", CntMsgMessageBody);
messagevalues.Add("[[CORPORATENAME]]", System.Configuration.ConfigurationManager.AppSettings["CompanyName"]);
string subject = "Billing Client Request: " + CntMsgMessageSubject;
MailGun.SendEmailToEmailAddressFromTemplate(4, 0, "Client Request", 0, ConfigurationManager.AppSettings["supportemail"], subject, "Tech Support", messagevalues);
return(new JsonResult {
Data = new { success = true }
});
/*var messageRecord = Messages.GetMessageTemplateRecord(0, "Client Request", messagevalues);
*
* string messagebody = messageRecord != null ? messageRecord.MessageText : null;
*
* if (messagebody != null)
* {
* int messageActionType = messageRecord.MessageActionTypeID.GetValueOrDefault();
* int? MessageIDOutput = new int?();
* Guid? MessageActionGuidOutput = new Guid?();
* subject = "Billing Client Request: " + CntMsgMessageSubject;
* Messages.CreateMessageWithAction(messageActionType, subject, messagebody, 2, 1, 0, 3, "", System.DateTime.Now, null, "HTML", ref MessageIDOutput, ref MessageActionGuidOutput);
* Messages.UpdateMessageAndMarkForSending(MessageIDOutput.Value, subject, messagebody);
* return new JsonResult { Data = new { success = true } };
* }
* else
* {
* ModelState.AddModelError("ErrorMessages", "The message body was empty and could not be delivered. Please enter some information in the Message body and try again.");
* return new JsonResult
* {
* Data = new
* {
* success = false,
* view = RenderToString.RenderViewToString(this, "BillingMessage", viewBillingMessageDetails)
* }
* };
* }*/
}
