public string GetData(int value) { using (var db = new FileItDataLayer.Models.SystemFileitEntities()) { } return(string.Format("You entered: {0}", value)); }
public bool SetAccess(string accesstype, string username, bool allowaccess) { bool result = false; using (var db = new FileItDataLayer.Models.SystemFileitEntities()) { if (allowaccess) { if (!db.CABINETS_ACCESS.Any(ca => ca.CABINETNAME == CABINETNAME && ca.ACCESSTYPE.Equals(accesstype, StringComparison.CurrentCultureIgnoreCase) && ca.ACCESSNAME.Equals(username, StringComparison.CurrentCultureIgnoreCase) )) { var newaccess = new CABINETS_ACCESS() { CABINETNAME = CABINETNAME, ACCESSTYPE = accesstype, ACCESSNAME = username }; db.CABINETS_ACCESS.Add(newaccess); } } else { var cabinetaccess = db.CABINETS_ACCESS.FirstOrDefault(ca => ca.CABINETNAME == CABINETNAME); db.CABINETS_ACCESS.Remove(cabinetaccess); } db.SaveChanges(); result = true; } return(result); }