public bool Login(string login)
{
using (QuestionaryContext context = new QuestionaryContext())
{
return(context.Users.Any(u => u.Login.ToUpper() == login.ToUpper()));
}
}
public List <Questionary> List()
{
using (QuestionaryContext context = new QuestionaryContext())
{
return(context.Questionaries.SqlQuery("ANKET_SEARCH").ToList());
}
}
public void Delete(int id)
{
using (QuestionaryContext context = new QuestionaryContext())
{
SqlParameter idparameter = new SqlParameter("@id", id);
context.Database.ExecuteSqlCommand("ANKET_DELETE @id", idparameter);
}
}
public void Update(Questionary questionary)
{
using (QuestionaryContext context = new QuestionaryContext())
{
SqlParameter firstName = new SqlParameter("@FirstName", questionary.FirstName);
SqlParameter secondName = new SqlParameter("@SecondName", questionary.SecondName);
SqlParameter birthday = new SqlParameter("@Birthday", questionary.Birthday);
SqlParameter id = new SqlParameter("@id", questionary.Id);
context.Database.ExecuteSqlCommand("ANKET_SAVE @FirstName, @SecondName, @Birthday, @id", firstName, secondName, birthday, id);
}
}
public int Add(Questionary questionary)
{
using (QuestionaryContext context = new QuestionaryContext())
{
SqlParameter firstName = new SqlParameter("@FirstName", questionary.FirstName);
SqlParameter secondName = new SqlParameter("@SecondName", questionary.SecondName);
SqlParameter birthday = new SqlParameter("@Birthday", questionary.Birthday);
SqlParameter idinserted = new SqlParameter {
ParameterName = "@insertedid", SqlDbType = SqlDbType.Int, Direction = ParameterDirection.Output
};
SqlParameter id = new SqlParameter("@id", questionary.Id);
var resp = context.Database.SqlQuery <int>("ANKET_SAVE @FirstName, @SecondName, @Birthday, @id, @insertedid", firstName, secondName, birthday, id, idinserted);
return(resp.First());
}
}
