protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L6US_SURT_0947 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
//Leave UserCode region to enable user code saving
#region UserCode
var returnValue = new FR_Guid();
//Put your code here
//Save usr_account_applicationsetting-definition
ORM_USR_Account_ApplicationSetting_Definition SettingsDefinition = new ORM_USR_Account_ApplicationSetting_Definition();
ORM_USR_Account_ApplicationSetting_Definition.Query ApplicationSettingsDefinitionQuery = new ORM_USR_Account_ApplicationSetting_Definition.Query();
ApplicationSettingsDefinitionQuery.ApplicationID = STDL_ApplicationIdentification.ApplicationID;
ApplicationSettingsDefinitionQuery.ItemKey = EnumUtils.GetEnumDescription(RunningTimes.Item_Key);
ApplicationSettingsDefinitionQuery.Tenant_RefID = securityTicket.TenantID;
ApplicationSettingsDefinitionQuery.IsDeleted = false;
if (!ORM_USR_Account_ApplicationSetting_Definition.Query.Exists(Connection, Transaction, ApplicationSettingsDefinitionQuery))
{
SettingsDefinition.ApplicationID = STDL_ApplicationIdentification.ApplicationID;
SettingsDefinition.DefaultValue = Parameter.RunningTimesXML;
SettingsDefinition.ItemKey = EnumUtils.GetEnumDescription(RunningTimes.Item_Key);
SettingsDefinition.Tenant_RefID = securityTicket.TenantID;
SettingsDefinition.Save(Connection, Transaction);
}
else
{
SettingsDefinition = ORM_USR_Account_ApplicationSetting_Definition.Query.Search(Connection, Transaction, ApplicationSettingsDefinitionQuery).FirstOrDefault();
SettingsDefinition.DefaultValue = Parameter.RunningTimesXML;
SettingsDefinition.Save(Connection, Transaction);
}
ORM_USR_Account_ApplicationSetting ApplicationSettings = new ORM_USR_Account_ApplicationSetting();
ORM_USR_Account_ApplicationSetting.Query ApplicationSettingsQuery = new ORM_USR_Account_ApplicationSetting.Query();
ApplicationSettingsQuery.Account_RefID = securityTicket.AccountID;
ApplicationSettingsQuery.ApplicationSetting_Definition_RefID = SettingsDefinition.USR_Account_ApplicationSetting_DefinitionID;
if (!ORM_USR_Account_ApplicationSetting.Query.Exists(Connection, Transaction, ApplicationSettingsQuery))
{
ApplicationSettings.Account_RefID = securityTicket.AccountID;
ApplicationSettings.ApplicationSetting_Definition_RefID = SettingsDefinition.USR_Account_ApplicationSetting_DefinitionID;
ApplicationSettings.ItemValue = EnumUtils.GetEnumDescription(RunningTimes.Item_Key);
ApplicationSettings.Tenant_RefID = securityTicket.TenantID;
ApplicationSettings.Save(Connection, Transaction);
}
return(returnValue);
#endregion UserCode
}
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L2USR_SAS_1039 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
var returnValue = new FR_Guid();
var item = new ORM_USR_Account_ApplicationSetting();
if (Parameter.USR_Account_ApplicationSettingID != Guid.Empty)
{
var result = item.Load(Connection, Transaction, Parameter.USR_Account_ApplicationSettingID);
if (result.Status != FR_Status.Success || item.USR_Account_ApplicationSettingID == Guid.Empty)
{
var error = new FR_Guid();
error.ErrorMessage = "No Such ID";
error.Status = FR_Status.Error_Internal;
return(error);
}
}
if (Parameter.IsDeleted == true)
{
item.IsDeleted = true;
return(new FR_Guid(item.Save(Connection, Transaction), item.USR_Account_ApplicationSettingID));
}
//Creation specific parameters (Tenant, Account ... )
if (Parameter.USR_Account_ApplicationSettingID == Guid.Empty)
{
item.Tenant_RefID = securityTicket.TenantID;
}
item.Account_RefID = Parameter.Account_RefID;
item.ApplicationSetting_Definition_RefID = Parameter.ApplicationSetting_Definition_RefID;
item.ItemValue = Parameter.ItemValue;
return(new FR_Guid(item.Save(Connection, Transaction), item.USR_Account_ApplicationSettingID));
}
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_MD_SAU_1236 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_Guid();
//Put your code here
Thread.CurrentThread.CurrentUICulture = CultureInfo.GetCultureInfo("de-DE");
IAccountServiceProvider accountService;
var _providerFactory = ProviderFactory.Instance;
accountService = _providerFactory.CreateAccountServiceProvider();
var accId = Guid.NewGuid();
if (Parameter.UserID == Guid.Empty)
{
if (!String.IsNullOrEmpty(Parameter.LoginEmail))
{
string[] stringUser = Parameter.LoginEmail.Split('@');
string usernameStr = stringUser[0];
Person UserAccount = new Person();
UserAccount.FirstName = Parameter.FirstName;
UserAccount.LastName = Parameter.LastName;
UserAccount.Title = string.IsNullOrEmpty(Parameter.Title) ? "" : Parameter.Title;
Account account = new Account();
account.Person = UserAccount;
account.ID = accId;
account.TenantID = securityTicket.TenantID;
account.Email = Parameter.LoginEmail;
account.PasswordHash = Parameter.inPassword;
account.Username = usernameStr;
account.AccountType = EAccountType.Standard;
account.Verified = true;
accountService.CreateAccount(account, securityTicket.SessionTicket);
accountService.VerifyAccount(account.ID);
try
{
string emailTo = Parameter.LoginEmail;
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/NewUserTemplate.html"));
var subjectsJson = File.ReadAllText(HttpContext.Current.Server.MapPath("~/EmailTemplates/EmailSubjects.json"));
dynamic subjects = Newtonsoft.Json.JsonConvert.DeserializeObject(subjectsJson);
var subjectMail = subjects["NewUserSubject"].ToString();
email_template = EmailTemplater.SetTemplateData(email_template, new
{
first_name = Parameter.FirstName,
salutation = Parameter.Salutation,
last_name = Parameter.LastName,
title = Parameter.Title,
password = Parameter.inPasswordMail,
mm_app_url = prefix + HttpContext.Current.Request.Url.Authority + "/" + appName,
medios_connect_logo_url = imageUrl
}, "{{", "}}");
//string mailFrom = cls_Get_Company_Settings.Invoke(Connection, Transaction, securityTicket).Result.Email;
string mailFrom = WebConfigurationManager.AppSettings["mailFrom"];
EmailNotificationSenderUtil.SendEmail(mailFrom, emailTo, subjectMail, email_template);
}
catch (Exception ex)
{
LogUtils.Logger.LogDocAppInfo(new LogUtils.LogEntry(System.Reflection.MethodInfo.GetCurrentMethod(), ex, null, "Add new user: Email sending failed."), "EmailExceptions");
}
var userAccountInfo = ORM_USR_Account.Query.Search(Connection, Transaction, new ORM_USR_Account.Query()
{
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID,
USR_AccountID = accId
}).Single();
var businesParticipant = ORM_CMN_BPT_BusinessParticipant.Query.Search(Connection, Transaction, new ORM_CMN_BPT_BusinessParticipant.Query()
{
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID,
CMN_BPT_BusinessParticipantID = userAccountInfo.BusinessParticipant_RefID
}).SingleOrDefault();
if (businesParticipant != null)
{
businesParticipant.DisplayName = Parameter.FirstName + " " + Parameter.LastName;
businesParticipant.IfNaturalPerson_CMN_PER_PersonInfo_RefID = Guid.NewGuid();
businesParticipant.IsNaturalPerson = true;
businesParticipant.Modification_Timestamp = DateTime.Now;
businesParticipant.Save(Connection, Transaction);
var companyInfoUser = new ORM_CMN_PER_PersonInfo();
companyInfoUser.IsDeleted = false;
companyInfoUser.Tenant_RefID = securityTicket.TenantID;
companyInfoUser.CMN_PER_PersonInfoID = businesParticipant.IfNaturalPerson_CMN_PER_PersonInfo_RefID;
companyInfoUser.FirstName = Parameter.FirstName;
companyInfoUser.LastName = Parameter.LastName;
companyInfoUser.Salutation_General = Parameter.Salutation;
companyInfoUser.Title = Parameter.Title;
companyInfoUser.Save(Connection, Transaction);
var communicationContact = new ORM_CMN_PER_CommunicationContact();
communicationContact.IsDeleted = false;
communicationContact.Contact_Type = Guid.NewGuid();
communicationContact.Tenant_RefID = securityTicket.TenantID;
communicationContact.Modification_Timestamp = DateTime.Now;
communicationContact.PersonInfo_RefID = businesParticipant.IfNaturalPerson_CMN_PER_PersonInfo_RefID;
communicationContact.Content = Parameter.Email;
communicationContact.Save(Connection, Transaction);
var communicationContactType = new ORM_CMN_PER_CommunicationContact_Type();
communicationContactType.IsDeleted = false;
communicationContactType.Tenant_RefID = securityTicket.TenantID;
communicationContactType.CMN_PER_CommunicationContact_TypeID = communicationContact.Contact_Type;
communicationContactType.Type = "Email";
communicationContactType.Save(Connection, Transaction);
var communicationContactPhone = new ORM_CMN_PER_CommunicationContact();
communicationContactPhone.IsDeleted = false;
communicationContactPhone.Contact_Type = Guid.NewGuid();
communicationContactPhone.Tenant_RefID = securityTicket.TenantID;
communicationContactPhone.Modification_Timestamp = DateTime.Now;
communicationContactPhone.PersonInfo_RefID = businesParticipant.IfNaturalPerson_CMN_PER_PersonInfo_RefID;
communicationContactPhone.Content = Parameter.Phone;
communicationContactPhone.Save(Connection, Transaction);
var communicationContactTypePhone = new ORM_CMN_PER_CommunicationContact_Type();
communicationContactTypePhone.IsDeleted = false;
communicationContactTypePhone.Tenant_RefID = securityTicket.TenantID;
communicationContactTypePhone.CMN_PER_CommunicationContact_TypeID = communicationContactPhone.Contact_Type;
communicationContactTypePhone.Type = "Phone";
communicationContactTypePhone.Save(Connection, Transaction);
var accountAppSettings = new ORM_USR_Account_ApplicationSetting();
accountAppSettings.IsDeleted = false;
accountAppSettings.Account_RefID = accId;
accountAppSettings.Creation_Timestamp = DateTime.Now;
accountAppSettings.Tenant_RefID = securityTicket.TenantID;
accountAppSettings.ItemValue = Parameter.ReceiveNotification.ToString();
accountAppSettings.ApplicationSetting_Definition_RefID = Guid.NewGuid();
accountAppSettings.Save(Connection, Transaction);
var accountAppSettingsDefinitions = new ORM_USR_Account_ApplicationSetting_Definition();
accountAppSettingsDefinitions.IsDeleted = false;
accountAppSettingsDefinitions.Tenant_RefID = securityTicket.TenantID;
accountAppSettingsDefinitions.Creation_Timestamp = DateTime.Now;
accountAppSettingsDefinitions.USR_Account_ApplicationSetting_DefinitionID = accountAppSettings.ApplicationSetting_Definition_RefID;
accountAppSettingsDefinitions.ItemKey = "ReceiveNotification";
accountAppSettingsDefinitions.Save(Connection, Transaction);
}
}
}
else
{ //Edit existing user
accId = Parameter.UserID;
var userAccountInfo = ORM_USR_Account.Query.Search(Connection, Transaction, new ORM_USR_Account.Query()
{
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID,
USR_AccountID = Parameter.UserID
}).Single();
var businesParticipant = ORM_CMN_BPT_BusinessParticipant.Query.Search(Connection, Transaction, new ORM_CMN_BPT_BusinessParticipant.Query()
{
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID,
CMN_BPT_BusinessParticipantID = userAccountInfo.BusinessParticipant_RefID
}).SingleOrDefault();
if (businesParticipant != null)
{
businesParticipant.DisplayName = Parameter.FirstName + " " + Parameter.LastName;
businesParticipant.Modification_Timestamp = DateTime.Now;
businesParticipant.Save(Connection, Transaction);
var personInfo = ORM_CMN_PER_PersonInfo.Query.Search(Connection, Transaction, new ORM_CMN_PER_PersonInfo.Query()
{
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID,
CMN_PER_PersonInfoID = businesParticipant.IfNaturalPerson_CMN_PER_PersonInfo_RefID
}).SingleOrDefault();
if (personInfo != null)
{
personInfo.FirstName = Parameter.FirstName;
personInfo.LastName = Parameter.LastName;
personInfo.Salutation_General = Parameter.Salutation;
personInfo.Title = Parameter.Title;
personInfo.Save(Connection, Transaction);
var phone = cls_Get_Communication_Contact_Info_for_User_Person_Info.Invoke(Connection, Transaction, new P_MD_GCCIFUPID_1716()
{
CommunicationType = "Phone", PersonRefID = personInfo.CMN_PER_PersonInfoID
}, securityTicket).Result;
if (phone != null)
{
var communicationContact = ORM_CMN_PER_CommunicationContact.Query.Search(Connection, Transaction, new ORM_CMN_PER_CommunicationContact.Query()
{
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID,
PersonInfo_RefID = businesParticipant.IfNaturalPerson_CMN_PER_PersonInfo_RefID,
CMN_PER_CommunicationContactID = phone.CMN_PER_CommunicationContactID
}).SingleOrDefault();
communicationContact.Content = Parameter.Phone;
communicationContact.Save(Connection, Transaction);
}
else
{
var communicationContactPhone = new ORM_CMN_PER_CommunicationContact();
communicationContactPhone.IsDeleted = false;
communicationContactPhone.Contact_Type = Guid.NewGuid();
communicationContactPhone.Tenant_RefID = securityTicket.TenantID;
communicationContactPhone.Modification_Timestamp = DateTime.Now;
communicationContactPhone.PersonInfo_RefID = businesParticipant.IfNaturalPerson_CMN_PER_PersonInfo_RefID;
communicationContactPhone.Content = Parameter.Phone;
communicationContactPhone.Save(Connection, Transaction);
var communicationContactTypePhone = new ORM_CMN_PER_CommunicationContact_Type();
communicationContactTypePhone.IsDeleted = false;
communicationContactTypePhone.Tenant_RefID = securityTicket.TenantID;
communicationContactTypePhone.CMN_PER_CommunicationContact_TypeID = communicationContactPhone.Contact_Type;
communicationContactTypePhone.Type = "Phone";
communicationContactTypePhone.Save(Connection, Transaction);
}
var email = cls_Get_Communication_Contact_Info_for_User_Person_Info.Invoke(Connection, Transaction, new P_MD_GCCIFUPID_1716()
{
CommunicationType = "Email", PersonRefID = personInfo.CMN_PER_PersonInfoID
}, securityTicket).Result;
if (email != null)
{
var communicationContact = ORM_CMN_PER_CommunicationContact.Query.Search(Connection, Transaction, new ORM_CMN_PER_CommunicationContact.Query()
{
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID,
PersonInfo_RefID = businesParticipant.IfNaturalPerson_CMN_PER_PersonInfo_RefID,
CMN_PER_CommunicationContactID = email.CMN_PER_CommunicationContactID
}).SingleOrDefault();
communicationContact.Content = Parameter.Email;
communicationContact.Save(Connection, Transaction);
}
else
{
var communicationContactPhone = new ORM_CMN_PER_CommunicationContact();
communicationContactPhone.IsDeleted = false;
communicationContactPhone.Contact_Type = Guid.NewGuid();
communicationContactPhone.Tenant_RefID = securityTicket.TenantID;
communicationContactPhone.Modification_Timestamp = DateTime.Now;
communicationContactPhone.PersonInfo_RefID = businesParticipant.IfNaturalPerson_CMN_PER_PersonInfo_RefID;
communicationContactPhone.Content = Parameter.Email;
communicationContactPhone.Save(Connection, Transaction);
var communicationContactTypePhone = new ORM_CMN_PER_CommunicationContact_Type();
communicationContactTypePhone.IsDeleted = false;
communicationContactTypePhone.Tenant_RefID = securityTicket.TenantID;
communicationContactTypePhone.CMN_PER_CommunicationContact_TypeID = communicationContactPhone.Contact_Type;
communicationContactTypePhone.Type = "Email";
communicationContactTypePhone.Save(Connection, Transaction);
}
}
var appSettings = ORM_USR_Account_ApplicationSetting.Query.Search(Connection, Transaction, new ORM_USR_Account_ApplicationSetting.Query()
{
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID,
Account_RefID = accId
}).SingleOrDefault();
if (appSettings == null)
{
var accountAppSettings = new ORM_USR_Account_ApplicationSetting();
accountAppSettings.IsDeleted = false;
accountAppSettings.Account_RefID = accId;
accountAppSettings.Creation_Timestamp = DateTime.Now;
accountAppSettings.Tenant_RefID = securityTicket.TenantID;
accountAppSettings.ItemValue = Parameter.ReceiveNotification.ToString();
accountAppSettings.ApplicationSetting_Definition_RefID = Guid.NewGuid();
accountAppSettings.Save(Connection, Transaction);
var accountAppSettingsDefinitions = new ORM_USR_Account_ApplicationSetting_Definition();
accountAppSettingsDefinitions.IsDeleted = false;
accountAppSettingsDefinitions.Tenant_RefID = securityTicket.TenantID;
accountAppSettingsDefinitions.Creation_Timestamp = DateTime.Now;
accountAppSettingsDefinitions.USR_Account_ApplicationSetting_DefinitionID = accountAppSettings.ApplicationSetting_Definition_RefID;
accountAppSettingsDefinitions.ItemKey = "ReceiveNotification";
accountAppSettingsDefinitions.Save(Connection, Transaction);
}
else
{
appSettings.ItemValue = Parameter.ReceiveNotification.ToString();
appSettings.Save(Connection, Transaction);
}
var accountStatus = accountService.GetAccountStatusHistory(securityTicket.TenantID, Parameter.UserID).OrderBy(sth => sth.CreationTimestamp).Reverse().FirstOrDefault();
if (Parameter.isDeactivated == true)
{
if (accountStatus.Status != EAccountStatus.BANNED)
{
accountService.BanAccount(Parameter.UserID, "Konto wurde vom Administrator deaktiviert");
}
}
else
{
if (accountStatus.Status == EAccountStatus.BANNED)
{
accountService.UnbanAccount(Parameter.UserID);
}
}
}
}
P_MD_SPtMU_1433 PSaveUserPermisions = new P_MD_SPtMU_1433();
PSaveUserPermisions.AccountID = accId;
PSaveUserPermisions.Role = Parameter.isAdmin ? Properties.Settings.Default.MasterAccountMMApp : Properties.Settings.Default.RegularAccountMMApp;
PSaveUserPermisions.GroupName = Properties.Settings.Default.MMAppGroup;
cls_Save_Permisions_to_User.Invoke(Connection, Transaction, PSaveUserPermisions, securityTicket);
return(returnValue);
#endregion UserCode
}
