public IEnumerable <Meanings> SearchByMarker(string marker1, string marker2, string marker3) { List <Meanings> Meanings = new List <Meanings>(); string sqlExpression = "sp_SearchByMarker3"; using (SqlConnection connection = new SqlConnection(builder.ConnectionString)) { connection.Open(); SqlCommand command = new SqlCommand(sqlExpression, connection); command.CommandType = System.Data.CommandType.StoredProcedure; SqlParameter markerParam1 = new SqlParameter { ParameterName = "@marker1", Value = marker1 }; command.Parameters.Add(markerParam1); SqlParameter markerParam2 = new SqlParameter { ParameterName = "@marker2", Value = marker2 }; command.Parameters.Add(markerParam2); SqlParameter markerParam3 = new SqlParameter { ParameterName = "@marker3", Value = marker3 }; command.Parameters.Add(markerParam3); var reader = command.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { int id = reader.GetInt32(0); string word = reader.GetString(1); string meaning = reader.GetString(2); DateTime date = reader.GetDateTime(3); string category = reader.GetString(4); Meanings wordAdd = new Meanings { Word = word, Category = category, Meaning = meaning, EditDate = date, Id = id }; Meanings.Add(wordAdd); } } else { Console.WriteLine("Meanings marked as {0}, {1} and {2} was not found in glossary...", marker1, marker2, marker3); } reader.Close(); } IEnumerable <Meanings> Meaningsreturn = Meanings; return(Meaningsreturn); }
public Meanings InsertWord(string word, string meaning, string category) { //creates a specimen of class Meanings(saving word - category - meaning - creation date), its id setteled by datebase automaticaly Meanings wordAdd = new Meanings { Word = word, Category = category, Meaning = meaning, EditDate = DateTime.Now }; db.GetTable <Meanings>().InsertOnSubmit(wordAdd); db.SubmitChanges(); return(wordAdd); }
public IEnumerable <Meanings> SearchByMarker(string marker) {//invokes stored procedure, which search words by marker List <Meanings> Meanings = new List <Meanings>(); string sqlExpression = "sp_SearchByMarker1"; using (SqlConnection connection = new SqlConnection(builder.ConnectionString)) { connection.Open(); SqlCommand command = new SqlCommand(sqlExpression, connection); command.CommandType = System.Data.CommandType.StoredProcedure; SqlParameter markerParam = new SqlParameter { ParameterName = "@marker", Value = marker }; command.Parameters.Add(markerParam); var reader = command.ExecuteReader(); while (reader.Read()) { int id = reader.GetInt32(0); string word = reader.GetString(1); string meaning = reader.GetString(2); DateTime date = reader.GetDateTime(3); string category = reader.GetString(4); Meanings wordAdd = new Meanings { Word = word, Category = category, Meaning = meaning, EditDate = date, Id = id }; Meanings.Add(wordAdd); } reader.Close(); connection.Close(); } IEnumerable <Meanings> Meaningsreturn = Meanings; return(Meaningsreturn); }