public static void AddCompanySettings(BusinessDbContext context)
{
if (context.CompanySettings.Any())
{
return;
}
var tenant = context.Tenants.FirstOrDefault(x => x.Name == StaticTenant.Host);
var company = context.Companies.FirstOrDefault(x => x.Name == StaticTenant.Host);
var id = Guid.NewGuid().ToString();
var companySettings = new CompanySetting
{
Id = id,
Active = true,
Created = DateTime.Now,
CreatedBy = null,
Modified = DateTime.Now,
ModifiedBy = null,
HostingValidTill = null,
PoweredBy = "Powered by www.datacrud.com",
TenantId = tenant?.Id,
CompanyId = company?.Id
};
context.CompanySettings.Add(companySettings);
context.SaveChanges();
}
public bool UpdateSettings(CompanySetting setting)
{
bool isUpdate = true;
using (SqlConnection connection = new SqlConnection(CommonUtility.ConnectionString))
{
SqlCommand command = new SqlCommand(StoreProcedure.UpdateCompanySettings, connection);
command.CommandType = CommandType.StoredProcedure;
foreach (var settings in setting.GetType().GetProperties())
{
string name = settings.Name;
var value = settings.GetValue(setting, null);
command.Parameters.Add(new SqlParameter("@" + name, value == null ? DBNull.Value : value));
}
try
{
connection.Open();
command.ExecuteNonQuery();
}
catch (Exception e)
{
isUpdate = false;
throw new Exception("Exception Updating Data." + e.Message);
}
finally
{
connection.Close();
}
}
return(isUpdate);
}
/// <summary>
///
/// </summary>
/// <param name="setting"></param>
/// <returns></returns>
public JsonResult SetSystemPreferences(CompanySetting setting)
{
var client2 = SvcBldr.CompanyV2();
ExceptionsML bizEx = null;
SR <CompanySetting> existingSetting = null;
if (setting.Id != Guid.Empty)
{
existingSetting = client2.Get(setting.Id);
}
if (existingSetting != null && existingSetting.Error != null)
{
return(Result(null, bizEx));
}
if (existingSetting == null)
{
setting.Id = Functions.NewSeq();
existingSetting = client2.Create(setting);
}
else
{
existingSetting = client2.Update(setting);
}
return(Result(existingSetting.Result, existingSetting.Error));
}
public CompanySetting GetCompanySettings(long Id)
{
using (SqlConnection connection = new SqlConnection(CommonUtility.ConnectionString))
{
SqlCommand command = new SqlCommand(StoreProcedure.GetCompanySetting, connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add(new SqlParameter("@Id", Id));
try
{
connection.Open();
SqlDataReader reader = command.ExecuteReader();
CompanySetting client = new CompanySetting();
client = UtilityManager.DataReaderMap <CompanySetting>(reader);
return(client);
}
catch (Exception e)
{
throw new Exception("Exception retrieving reviews. " + e.Message);
}
finally
{
connection.Close();
}
}
}
/// <summary>
/// Set company setting value
/// </summary>
/// <typeparam name="T">Type</typeparam>
/// <param name="key">Key</param>
/// <param name="value">Value</param>
/// <param name="companyId">Company identifier</param>
public virtual void SetCompanySetting <T>(string key, T value, int companyId)
{
if (key == null)
{
throw new ArgumentNullException(nameof(key));
}
var valueStr = CommonHelper.To <string>(value);
var companySetting = GetCompanySettingByKey(key, companyId);
// Update
if (companySetting != null)
{
companySetting.Value = valueStr;
_repository.Update(companySetting);
}
// Setting
else
{
companySetting = new CompanySetting
{
Key = key,
Value = valueStr,
CompanyId = companyId
};
_repository.Create(companySetting);
}
_repository.Save();
}
/// <summary>
/// Deletes a company setting
/// </summary>
/// <param name="companySetting">Company Setting</param>
public void DeleteCompanySetting(CompanySetting companySetting)
{
if (companySetting == null)
{
throw new ArgumentNullException(nameof(companySetting));
}
_repository.Delete(companySetting);
_repository.Save();
}
/// <summary>
/// 绑定默认值(送团人，集合地点，集合标志)
/// </summary>
private void BindDefaultValue()
{
EyouSoft.BLL.CompanyStructure.CompanySetting bll = new CompanySetting();
EyouSoft.Model.CompanyStructure.CompanyFieldSetting model = bll.GetSetting(this.SiteUserInfo.CompanyID);
if (model != null)
{
selectOperator1.OperId = model.SongTuanRenId;
selectOperator1.OperName = model.SongTuanRenName;
txtPlace.Text = model.JiHeDiDian;
txtLogo.Text = model.JiHeBiaoZhi;
}
}
/// <summary>
/// 绑定默认值(送团人，集合地点，集合标志)
/// </summary>
private void BindDefaultValue()
{
EyouSoft.BLL.CompanyStructure.CompanySetting bll = new CompanySetting();
EyouSoft.Model.CompanyStructure.CompanyFieldSetting model = bll.GetSetting(this.SiteUserInfo.CompanyID);
if (model != null)
{
SelectgroupPepole.OperId = model.SongTuanRenId;
SelectgroupPepole.OperName = model.SongTuanRenName;
txt_jh_area.Text = model.JiHeDiDian;
txt_jh_logo.Text = model.JiHeBiaoZhi;
}
}
public void Can_create_companySetting()
{
var companySetting = new CompanySetting
{
Key = "Setting1",
Value = "Value1",
CompanyId = 1
};
Assert.Equal("Setting1", companySetting.Key);
Assert.Equal("Value1", companySetting.Value);
Assert.Equal(1, companySetting.CompanyId);
}
public void Can_add_company_setting()
{
var company = new Company
{
Name = "test"
};
var companySetting = new CompanySetting {
Id = 1
};
company.CompanySettings.Add(companySetting);
Assert.Equal(1, company.CompanySettings.Count);
Assert.Equal(1, company.CompanySettings.First().Id);
}
public string CreateTenantCompanySettings(string tenantId, Company company)
{
var id = Guid.NewGuid().ToString();
CompanySetting companySetting = new CompanySetting
{
Active = true,
Created = DateTime.Now,
CreatedBy = null,
Modified = null,
ModifiedBy = null,
Id = id,
CustomerInvoiceTermsAndConditions = null,
SaleVatPercentage = 0,
IsUseDefaultSettings = true,
IsEnableEmailNotification = true,
IsSendEmailToAdminForTransaction = true,
IsEnableSmsNotification = true,
IsSendSmsToCustomerForTransaction = true,
HostingValidTill = null,
PoweredBy = AppConst.PoweredBy,
TenantId = tenantId,
CompanyId = company.Id,
};
if (companySetting.IsUseDefaultSettings)
{
companySetting.EmailSenderDisplayName = company?.Name;
companySetting.NotificationSenderEmail = company?.Email;
}
_companySettingsRepository.CreateAsHost(companySetting);
_companySettingsRepository.Commit();
return(id);
}
public CompanySettingView()
{
this.Settings = new List <CompanySetting>();
this.NewSetting = new CompanySetting();
}
public CompanySettingsAccountInfoViewModel(CompanySetting model)
{
PoweredBy = model.PoweredBy;
HasYearlyHostingCharge = model.HasYearlyHostingCharge;
HostingValidTill = model.HostingValidTill;
}
public static bool UpdateSettings(CompanySetting setting)
{
SqlCompanySettingsProvider provider = new SqlCompanySettingsProvider();
return(provider.UpdateSettings(setting));
}
