public bool ObjectExists(SettingDTO setting)
{
var objectExists = false;
var iDbContext = DbContextUtil.GetDbContextInstance();
try
{
var catRepository = new Repository <SettingDTO>(iDbContext);
var catExists = catRepository
.Query()
//.Filter(bp => bp.SettingName == setting.SettingName && bp.Id != setting.Id)
.Get()
.FirstOrDefault();
if (catExists != null)
{
objectExists = true;
}
}
finally
{
iDbContext.Dispose();
}
return(objectExists);
}
public static List <ErrorModel> RemoveUser(RemoveUserRequestModel request)
{
List <ErrorModel> errors = new List <ErrorModel>();
if (!DoesUserExist(request.Username))
{
errors.Add(new ErrorModel("user.no.exist"));
return(errors);
}
ChatLocoContext db = new ChatLocoContext();
UserDTO user = db.Users.FirstOrDefault(u => u.Username == request.Username);
if (user == null)
{
errors.Add(new ErrorModel("system.database.error"));
return(errors);
}
SettingDTO settings = db.Settings.FirstOrDefault(s => s.UserId == user.Id);
if (settings != null)
{
db.Settings.Remove(settings);
}
db.Users.Remove(user);
db.SaveChanges();
return(errors);
}
public static SettingDTO GetSettings(int userId)
{
ChatLocoContext DbContext = new ChatLocoContext();
SettingDTO settings = DbContext.Settings.Where(s => s.UserId == userId).FirstOrDefault();
return(settings);
}
public DataTable GetTotalTimeInAllClassesByStcode(string StudentCode)
{
SettingBusiness setb = new SettingBusiness();
StudentDAO s= new StudentDAO();
string term = s.GetLastTermBystcode(StudentCode);
DataTable dtTermJari = UD.GetTermJary();
string termJari = dtTermJari.Rows[0][0].ToString();
int salStudent = 0;
if (term!="")
salStudent=Convert.ToInt32( term.Split('-')[0]);
int jariSal = 0;
if(termJari!="")
jariSal = Convert.ToInt32( termJari.Split('-')[0]);
if (term==""|| salStudent<(jariSal-2))
return new DataTable() ;
SettingDTO setdto = setb.GetSettingByTermC(term);
if (setdto.ConName!="")
{
return spDAO.GetTotalTimeInAllClassesByStcode(StudentCode, term);
}
else
{
return new DataTable();
}
}
public IActionResult EditSetting(SettingDTO setting)
{
_loggerManager.Info($"EditSetting() POST was requested");
var result = false;
if (ModelState.IsValid)
{
result = _settingRepository.Set(setting.Index, setting.Value, HttpContext.GetUserId());
if (result)
{
_loggerManager.Info($"EditSetting() POST successfully updated");
}
else
{
_loggerManager.Warn($"EditSetting() POST was unable to update");
}
}
else
{
_loggerManager.Warn($"EditSetting() POST was invalid");
}
return(PartialView("~/Views/Manage/Partials/_EditSetting.cshtml", setting));
}
public SettingDTO[] GetAll()
{
using (ZSZDbContext ctx = new ZSZDbContext())
{
BaseService <SettingEntity> bs = new BaseService <SettingEntity>(ctx);
/*
* return bs.GetAll().Select(s => new SettingDTO
* {
* Id = s.Id,
* CreateDateTime = s.CreateDateTime,
* Name = s.Name,
* Value = s.Value
* }).ToArray();*/
List <SettingDTO> list = new List <SettingDTO>();
foreach (var setting in bs.GetAll())
{
SettingDTO dto = new SettingDTO();
dto.CreateDateTime = setting.CreateDateTime;
dto.Id = setting.Id;
dto.Name = setting.Name;
dto.Value = setting.Value;
list.Add(dto);
}
return(list.ToArray());
}
}
public static SettingDTO CreateSettings(int userId, string defaulthandle, string email)
{
ChatLocoContext DbContext = new ChatLocoContext();
try
{
SettingDTO setting = new SettingDTO()
{
UserId = userId,
DefaultHandle = defaulthandle,
Email = email
};
//add it to the table and commit the changes
DbContext.Settings.Add(setting);
DbContext.SaveChanges();
SettingsCache.Add(setting.Id, setting);
return(setting);
}
catch (Exception e)
{
return(null);
}
}
/// <summary>
/// Check that enum values for settings is defined
/// </summary>
/// <returns>ErrorCode if any settings is invalid else null</returns>
/// <param name="options">ref to <see cref="SettingDTO"/></param>
private ErrorCode?ValidateOptions(SettingDTO options)
{
if (!(Enum.IsDefined(typeof(Orientation), options.Orientation)) ||
!(Enum.IsDefined(typeof(CompleteMark), options.CompleteMark)) ||
!(Enum.IsDefined(typeof(CancelMark), options.CancelMark)) ||
!(Enum.IsDefined(typeof(DefaultTimer), options.DefaultTimer)) ||
!(Enum.IsDefined(typeof(Theme), options.Theme)))
{
return(ErrorCode.InvalidProperties);
}
if (options.NrOfDaysToDisplay < 1 || options.NrOfDaysToDisplay > 7)
{
return(ErrorCode.InvalidProperties);
}
if (options.ActivitiesCount.HasValue && options.ActivitiesCount.Value < 1)
{
return(ErrorCode.InvalidProperties);
}
if (options.TimerSeconds.HasValue && options.TimerSeconds.Value < 1)
{
return(ErrorCode.InvalidProperties);
}
return(null);
}
public async Task <IActionResult> UpdateSetting(SettingDTO update)
{
if (await _settingService.UpdateSetting(update))
{
return(NoContent());
}
return(BadRequest($"Updating setting {update.ID} failed on save"));
}
public virtual async Task <bool> SendSmtpExQQ()
{
SettingDTO dto = await SettingSvc.GetByKeyAsync("sendExQQEmail");
SmtpClient client = new SmtpClient("smtp.exmail.qq.com");
client.EnableSsl = true;
client.UseDefaultCredentials = false;
client.Credentials = new System.Net.NetworkCredential(dto.Key, dto.Value);//("*****@*****.**", "lm@SHUIMODANQING123");
client.Port = 587;
MailAddress from = new MailAddress(dto.Value, "NoRain论坛", Encoding.UTF8); //初始化发件人
MailAddress to = new MailAddress(Recipient, "", Encoding.UTF8); //初始化收件人
//设置邮件内容
MailMessage message = new MailMessage(from, to);
switch (SendType)
{
case SendType.Register:
message.Body = $"欢迎您注册NoRain论坛，你的验证码是{Code},20分钟内有效，请尽快填写。";
break;
case SendType.FoundPassword:
message.Body = $"找回密码，你的验证码是{Code},20分钟内有效，请尽快填写。";
break;
case SendType.ActiveEmail:
message.Body = $"激活邮箱，你的验证码是{Code},20分钟内有效，请尽快填写。";
break;
default:
message.Body = $"欢迎您注册NoRain论坛，你的验证码是{Code},20分钟内有效，请尽快填写。";
break;
}
message.BodyEncoding = Encoding.UTF8;
message.Subject = "NoRain论坛";
message.SubjectEncoding = Encoding.UTF8;
message.IsBodyHtml = true;
//发送邮件
try
{
client.Send(message);
return(true);
}
catch (Exception)
{
return(false);
}
finally
{
client.Dispose();
}
}
public async Task <IActionResult> UpdateSettings([FromBody] SettingDTO model, [FromHeader] string AuthenticationId, [FromHeader] string UserAgent, string settingType = "employee")
{
_logger.LogInformation("POST environment/{@settingType}", settingType);
if (string.IsNullOrEmpty(AuthenticationId) || string.IsNullOrEmpty(UserAgent))
{
throw new ApiException("Bạn không có quyền truy cập.", (int)HttpStatusCode.Unauthorized);
}
if (ModelState.IsValid)
{
model.SettingKey = model.SettingKey.Trim();
int typeSetting = settingType == "employee" ? (int)TypeSetting.EMPLPLOYEE : (int)TypeSetting.CUSTOMER;
var settingExist = _context.Settings.FirstOrDefault(s =>
s.SettingKey.ToLower().Equals(model.SettingKey.Trim().ToLower()) &&
s.SettingType == typeSetting &&
s.CreatedBy.Equals(AuthenticationId));
// if settingKey exist
if (settingExist != null)
{
// update
_context.Entry(settingExist).State = Microsoft.EntityFrameworkCore.EntityState.Modified;
settingExist.LastUpdated = DateTime.UtcNow;
settingExist.LastUpdatedBy = AuthenticationId;
settingExist.SettingValueVarchar = model.SettingValue;
settingExist.SettingDesc = model.SettingDesc;
}
else
{
// other Create
Setting setting = new Setting();
setting.CreatedBy = AuthenticationId;
setting.LastUpdatedBy = AuthenticationId;
setting.SettingType = typeSetting;
setting.SettingKey = model.SettingKey;
setting.SettingValueVarchar = model.SettingValue;
setting.SettingDesc = model.SettingDesc;
_context.Settings.Add(setting);
}
// save to database
try
{
await _context.SaveChangesAsync();
}
catch (System.Exception ex)
{
_logger.Log(LogLevel.Warning, "Có lỗi xảy ra khi update Settings", ex.Message);
#if DEBUG
throw new ApiException(ex);
#else
throw new ApiException("Có lỗi xảy ra khi update database");
#endif
}
}
return(Ok(1));
}
private SettingDTO ToDTO(SettingEntity entity)
{
SettingDTO dto = new SettingDTO();
dto.Id = entity.Id;
dto.Parm = entity.Parm;
dto.Name = entity.Name;
dto.TypeId = entity.TypeId;
return(dto);
}
private SettingDTO ToDTO(SettingEntity setting)
{
SettingDTO dto = new SettingDTO();
dto.Id = setting.Id;
dto.Name = setting.Name;
dto.Value = setting.Value;
dto.CreateDateTime = setting.CreateDateTIme;
return(dto);
}
public async Task <IActionResult> CreateSetting(SettingDTO create)
{
//create.CreatedDate = DateTime.Now;
if (await _settingService.AddSetting(create))
{
return(NoContent());
}
throw new Exception("Creating the setting failed on save");
}
public string Validate(SettingDTO setting)
{
if (setting == null)
{
return(GenericMessages.ObjectIsNull);
}
return(string.Empty);
}
public static Setting Map(this SettingDTO source)
{
Setting target = new Setting();
target.Id = source.Id;
target.IdUser = source.IdUser;
target.Name = source.Name;
target.Value = source.Value;
return(target);
}
public static SettingDTO SettingToDTO(Setting Setting)
{
if (Setting == null)
{
return(null);
}
Mapper.CreateMap <Setting, SettingDTO>();
SettingDTO SettingDTO = Mapper.Map <SettingDTO>(Setting);
return(SettingDTO);
}
public virtual async Task <bool> SendSmtpQQ()
{
SettingDTO dto = await SettingSvc.GetByKeyAsync("sendQQEmail");
SmtpClient client = new SmtpClient("smtp.qq.com");
client.EnableSsl = true;
client.UseDefaultCredentials = false;
client.Credentials = new System.Net.NetworkCredential(dto.Key, dto.Value); //("*****@*****.**", "jwrwtwthyxaobcje");
client.Port = 587;
MailAddress from = new MailAddress(dto.Key, "NoRain论坛", Encoding.UTF8); //初始化发件人
MailAddress to = new MailAddress(Recipient, Recipient, Encoding.UTF8); //初始化收件人
//设置邮件内容
MailMessage message = new MailMessage();
message.From = from;
message.To.Add(to);
switch (SendType)
{
case SendType.Register:
message.Body = $"欢迎您注册NoRain论坛，你的验证码是{Code},20分钟内有效，请尽快填写。";
break;
case SendType.FoundPassword:
message.Body = $"找回密码，你的验证码是{Code},20分钟内有效，请尽快填写。";
break;
case SendType.ActiveEmail:
message.Body = $"激活邮箱，你的验证码是{Code},20分钟内有效，请尽快填写。";
break;
default:
message.Body = $"欢迎您注册NoRain论坛，你的验证码是{Code},20分钟内有效，请尽快填写。";
break;
}
message.BodyEncoding = Encoding.UTF8;
message.Subject = "NoRain论坛";
message.SubjectEncoding = Encoding.UTF8;
message.IsBodyHtml = true;
//发送邮件
try
{
client.Send(message);
return(true);
}
finally
{
client.Dispose();
}
}
private SettingDTO TODTO(SettingEntity entity)
{
SettingDTO dto = new SettingDTO();
dto.CreateTime = entity.CreateTime;
dto.Id = entity.Id;
dto.Key = entity.Key;
dto.KeyPari = entity.KeyPari;
dto.Value = entity.Value;
return(dto);
}
/// <summary>
/// Method to get unicode message count.
/// </summary>
/// <param name="message"></param>
/// <returns></returns>
private static int GetUnicodeMessageCount(string message)
{
int specialCharCount = 0;
specialCharCount += message.Count(f => f == '^');
specialCharCount += message.Count(f => f == '{');
specialCharCount += message.Count(f => f == '}');
specialCharCount += message.Count(f => f == '\\');
specialCharCount += message.Count(f => f == '[');
specialCharCount += message.Count(f => f == ']');
specialCharCount += message.Count(f => f == '|');
specialCharCount += message.Count(f => f == '~');
specialCharCount += message.Count(f => f == '€');
int msgLength = message.Length + specialCharCount;
// MaxSMSLength, SMSBlockLength these two valus come from database
// Calculate the credits required to send this message.
string sErrlocation = "Calculating message count-500";
SettingDTO SettingDTO = new SettingDTO();
SettingDTO = SettingService.GetById(1);
int MAXSMSLENGTH = SettingDTO.UTFFirstMessageLength;
int SMSBLOCKLENGTH = SettingDTO.UTFSecondMessageLength;
if (msgLength <= MAXSMSLENGTH)
{
msgLength = 1;
return(1);
}
else
{
if (msgLength <= 134)
{
msgLength = 2;
return(2);
}
else
{
if (msgLength % SMSBLOCKLENGTH != 0)
{
return((msgLength / SMSBLOCKLENGTH) + 1);
}
else
{
return(msgLength / SMSBLOCKLENGTH);
}
}
}
}
public static Setting SettingToDomain(SettingDTO SettingDTO)
{
if (SettingDTO == null)
{
return(null);
}
Mapper.CreateMap <SettingDTO, Setting>();
Setting Setting = Mapper.Map <Setting>(SettingDTO);
return(Setting);
}
public void Update(SettingDTO newSetting)
{
var setting = _context.MedcenterAppSettings.Where(s => s.Name.Equals(newSetting.Name)).FirstOrDefault();
if (setting is null)
{
throw new MedcenterAppSettingsNotFoundException();
}
setting.Value = newSetting.Value;
_context.SaveChanges();
}
private SettingDTO ToDTO(SettingEntity entity)
{
SettingDTO dto = new SettingDTO();
dto.CreateTime = entity.CreateTime;
dto.Id = entity.Id;
dto.Name = entity.Name;
dto.Description = entity.Description;
dto.TypeName = entity.SettingType.Name;
dto.TypeDescription = entity.SettingType.Description;
dto.Parm = entity.Parm;
return(dto);
}
public IActionResult Put(SettingDTO setting)
{
try
{
_service.Update(setting);
}
catch (MedcenterAppSettingsNotFoundException)
{
return(NotFound());
}
return(Ok());
}
private SettingDTO ToDTO(SettingEntity entity)
{
SettingDTO dto = new SettingDTO();
dto.Id = entity.Id;
dto.LevelId = entity.LevelId;
dto.Name = entity.Name;
dto.Param = entity.Param;
dto.Remark = entity.Remark;
dto.TypeId = entity.TypeId;
dto.TypeName = entity.TypeName;
return(dto);
}
public async Task <bool> AddSetting(SettingDTO model)
{
try
{
var setting = _mapper.Map <Setting>(model);
_repoSetting.Add(setting);
return(await _repoSetting.SaveAll());
}
catch (System.Exception)
{
throw;
}
}
public IActionResult EditSetting(string index)
{
_loggerManager.Info($"EditSetting({index}) GET was requested");
var value = _settingRepository.Get(index);
var settingDTO = new SettingDTO
{
Index = index,
Value = value
};
return(PartialView("~/Views/Manage/Partials/_EditSetting.cshtml", settingDTO));
}
//public PipelineDTO Parse(Pipeline pipe)
//{
// PipelineDTO dto = new PipelineDTO();
// dto.CreatedBy = pipe.CreatedBy;
// dto.CreatedDate = pipe.CreatedDate;
// dto.DUNSNo = pipe.DUNSNo;
// dto.ID = pipe.ID;
// dto.IsActive = pipe.IsActive;
// dto.ModelTypeID = pipe.ModelTypeID;
// dto.ModifiedBy = pipe.ModifiedBy;
// dto.ModifiedDate = pipe.ModifiedDate;
// dto.Name = pipe.Name + " (" + pipe.DUNSNo + ")";
// dto.NameWithoutDuns = pipe.Name;
// dto.ToUseTSPDUNS = pipe.ToUseTSPDUNS;
// dto.TSPId = pipe.TSPId;
// dto.TempItem = pipe.ID + "-" + pipe.ModelTypeID;
// dto.IsUprdActive = pipe.IsUprdActive;
// return dto;
//}
public SettingDTO Parse(Setting a)
{
SettingDTO s = new SettingDTO();
s.ID = a.ID;
s.Value = a.Value;
s.IsActive = a.IsActive;
s.CreatedBy = a.CreatedBy;
s.CreatedDate = a.CreatedDate;
s.ModifiedBy = a.ModifiedBy;
s.ModifiedDate = a.ModifiedDate;
s.Name = a.Name;
return(s);
}
public ServerSettingViewModel()
{
CleanUp();
var iDbContext = new ServerDbContextFactory().Create();
_unitOfWork = new UnitOfWorkServer(iDbContext);
SelectedSetting = new SettingDTO();
Settings = new ObservableCollection <SettingDTO>();
GetLiveSettings();
EditCommandVisibility = false;
}
/// <summary>
/// // Takes a list of WeekDayColorDTOs and check if all hex given is in correct format
/// </summary>
private bool IsWeekDayColorsCorrectHexFormat(SettingDTO setting)
{
var regex = new Regex(@"#[0-9a-fA-F]{6}");
foreach (var weekDayColor in setting.WeekDayColors)
{
Match match = regex.Match(weekDayColor.HexColor);
if (!match.Success)
{
return(false);
}
}
return(true);
}
