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));
}
