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