//readonly string connectionString = @"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\npartyko\Source\Repos\sammit\SummitService\SummitService\App_Data\SummitDB.mdf;Integrated Security=True";
//readonly string connectionString = @"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\Юрий\Desktop\8 семестр\Проектирование ИСУ\репоз\SummitService\SummitService\App_Data\SummitDB.mdf;Integrated Security=True";
public Auth Authorisation(string Login, string Password)
{
Auth auth = new Auth();
if (FindByLoginUsers(Login, Password))
{
using (SummitDBEntity summit = new SummitDBEntity())
{
User use = summit.Users
.Where(s => s.Login == Login)
.Where(p => p.Password == Password)
.FirstOrDefault();
if (use != null)
{
auth.error = false;
auth.error_message = null;
auth.id_user = use.ID_User;
return(auth);
}
else
{
auth.error = true;
auth.error_message = "Неверное имя пользователя или пароль";
return(auth);
}
}
}
else
{
auth.error = true;
auth.error_message = "Неверное имя пользователя или пароль";
return(auth);
}
}
public List <Summit> SelectSummit()
{
using (SummitDBEntity summit = new SummitDBEntity())
{
List <Summit> su = summit.Summits.ToList();
return(su);
}
}
/*public List<Voice> Summarizing()
* {
* //string sqlExpression = "Summarizing";
* //using (SqlConnection connection = new SqlConnection(connectionString))
* using (SummitDBEntity summit = new SummitDBEntity())
* {
*
* /*connection.Open();
* SqlCommand command = new SqlCommand(sqlExpression, connection)
* {
* CommandType = System.Data.CommandType.StoredProcedure
* };
*
*
* var reader = command.ExecuteReader();
*
* List<Voice> summarizing = new List<Voice>();
* if (reader.HasRows)
* {
* while (reader.Read())
* {
* Voice cli = new Voice
* {
*
* variant_id = reader.GetInt32(0),
* sum = reader.GetInt32(1),
* country_name = reader.GetString(2),
* start_date = reader.GetDateTime(3),
* finish_date = reader.GetDateTime(4)
*
* };
* summarizing.Add(cli);
* }
* return summarizing;
* }
* else
* {
* return null;
* }
*
* }
* }*/
public List <Country> SelectCountry()
{
using (SummitDBEntity summit = new SummitDBEntity())
{
List <Country> co = summit.Countries.ToList();
return(co);
}
}
public Country AddCountry(Country cou)
{
using (SummitDBEntity summit = new SummitDBEntity())
{
var count = summit.Countries
.Where(s => s.Name == cou.Name)
.Count();
if (count == 0)
{
summit.Countries.Add(cou);
summit.SaveChanges();
}
}
return(cou);
}
public Summit AddSummit(Summit sum)
{
using (SummitDBEntity summit = new SummitDBEntity())
{
var count = summit.Summits
.Where(s => s.Name == sum.Name)
.Count();
if (count == 0)
{
summit.Summits.Add(sum);
summit.SaveChanges();
}
}
return(sum);
}
public Voice AddVoice(Voice vo)
{
using (SummitDBEntity summit = new SummitDBEntity())
{
var count = summit.Voices
.Where(s => s.User_ID == vo.User_ID)
.Where(s => s.Variant_ID == vo.Variant_ID)
.Count();
if (count == 0)
{
summit.Voices.Add(vo);
summit.SaveChanges();
}
return(vo);
}
}
public Variant AddVariant(Variant va)
{
using (SummitDBEntity summit = new SummitDBEntity())
{
var count = summit.Variants
.Where(s => s.User_ID == va.User_ID)
.Where(s => s.Summit_ID == va.Summit_ID)
.Where(s => s.Country_ID == va.Country_ID)
.Count();
if (count == 0)
{
summit.Variants.Add(va);
summit.SaveChanges();
}
return(va);
}
}
public bool FindByLoginUsers(string Login, string Password)
{
using (SummitDBEntity summit = new SummitDBEntity())
{
User use = summit.Users
.Where(s => s.Login == Login)
.Where(p => p.Password == Password)
.FirstOrDefault();
if (use != null)
{
return(true);
}
else
{
return(false);
}
}
}
public void DeleteAllVoices()
{
using (SummitDBEntity summit = new SummitDBEntity())
{
using (var transaction = summit.Database.BeginTransaction())
{
try
{
foreach (var s in summit.Voices)
{
summit.Voices.Remove(s);
}
summit.SaveChanges();
transaction.Commit();
}
catch
{
transaction.Rollback();
}
}
}
}