public JsonResult AddSMSTemplate(SMSTemplateViewModel smsTemplate) { try { int languageId = smsTemplate.LanguageId; #region Add SMS Template var men = new SMSTemplate() { CreatedBy = User.Identity.Name, CreatedOn = DateTime.Now, DefaultLanguage = smsTemplate.DefaultTemplateLanguage > 0 ? smsTemplate.DefaultTemplateLanguage : CultureHelper.GetDefaultLanguageId(), Status = smsTemplate.Status, }; _db.SMSTemplates.Add(men); _db.SaveChanges(); var menTrans = new SMSTemplateTranslation() { SMSTemplateId = men.Id, Description = smsTemplate.Description, LanguageId = languageId, IsDefault = languageId == CultureHelper.GetDefaultLanguageId(), Name = smsTemplate.Name }; _db.SMSTemplateTranslations.Add(menTrans); if (!menTrans.IsDefault) { var menTrans1 = new SMSTemplateTranslation() { SMSTemplateId = men.Id, Description = smsTemplate.Description, LanguageId = CultureHelper.GetDefaultLanguageId(), IsDefault = true, Name = smsTemplate.Name }; _db.SMSTemplateTranslations.Add(menTrans1); } _db.SaveChanges(); #endregion return(Json(smsTemplate, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { LogHelper.LogException(User.Identity.Name, ex, "Error While adding new SMS"); return(null); } }
public JsonResult EditSMSTemplate(SMSTemplateViewModel smsTemplate) { try { var smsTemp = _db.SMSTemplates.Find(smsTemplate.Id); if (smsTemp != null && smsTemp.Status != (int)GeneralEnums.StatusEnum.Deleted) { smsTemp.Status = smsTemplate.Status; smsTemp.DefaultLanguage = smsTemplate.DefaultTemplateLanguage > 0 ? smsTemplate.DefaultTemplateLanguage : CultureHelper.GetDefaultLanguageId(); _db.Entry(smsTemp).State = EntityState.Modified; _db.SaveChanges(); var tempTrans = _db.SMSTemplateTranslations.FirstOrDefault(r => r.SMSTemplateId == smsTemp.Id && r.LanguageId == smsTemplate.LanguageId); if (tempTrans != null) { tempTrans.Name = smsTemplate.Name; tempTrans.Description = smsTemplate.Description; _db.Entry(tempTrans).State = EntityState.Modified; } else { tempTrans = new SMSTemplateTranslation() { SMSTemplateId = smsTemp.Id, Description = smsTemplate.Description, LanguageId = smsTemplate.LanguageId, IsDefault = false, Name = smsTemplate.Name }; _db.SMSTemplateTranslations.Add(tempTrans); } _db.SaveChanges(); } return(Json(smsTemplate, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { LogHelper.LogException(User.Identity.Name, ex, "Error While editing SMS (Post)"); return(null); } }