public static void Save(string generalId, string NameEn, string NameAr, string NameFr, string subid) { if (string.IsNullOrEmpty(NameEn) || string.IsNullOrEmpty(NameAr) || string.IsNullOrEmpty(NameFr)) { Utils.GetSubCode(ref NameEn, ref NameAr, ref NameFr); } if (string.IsNullOrEmpty(subid)) { subid = MgrSub.GetMaxSubCode(generalId, 1); subid = subid.Substring(0, 3) + (Convert.ToInt32(subid.Substring(3)) + 1).ToString("00000"); } SubCodeVm[] vm = new SubCodeVm[3]; vm[0] = new SubCodeVm { GeneralID = generalId, SubID = subid }; vm[1] = new SubCodeVm { GeneralID = generalId, SubID = subid }; vm[2] = new SubCodeVm { GeneralID = generalId, SubID = subid }; vm[0].LanguageID = 1; vm[0].Name = NameEn; vm[1].LanguageID = 2; vm[1].Name = NameFr; vm[2].LanguageID = 3; vm[2].Name = NameAr; MgrSub.Save(vm[0]); }
public int Update(SubCodeVm subCode) { int affectedRows = 0; var _subCode = (from sc in _context.SubCodes where sc.SubID == subCode.SubID && sc.LanguageID == subCode.LanguageID select sc).FirstOrDefault(); if (_subCode == null) { var item = new SubCode() { GeneralID = subCode.SubID.Substring(0, 3), LanguageID = subCode.LanguageID, Name = subCode.Name, SubID = subCode.SubID, ParentSubCodeID = subCode.ParentSubCodeID }; affectedRows = _context.SubCodes.Where(s => s.Name == item.Name && s.LanguageID == item.LanguageID && s.GeneralID == item.GeneralID).Count(); if (affectedRows == 0) { _context.SubCodes.Add(item); _context.Entry(item).State = EntityState.Added; } } else { _subCode.Name = subCode.Name; affectedRows = _context.SubCodes.Where(s => s.Name == _subCode.Name && s.LanguageID == _subCode.LanguageID && s.GeneralID == _subCode.GeneralID && s.SubID != _subCode.SubID).Count(); if (affectedRows == 0) { _context.SubCodes.Attach(_subCode); _context.Entry(_subCode).State = EntityState.Modified; } } if (affectedRows == 0) { affectedRows = _context.SaveChanges(); } else { affectedRows = 0; } return(affectedRows); }
public int Save(SubCodeVm subCode) { SubCode item = new SubCode() { GeneralID = subCode.GeneralID, LanguageID = subCode.LanguageID, Name = subCode.Name, SubID = subCode.SubID, ParentSubCodeID = subCode.ParentSubCodeID }; int affectedRows = _context.SubCodes.Where(s => s.Name == item.Name && s.LanguageID == item.LanguageID && s.GeneralID == item.GeneralID).Count() > 0 ? -1 : 1; if (affectedRows == 1) { _context.SubCodes.Add(item); affectedRows = _context.SaveChanges(); } return(affectedRows); }
public int Update(SubCodeVm subCode) { subCode.Name = new ArabicPrepocessor().StripArabicWords(subCode.Name); return(_repo.Update(subCode)); }