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