public string GetVoicesCountInVoting(string data, string token)
{
//TODO: Возможно, будет метод который делает голосование открытым или закрытым
using (voting_systemEntities db = new voting_systemEntities())
{
if (UserValidate(token))
{
var Candidate_Voting = db.Candidate_Voting;
CountVotingResponce parseData = JsonConvert.DeserializeObject <CountVotingResponce>(data);
int idVoting = parseData.Voting;
Bulletin Bulletin;
int count = 0;
var Candidate_VotingList = Candidate_Voting.Where((a) => a.Voting_ID == idVoting);
if (Candidate_VotingList.Count() != 0)
{
foreach (Candidate_Voting candidate_voting in Candidate_VotingList)
{
Bulletin = (Bulletin)db.Bulletins.Where((a) => a.Candidate_Voting == candidate_voting);
if (Bulletin.Vote != 0)
{
count++;
}
}
return(JsonConvert.SerializeObject(new { Voices = count }));
}
}
return(JsonConvert.SerializeObject(new { error = "Ошибка!" }));
}
}
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);
}
}
// { Name: "Иван", PassportSeries: 222, PassportNumber: 23124, WhoGives: "me", WhenGives: "01.01.2015", isAdmin: true, Password: 123456, Token: "" }
//public CompositeType GetDataUsingDataContract(CompositeType composite)
//{
// if (composite == null)
// {
// throw new ArgumentNullException("composite");
// }
// if (composite.BoolValue)
// {
// composite.StringValue += "Suffix";
// }
// return composite;
//}
private bool UserValidate(string token)
{
using (voting_systemEntities db = new voting_systemEntities())
{
var users = db.Users;
List <User> listUsers = users.Where((a) => a.Token == token).ToList();
return(listUsers.Count != 0);
}
}
public string GetCandidateInfo(string id)
{
using (voting_systemEntities db = new voting_systemEntities())
{
Candidate candidate = db.Candidates.Find(id);
string jsonCandidate = JsonConvert.SerializeObject(candidate);
return(jsonCandidate);
}
}
public string GetCandidatesList()
{
using (voting_systemEntities db = new voting_systemEntities())
{
var Candidates = db.Candidates;
string jsonCandidates = JsonConvert.SerializeObject(Candidates);
return(jsonCandidates);
}
}
/// <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);
}
}
}
