/// <summary>
/// This method is used for Delete Sections
/// </summary>
/// <param name="SectionID"></param>
/// <returns></returns>
public string DeleteCAPADetails(string CAPADetailsId)
{
objBLCAPADetails = new BLCAPADetails();
objDataOperationResponse = objBLCAPADetails.DeleteCAPADetails(Convert.ToInt32(CAPADetailsId));
return(objDataOperationResponse.Message);
}
/// <summary>
/// This method is used to Add Update Client Info
/// </summary>
/// <param name="objDCClientInfo"></param>
/// <returns></returns>
public List <DCClientInfo> AddUpdateClientInfo(DCClientInfo objDCClientInfo)
{
try
{
objDatabaseHelper = new DatabaseHelper();
objDataOperationResponce = new DataOperationResponse();
lstDCClientInfo = new List <DCClientInfo>();
objDatabaseHelper.AddParameter("pClientId", objDCClientInfo.ClientId == 0 ? DBNull.Value : (object)objDCClientInfo.ClientId);
objDatabaseHelper.AddParameter("pFirstName", objDCClientInfo.FirstName == string.Empty ? DBNull.Value : (object)objDCClientInfo.FirstName);
objDatabaseHelper.AddParameter("pLastName", objDCClientInfo.LastName == string.Empty ? DBNull.Value : (object)objDCClientInfo.LastName);
objDatabaseHelper.AddParameter("pContactTitle", objDCClientInfo.ContactTitle == string.Empty ? DBNull.Value : (object)objDCClientInfo.ContactTitle);
objDatabaseHelper.AddParameter("pEmail", objDCClientInfo.EmailAddress == string.Empty ? DBNull.Value : (object)objDCClientInfo.EmailAddress);
objDatabaseHelper.AddParameter("pCompanyName", objDCClientInfo.CompanyName == string.Empty ? DBNull.Value : (object)objDCClientInfo.CompanyName);
objDatabaseHelper.AddParameter("pAddressline1", objDCClientInfo.Addressline1 == string.Empty ? DBNull.Value : (object)objDCClientInfo.Addressline1);
objDatabaseHelper.AddParameter("pAddressline2", objDCClientInfo.Addressline2 == string.Empty ? DBNull.Value : (object)objDCClientInfo.Addressline2);
objDatabaseHelper.AddParameter("pAddressline3", objDCClientInfo.Addressline3 == string.Empty ? DBNull.Value : (object)objDCClientInfo.Addressline3);
objDatabaseHelper.AddParameter("pCityOrProvince", objDCClientInfo.CityProvince == string.Empty ? DBNull.Value : (Object)objDCClientInfo.CityProvince);
objDatabaseHelper.AddParameter("pCountry", objDCClientInfo.Country == string.Empty ? DBNull.Value : (object)objDCClientInfo.Country);
objDatabaseHelper.AddParameter("pState", objDCClientInfo.State == string.Empty ? DBNull.Value : (object)objDCClientInfo.State);
objDatabaseHelper.AddParameter("pZipCode", objDCClientInfo.ZipCode == string.Empty ? DBNull.Value : (object)objDCClientInfo.ZipCode);
objDatabaseHelper.AddParameter("pOfficePhone", objDCClientInfo.OfficePhone == string.Empty ? DBNull.Value : (object)objDCClientInfo.OfficePhone);
objDatabaseHelper.AddParameter("pMobilePhone", objDCClientInfo.MobilePhone == string.Empty ? DBNull.Value : (object)objDCClientInfo.MobilePhone);
objDatabaseHelper.AddParameter("pUserID", objDCClientInfo.UserId == 0 ? DBNull.Value : (object)objDCClientInfo.UserId);
DbDataReader reader = objDatabaseHelper.ExecuteReader(BLDBRoutines.SP_ADDUPDATECLIENTINFO, CommandType.StoredProcedure);
if (reader.HasRows)
{
while (reader.Read())
{
objDCClientInfo = new DCClientInfo();
objDCClientInfo.ClientId = reader.IsDBNull(reader.GetOrdinal("ClientId")) ? 0 : reader.GetInt32(reader.GetOrdinal("ClientId"));
objDCClientInfo.UserId = reader.IsDBNull(reader.GetOrdinal("UserId")) ? 0 : reader.GetInt32(reader.GetOrdinal("UserId"));
objDCClientInfo.ContactTitle = reader.IsDBNull(reader.GetOrdinal("ContactTitle")) ? string.Empty : reader.GetString(reader.GetOrdinal("ContactTitle"));
objDCClientInfo.FirstName = reader.IsDBNull(reader.GetOrdinal("FirstName")) ? string.Empty : reader.GetString(reader.GetOrdinal("FirstName"));
objDCClientInfo.LastName = reader.IsDBNull(reader.GetOrdinal("LastName")) ? string.Empty : reader.GetString(reader.GetOrdinal("LastName"));
objDCClientInfo.EmailAddress = reader.IsDBNull(reader.GetOrdinal("Email")) ? string.Empty : reader.GetString(reader.GetOrdinal("Email"));
objDCClientInfo.CompanyName = reader.IsDBNull(reader.GetOrdinal("CompanyName")) ? string.Empty : reader.GetString(reader.GetOrdinal("CompanyName"));
objDCClientInfo.Addressline1 = reader.IsDBNull(reader.GetOrdinal("Addressline1")) ? string.Empty : reader.GetString(reader.GetOrdinal("Addressline1"));
objDCClientInfo.Addressline2 = reader.IsDBNull(reader.GetOrdinal("Addressline2")) ? string.Empty : reader.GetString(reader.GetOrdinal("Addressline2"));
objDCClientInfo.Addressline3 = reader.IsDBNull(reader.GetOrdinal("Addressline3")) ? string.Empty : reader.GetString(reader.GetOrdinal("Addressline3"));
objDCClientInfo.CityProvince = reader.IsDBNull(reader.GetOrdinal("CityOrProvince")) ? string.Empty : reader.GetString(reader.GetOrdinal("CityOrProvince"));
objDCClientInfo.State = reader.IsDBNull(reader.GetOrdinal("State")) ? string.Empty : reader.GetString(reader.GetOrdinal("State"));
objDCClientInfo.ZipCode = reader.IsDBNull(reader.GetOrdinal("ZipCode")) ? string.Empty : reader.GetString(reader.GetOrdinal("ZipCode"));
objDCClientInfo.OfficePhone = reader.IsDBNull(reader.GetOrdinal("OfficePhone")) ? string.Empty : reader.GetString(reader.GetOrdinal("OfficePhone"));
objDCClientInfo.MobilePhone = reader.IsDBNull(reader.GetOrdinal("MobilePhone")) ? string.Empty : reader.GetString(reader.GetOrdinal("MobilePhone"));
objDCClientInfo.Country = reader.IsDBNull(reader.GetOrdinal("Country")) ? string.Empty : reader.GetString(reader.GetOrdinal("Country"));
lstDCClientInfo.Add(objDCClientInfo);
}
}
return(lstDCClientInfo);
}
catch (Exception exce)
{
throw exce;
}
finally
{
if (objDatabaseHelper != null)
{
objDatabaseHelper.Dispose();
}
}
}
/// <summary>
/// This method is used for Add Update Users
/// </summary>
/// <param name="frmColl"></param>
/// <param name="UserId"></param>
/// <returns></returns>
public ActionResult AddUpdateUsers(FormCollection frmColl)
{
if (Session["UserLogon"] != null)
{
objDCUsers = new DCUsers();
//if (!string.IsNullOrEmpty(frmColl["btnSave"]) && string.Compare(frmColl["btnSave"].ToUpper(), "SAVE") == 0)
objDataOperationResponse = new DataOperationResponse();
objBLUsers = new BLUsers();
StringBuilder objStrBuilder = new StringBuilder();
if (!string.IsNullOrEmpty(frmColl["ddlAssessmentType"]))
{
string[] strUserAssessmentTypeIds = frmColl["ddlAssessmentType"].Split(',');
objStrBuilder.Append("<UserAssessmentTypeIds>");
foreach (string UserAssessmentTypeId in strUserAssessmentTypeIds)
{
objStrBuilder.Append("<UserAssessmentTypeId>" + Convert.ToInt32(UserAssessmentTypeId) + "</UserAssessmentTypeId>");
}
objStrBuilder.Append("</UserAssessmentTypeIds>");
}
objDCUsers.UserId = string.IsNullOrEmpty(frmColl["hdnUserId"]) ? 0 : Convert.ToInt32(frmColl["hdnUserId"]);
objDCUsers.FirstName = frmColl["txtFirstName"];
objDCUsers.LastName = frmColl["txtLastName"];
objDCUsers.EmailAddress = frmColl["txtEmail"];
objDCUsers.SponsorApproval = frmColl["ddlSponserApproval"];
objDCUsers.ExpiryDate = Convert.ToDateTime(frmColl["txtExpiryDate"]);
if (Convert.ToInt32(frmColl["ddlClientName"]) == 0)
{
objDCUsers.ClientName = frmColl["txtNewClientName"];
objDCUsers.ClientNameAbbr = frmColl["txtClientNameABBR"];
}
else
{
objDCUsers.ClientName = frmColl["hdnClientName"];
}
if (Convert.ToInt32(frmColl["ddlSponserName"]) == 0)
{
objDCUsers.SponserName = frmColl["txtNewSponserName"];
objDCUsers.SponserNameAbbr = frmColl["txtSponserNameABBR"];
}
else
{
objDCUsers.SponserName = frmColl["hdnSponserName"];
}
if (Convert.ToInt32(frmColl["ddlProtocalName"]) == 0)
{
objDCUsers.ProtocalName = frmColl["txtNewProtocalName"];
objDCUsers.ProtocolNameAbbr = frmColl["txtProtocolNameABBR"];
}
else
{
objDCUsers.ProtocalName = frmColl["hdnProtocalName"];
}
string XMLData = objStrBuilder.ToString();
objDataOperationResponse = objBLUsers.AddUpdateUser(objDCUsers, XMLData);
if (objDataOperationResponse.Code > 0)
{
if (objDCUsers.UserId == 0)
{
string strMessage = string.Empty;
string strPassword = string.Empty;
objDCUsers = (DCUsers)Session["UserLogon"];
EmailAttributesModel objEmailAttributes = new EmailAttributesModel();
objEmailAttributes.Subject = "Welcome to the IRMA™ Onboarding Portal";
string imagePath = Server.MapPath(@"~/Images/mail.png");
var linkedResource = new LinkedResource(imagePath, MediaTypeNames.Image.Jpeg);
linkedResource.ContentId = "logoImage";
string body = "Hello " + frmColl["txtFirstName"] + "," + " <br/><br/>" + "Welcome to Adaptive Risk Systems (ARS™) Intelligent Risk Monitoring Assessment ( IRMA™) Onboarding application [" + AppConfig.IRMAVERSION + "]. The web-link to login to the IRMA™ Onboarding portal and user name details are provided below. Password will be provided in a separate email."
+ "<br/><br/>" + "<b style='margin-left:30px;'> IRMA™ Onboarding web-link:</b> <a href='http://onboarding.besymple.com/'> http://onboarding.besymple.com/ </a>" + "<br/><b style='margin-left:30px;'>User Name: </b>" + frmColl["txtEmail"] + "<br/><b style='margin-left:30px;'> Password:</b> to be provided in a separate email<br/><br/>" + " Please contact the applicable support group for any questions or assistance:" + "<br/><br/>"
+ "<li style='margin-left:30px;'>Adaptive Risk System (ARS™) support team for questions related to the use of the IRMA™ Onboarding and/or Live applications.</li>"
+ "<li type='circle' style='margin:5px 60px'> <a href='mailto:" + AppConfig.SMTPEmailARS + "'>" + AppConfig.SMTPEmailARS + " </a></li> "
+ "<li type='circle' style='margin:5px 60px'> Mobile: " + AppConfig.SMTPPHNNO + "</li>"
+ "<li style='margin-left:30px;'>IRMA™ IT support team for any questions related to logon, password or other IT related issues.</li>"
+ "<li type='circle' style='margin:5px 60px'> <a href='mailto:" + AppConfig.SMTPEmailIRMA + "'> " + AppConfig.SMTPEmailIRMA + " </a></li> "
+ "<br/><br/>" + " We will respond to emails within 24 hours of receipt." + "<br/><br/>" + " Thank you and have a great day!" + "<br/><b> IRMA™ Support Team</b>" + "<br/> <img src='cid:logoImage' alt='Red dot' width='122' height='48' />";
var altView = AlternateView.CreateAlternateViewFromString(body, null, "text/html");
altView.LinkedResources.Add(linkedResource);
objEmailAttributes.AlternateView = altView;
objEmailAttributes.MessageBody = body;
objEmailAttributes.From = AppConfig.SMTPEMAILFROM;
objEmailAttributes.To = frmColl["txtEmail"];
objEmailAttributes.CC = AppConfig.SMTPEmailCC;
strMessage = SendMail(objEmailAttributes);
EmailAttributesModel objEmailAttributesForPassword = new EmailAttributesModel();
objEmailAttributesForPassword.Subject = "";
string imagePathPwd = Server.MapPath(@"~/Images/mail.png");
var linkedResourcePwd = new LinkedResource(imagePathPwd, MediaTypeNames.Image.Jpeg);
linkedResourcePwd.ContentId = "logoImagePwd";
string bodyPwd = "Hello " + frmColl["txtFirstName"] + "," + " <br/><br/>" + "Welcome to Adaptive Risk Systems (ARS™) Intelligent Risk Monitoring Assessment ( IRMA™) Onboarding application [" + AppConfig.IRMAVERSION + "]."
+ "<br/><br/>" + frmColl["txtLastName"] + "<br/><br/>" + " Please contact the applicable support group for any questions or assistance:" + "<br/><br/>"
+ "<li style='margin-left:30px;'>Adaptive Risk System (ARS™) support team for questions related to the use of the IRMA™ Onboarding and/or Live applications.</li>"
+ "<li type='circle' style='margin:5px 60px'> <a href='mailto:" + AppConfig.SMTPEmailARS + "'>" + AppConfig.SMTPEmailARS + " </a></li> "
+ "<li type='circle' style='margin:5px 60px'> Mobile: " + AppConfig.SMTPPHNNO + "</li>"
+ "<li style='margin-left:30px;'>IRMA™ IT support team for any questions related to logon, password or other IT related issues.</li>"
+ "<li type='circle' style='margin:5px 60px'> <a href='mailto:" + AppConfig.SMTPEmailIRMA + "'> " + AppConfig.SMTPEmailIRMA + " </a></li> "
+ "<br/><br/>" + " We will respond to emails within 24 hours of receipt." + "<br/><br/>" + " Thank you and have a great day!" + "<br/><b> IRMA™ Support Team</b>" + "<br/> <img src='cid:logoImagePwd' alt='Red dot' width='122' height='48' />";
var altViewPwd = AlternateView.CreateAlternateViewFromString(bodyPwd, null, "text/html");
altViewPwd.LinkedResources.Add(linkedResourcePwd);
objEmailAttributesForPassword.AlternateView = altViewPwd;
objEmailAttributesForPassword.MessageBody = bodyPwd;
objEmailAttributesForPassword.From = AppConfig.SMTPEMAILFROM;
objEmailAttributesForPassword.To = frmColl["txtEmail"];
objEmailAttributesForPassword.CC = "";
strPassword = SendMail(objEmailAttributesForPassword);
}
objDCUsers.Activetab = frmColl["hdnActivetab"];
if (objDCUsers.Activetab == "1")
{
if (objDataOperationResponse.Code > 0)
{
TempData["successMessage"] = objDataOperationResponse.Message;
}
else
{
TempData["errorMessage"] = objDataOperationResponse.Message;
}
TempData["hdnActivetab"] = "1";
return(Redirect("~/User/ViewUsers"));
}
else
{
TempData["hdnActivetab"] = "2";
return(Json(objDataOperationResponse, JsonRequestBehavior.AllowGet));
}
}
else
{
objDCUsers.Activetab = frmColl["hdnActivetab"];
if (objDCUsers.Activetab == "1")
{
TempData["hdnActivetab"] = "1";
TempData["errorMessage"] = objDataOperationResponse.Message;
return(Redirect("~/User/ViewUsers"));
}
else
{
TempData["hdnActivetab"] = "2";
return(Json(objDataOperationResponse.Message, JsonRequestBehavior.AllowGet));
}
}
//return View("ViewUsers");
}
else
{
return(Redirect("~/Account/Login"));
}
}
/// <summary>
/// This method is used for Delete Question
/// </summary>
/// <param name="QuestionID"></param>
/// <returns></returns>
public string DeleteQuestion(string QuestionID)
{
objBLQuestions = new BLQuestions();
objDataOperationResponse = objBLQuestions.DeleteQuestion(Convert.ToInt32(QuestionID));
return(objDataOperationResponse.Message);
}
/// <summary>
/// This method is used for Delete Uers
/// </summary>
/// <param name="UserId"></param>
/// <returns></returns>
public string DeleteUers(string UserId)
{
objBLUsers = new BLUsers();
objDataOperationResponse = objBLUsers.DeleteUser(Convert.ToInt32(UserId));
return(objDataOperationResponse.Message);
}
