protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_MD_CAP_1503 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_Guid();
//Put your code here
IAccountServiceProvider accountService;
var _providerFactory = ProviderFactory.Instance;
accountService = _providerFactory.CreateAccountServiceProvider();
List <String> MailToL = new List <String>();
Guid accountId = Guid.NewGuid();
String accountMail = "";
String displayName = "";
if (Parameter.Type == "Arzt")
{
var account = cls_Get_Doctor_AccountID_for_DoctorID.Invoke(Connection, Transaction, new P_DO_GDAIDfDID_1549()
{
DoctorID = Parameter.PassID
}, securityTicket).Result;
accountId = account.accountID;
accountMail = account.accountMail;
MailToL.Add(accountMail);
displayName = account.DisplayName;
var doctorDetails = cls_Get_Doctor_Details_for_DoctorID.Invoke(Connection, Transaction, new P_DO_GDDfDID_0823()
{
DoctorID = Parameter.PassID
}, securityTicket).Result.Single();
string maildoc = null;
if (doctorDetails.DoctorComunication.Where(k => k.Type == "Email").SingleOrDefault() != null)
{
maildoc = doctorDetails.DoctorComunication.Where(k => k.Type == "Email").Single().Content;
}
if (maildoc != null && maildoc != accountMail)
{
MailToL.Add(maildoc);
}
}
else if (Parameter.Type == "Praxis")
{
var account = cls_Get_Practice_AccountID_for_PracticeID.Invoke(Connection, Transaction, new P_DO_GPAIDfPID_1351()
{
PracticeID = Parameter.PassID
}, securityTicket).Result;
accountId = account.accountID;
accountMail = account.accountMail;
MailToL.Add(accountMail);
displayName = account.DisplayName;
var practiceDetails = cls_Get_Practice_Details_for_PracticeID.Invoke(Connection, Transaction, new P_DO_GPDfPID_1432()
{
PracticeID = Parameter.PassID
}, securityTicket).Result;
string mailPractice = practiceDetails.FirstOrDefault().contact_email;
if (mailPractice != null && mailPractice != accountMail)
{
MailToL.Add(mailPractice);
}
}
else if (Parameter.Type == "Mitarbeiter")
{
var account = ORM_USR_Account.Query.Search(Connection, Transaction, new ORM_USR_Account.Query()
{
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID,
USR_AccountID = Parameter.PassID
}).Single();
accountId = account.USR_AccountID;
accountMail = account.AccountSignInEmailAddress;
MailToL.Add(accountMail);
displayName = account.Username;
var User = cls_Get_Account_Information_for_AccountID.Invoke(Connection, Transaction, new P_MD_GAIfAID_1436()
{
UserAccountID = Parameter.PassID
}, securityTicket).Result;
string userMail = User.Contact.Length != 0 ? User.Contact.Where(usr => usr.Type == "Email").SingleOrDefault() != null?User.Contact.Where(usr => usr.Type == "Email").SingleOrDefault().Content : null : null;
if (userMail != null && userMail != accountMail)
{
MailToL.Add(userMail);
}
}
BOp.Providers.TMS.Requests.ResetPasswordRequest request = new BOp.Providers.TMS.Requests.ResetPasswordRequest();
request.AccountID = accountId;
request.NewPassword = Parameter.Password;
request.SessionToken = securityTicket.SessionTicket;
accountService.ResetPassword(request);
Thread.CurrentThread.CurrentUICulture = CultureInfo.GetCultureInfo("de-DE");
string appName = WebConfigurationManager.AppSettings["mmAppUrl"];
var prefix = HttpContext.Current.Request.Url.AbsoluteUri.Contains("https") ? "https://" : "http://";
var imageUrl = HttpContext.Current.Request.Url.AbsoluteUri.Substring(0, HttpContext.Current.Request.Url.AbsoluteUri.IndexOf("api")) + "Content/images/logo.png";
var email_template = File.ReadAllText(HttpContext.Current.Server.MapPath("~/EmailTemplates/PasswordChangedEmailTemplate.html"));
var subjectsJson = File.ReadAllText(HttpContext.Current.Server.MapPath("~/EmailTemplates/EmailSubjects.json"));
dynamic subjects = JsonConvert.DeserializeObject(subjectsJson);
var subjectMail = subjects["NewPasswordSubject"].ToString();
email_template = EmailTemplater.SetTemplateData(email_template, new
{
name = displayName,
password = Parameter.Password,
mmapp_dashboard_url = prefix + HttpContext.Current.Request.Url.Authority + "/" + appName,
medios_connect_logo_url = imageUrl
}, "{{", "}}");
try
{
string mailFrom = WebConfigurationManager.AppSettings["mailFrom"];
var mailsDistinct = MailToL.Distinct().ToList();
foreach (var mailTo in mailsDistinct)
{
if (!String.IsNullOrEmpty(mailTo))
{
EmailNotificationSenderUtil.SendEmail(mailFrom, mailTo, subjectMail, email_template);
}
}
}
catch (Exception ex)
{
LogUtils.Logger.LogDocAppInfo(new LogUtils.LogEntry(System.Reflection.MethodInfo.GetCurrentMethod(), ex, null, "Change account password: Email sending failed."), "EmailExceptions");
}
return(returnValue);
#endregion UserCode
}
///<summary>
/// Invokes the method for the given Connection, and Transaction, leaving them open/not commited if no exceptions occured
///<summary>
public static FR_Guid Invoke(DbConnection Connection, DbTransaction Transaction, P_MD_CAP_1503 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
return(Invoke(Connection, Transaction, null, Parameter, securityTicket));
}
///<summary>
/// Method Invocation of wrapper classes
///<summary>
protected static FR_Guid Invoke(DbConnection Connection, DbTransaction Transaction, string ConnectionString, P_MD_CAP_1503 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
bool cleanupConnection = Connection == null;
bool cleanupTransaction = Transaction == null;
FR_Guid functionReturn = new FR_Guid();
try
{
if (cleanupConnection == true)
{
Connection = CSV2Core_MySQL.Support.DBSQLSupport.CreateConnection(ConnectionString);
Connection.Open();
}
if (cleanupTransaction == true)
{
Transaction = Connection.BeginTransaction();
}
functionReturn = Execute(Connection, Transaction, Parameter, securityTicket);
#region Cleanup Connection/Transaction
//Commit the transaction
if (cleanupTransaction == true)
{
Transaction.Commit();
}
//Close the connection
if (cleanupConnection == true)
{
Connection.Close();
}
#endregion
}
catch (Exception ex)
{
try
{
if (cleanupTransaction == true && Transaction != null)
{
Transaction.Rollback();
}
}
catch { }
try
{
if (cleanupConnection == true && Connection != null)
{
Connection.Close();
}
}
catch { }
throw new Exception("Exception occured in method cls_Change_Account_Password", ex);
}
return(functionReturn);
}
///<summary>
/// Opens the connection/transaction for the given connectionString, and closes them when complete
///<summary>
public static FR_Guid Invoke(string ConnectionString, P_MD_CAP_1503 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
return(Invoke(null, null, ConnectionString, Parameter, securityTicket));
}