public bool addArea(SCPM_AREAS newx, int unidad)
{
var contains = db.SCPM_AREAS.Include("SCPM_UNIDAD").ToList().Any(u => u.ARE_NOM.Equals(newx.ARE_NOM, StringComparison.InvariantCultureIgnoreCase) && u.SCPM_UNIDAD.UNI_COD == unidad);
if (contains || newx.ARE_NOM == "") return false;
var _a = from a in db.SCPM_UNIDAD where a.UNI_COD == unidad select a;
if (_a.Count() > 0)
{
_a.First().SCPM_AREAS.Add(newx);
db.SaveChanges();
return true;
}
else return false;
}
public bool editArea(SCPM_AREAS newx, int unidad)
{
var contains = db.SCPM_AREAS.Include("SCPM_UNIDAD").ToList().Any(u => u.ARE_NOM.Equals(newx.ARE_NOM, StringComparison.InvariantCultureIgnoreCase) && u.SCPM_UNIDAD.UNI_COD == unidad && u.ARE_COD != newx.ARE_COD);
if (contains || newx.ARE_NOM == "") return false;
var _a = from a in db.SCPM_AREAS where a.ARE_COD == newx.ARE_COD select a;
var area = _a.First();
area.ARE_NOM = newx.ARE_NOM;
area.ARE_EST = newx.ARE_EST;
db.SaveChanges();
return true;
}
