private void AddClassificationBd(string classifications) { using (ContextClassificationParametr db = new ContextClassificationParametr()) { ClassificationParametr CP = new ClassificationParametr { CLassification = classifications }; db.ClassificationParametrs.Add(CP); db.SaveChanges(); } }
private int ChekedClassification(string classifications) { int count; using (ContextClassificationParametr db = new ContextClassificationParametr()) { var rr = db.ClassificationParametrs.Select(p => new { Id = p.Id, CLassification = p.CLassification }) .Where(p => p.CLassification == classifications); count = rr.Count(); } return(count); }
private string[,] query() { string[,] parametr; using (ContextClassificationParametr db = new ContextClassificationParametr()) { var rr = db.ClassificationParametrs.Select(p => new { Id = p.Id, CLassification = p.CLassification }); if (rr.Count() != 0) { parametr = new string[rr.Count(), 2]; int i = 0; foreach (var p in rr) { parametr[i, 0] = Convert.ToString(p.Id); parametr[i, 1] = p.CLassification; i++; } } else { parametr = new string[0, 0]; } } return(parametr); }