public SmsTemplate(SmsTemplateInputViewModel sms) { SmsTemplateName = sms.SmsTemplateName; SmsTemplateCode = sms.SmsTemplateCode; MessageType = sms.MessageType; SmsContent = sms.SmsContent; IsActive = sms.IsActive; ApplyAllSystem = sms.ApplyAllSystem; IsDelete = sms.IsDelete; CreateUserId = sms.UserId; CreateDate = DateTime.Now; TypeNumber = sms.TypeNumber; OrganizationCode = sms.OrganizationCode; OrganizationName = sms.OrganizationName; HealthFacilitiesId = sms.HealthFacilitiesId; }
public IActionResult Update([FromBody] SmsTemplateInputViewModel sms) { try { _context.Session.BeginTransaction(); var nameCurrentTemplate = _context.Query <SmsTemplate>().Where(g => g.Id == sms.Id).Select(g => g.SmsTemplateName).FirstOrDefault(); if (sms.SmsTemplateName != nameCurrentTemplate) { string sql = $"SELECT * FROM {nameData}.sms_template where BINARY SmsTemplateName = '{sms.SmsTemplateName}' and {sms.IsDelete} = false"; //if (sms.HealthFacilitiesId != null) //{ // sql = sql + $" and (HealthFacilitiesId = {sms.HealthFacilitiesId} or HealthFacilitiesId = null)"; //} List <string> clause = new List <string>(); List <DbParam> param = new List <DbParam>(); var str = $"{sql} {string.Join(" ", clause)}"; var reader = _context.Session.ExecuteReader($"{sql} {string.Join(" ", clause)}", param); var HealthFacilitiesId = ""; var Id = 0; List <SmsTemplate> lst = new List <SmsTemplate>(); while (reader.Read()) { Id = Convert.ToInt32(reader["Id"]); HealthFacilitiesId = Convert.ToString(reader["HealthFacilitiesId"]); } reader.Close(); if (Id != 0 && (HealthFacilitiesId == "" || Convert.ToInt32(HealthFacilitiesId) == sms.HealthFacilitiesId)) { return(StatusCode(406, _excep.Throw(406, "Sửa mẫu tin nhắn không thành công.", "Tên mẫu tin nhắn đã tồn t" + "" + "" + "" + "" + "" + "" + "" + "" + "" + "" + "" + "ại !"))); } } if (_context.Query <SmsTemplate>().Where(g => g.SmsContent == sms.SmsContent && g.Id != sms.Id && sms.IsDelete == false).Count() > 0) { return(StatusCode(406, _excep.Throw(406, "Sửa mẫu tin nhắn không thành công.", "Nội dung tin nhắn đã tồn tại !"))); } //if (_context.Query<SmsLogs>().Where(g => g.SmsTemplateId == sms.Id && g.Status == 1).Count() > 0) // return StatusCode(500, _excep.Throw("Sửa mẫu tin nhắn không thành công.", "Mẫu tin nhắn đã được sử dụng !")); _context.Update <SmsTemplate>(g => g.Id == sms.Id, a => new SmsTemplate { SmsTemplateName = sms.SmsTemplateName, MessageType = sms.MessageType, SmsContent = sms.SmsContent, IsActive = sms.IsActive, ApplyAllSystem = sms.ApplyAllSystem, UpdateDate = DateTime.Now, UpdateUserId = sms.UserId }); _context.Session.CommitTransaction(); return(Json(new ActionResultDto())); } catch (Exception e) { if (_context.Session.IsInTransaction) { _context.Session.RollbackTransaction(); } return(Json(new ActionResultDto { Error = e.Message })); } }
public IActionResult Create([FromBody] SmsTemplateInputViewModel sms) { string sql = $"SELECT * FROM {nameData}.sms_template where BINARY SmsTemplateName = '{sms.SmsTemplateName}' and {sms.IsDelete} = false"; SmsTemplate genSmsCode; string smsTemplateCode = ""; if (sms.HealthFacilitiesId == null) { genSmsCode = _context.Query <SmsTemplate>().Where(s => s.IsDelete == false && s.HealthFacilitiesId == null).OrderByDesc(s => s.CreateDate).FirstOrDefault(); if (genSmsCode != null) { if (genSmsCode.SmsTemplateCode != null) { if (int.Parse(genSmsCode.SmsTemplateCode.Substring(8, 2)) < 9) { smsTemplateCode = genSmsCode.SmsTemplateCode.Substring(0, 8) + "0" + (int.Parse(genSmsCode.SmsTemplateCode.Substring(8, 2)) + 1).ToString(); } else { smsTemplateCode = genSmsCode.SmsTemplateCode.Substring(0, 8) + (int.Parse(genSmsCode.SmsTemplateCode.Substring(8, 2)) + 1).ToString(); } } else { smsTemplateCode = "SMSADMIN" + "00"; } } else { smsTemplateCode = "SMSADMIN" + "00"; } } else { var healthFacilities = _context.Query <HealthFacilities>().Where(h => h.IsDelete == false && h.HealthFacilitiesId == sms.HealthFacilitiesId).FirstOrDefault(); genSmsCode = _context.Query <SmsTemplate>().Where(s => s.IsDelete == false && s.HealthFacilitiesId == sms.HealthFacilitiesId).OrderByDesc(s => s.CreateDate).FirstOrDefault(); if (genSmsCode != null) { if (genSmsCode.SmsTemplateCode != null) { if (int.Parse(genSmsCode.SmsTemplateCode.Substring(8, 2)) < 9) { smsTemplateCode = genSmsCode.SmsTemplateCode.Substring(0, 8) + "0" + (int.Parse(genSmsCode.SmsTemplateCode.Substring(8, 2)) + 1).ToString(); } else { smsTemplateCode = genSmsCode.SmsTemplateCode.Substring(0, 8) + (int.Parse(genSmsCode.SmsTemplateCode.Substring(8, 2)) + 1).ToString(); } } else { smsTemplateCode = "SMS" + healthFacilities.Code + "00"; } } else { smsTemplateCode = "SMS" + healthFacilities.Code + "00"; } } sms.SmsTemplateCode = smsTemplateCode; //if (sms.HealthFacilitiesId != null) //{ // sql = sql + $" and (HealthFacilitiesId = {sms.HealthFacilitiesId} or HealthFacilitiesId = null)"; //} List <string> clause = new List <string>(); List <DbParam> param = new List <DbParam>(); var str = $"{sql} {string.Join(" ", clause)}"; var reader = _context.Session.ExecuteReader($"{sql} {string.Join(" ", clause)}", param); var HealthFacilitiesId = ""; var Id = 0; List <SmsTemplate> lst = new List <SmsTemplate>(); while (reader.Read()) { Id = Convert.ToInt32(reader["Id"]); HealthFacilitiesId = Convert.ToString(reader["HealthFacilitiesId"]); } reader.Close(); if (Id != 0 && (HealthFacilitiesId == "" || Convert.ToInt32(HealthFacilitiesId) == sms.HealthFacilitiesId)) { return(StatusCode(406, _excep.Throw(406, "Tạo mẫu tin nhắn không thành công.", "Tên mẫu tin nhắn đã tồn t" + "" + "" + "" + "" + "" + "" + "" + "" + "" + "" + "" + "ại !"))); } if (_context.Query <SmsTemplate>().Where(g => g.SmsContent == sms.SmsContent && ((g.CreateUserId == sms.CreateUserId) || (g.CreateUserId == 1)) && sms.IsDelete == false).Count() > 0) { return(StatusCode(406, _excep.Throw(406, "Tạo mẫu tin nhắn không thành công.", "Nội dung tin nhắn đã tồn tại !"))); } return(Json(new ActionResultDto { Result = _context.Insert(new SmsTemplate(sms)) })); }