public string Login(string userData)
{
using (voting_systemEntities db = new voting_systemEntities())
{
string token = "";
User user = JsonConvert.DeserializeObject <User>(userData);
User findUser = null;
var findUserList = db.Users.Where(
(a) => a.Name == user.Name && a.Password == user.Password).ToList();
if (findUserList.Count != 0)
{
findUser = findUserList.First();
if (findUser != null)
{
using (MD5 md5 = MD5.Create())
{
token = GetMd5Hash(md5, findUser.Name + findUser.Password + CreateRandomString(4));
}
findUser.Token = token;
db.SaveChanges();
return(token);
}
}
return(null);
}
}
/// <summary>
///
/// </summary>
/// <param name="data">Содержит в себе данные типа { Candidate: int, Voting: int, User: int }</param>
/// <returns></returns>
public void SetVoiceForCandidate(string data)
{
using (voting_systemEntities db = new voting_systemEntities())
{
SetVoiceResponce jsonData = JsonConvert.DeserializeObject <SetVoiceResponce>(data);
int candidate = jsonData.Candidate;
int voting = jsonData.Voting;
int user = jsonData.User;
Candidate_Voting row = (Candidate_Voting)db.Candidate_Voting.Where((a) => a.Voting_ID == voting && a.Candidate_ID == candidate);
//Скорее всего надо не найти, а создать
Bulletin bulettin = (Bulletin)db.Bulletins.Where((a) => a.Candidate_Voting == row && a.Users_ID == user);
bulettin.Vote = 1;
db.SaveChanges();
}
}
public string CreateVoting(string data)
{
using (voting_systemEntities db = new voting_systemEntities())
{
Voting voting = JsonConvert.DeserializeObject <Voting>(data);
var Votings = db.Votings;
Votings.Add(voting);
try
{
db.SaveChanges();
return(null);
}
catch (DbEntityValidationException e)
{
return(e.Message);
}
}
}
public string AddUser(string userData)
{
using (voting_systemEntities db = new voting_systemEntities())
{
var users = db.Users;
User user = JsonConvert.DeserializeObject <User>(userData);
try {
users.Add(user);
db.SaveChanges();
return(null);
}
catch (DbEntityValidationException e)
{
var q = db.GetValidationErrors();
return(e.Message);
}
}
}
