public string NewFirm() { string name = Request["name"]; string username = Request["username"]; string password = Request["password"]; string field = Request["field"]; Entities entity = new Entities(); vaAccount account = entity.vaAccounts.Where(a => a.Username == username).FirstOrDefault(); if (account == null) { account = new vaAccount() { TypeFK = 2, Name = name, Surname = "", Username = username, Password = password, Field = field }; entity.vaAccounts.Add(account); entity.SaveChanges(); return(account.PK.ToString()); } else { return("username_exists"); } }
public string Allocations() { int userId = int.Parse(Request["userId"]); Entities entity = new Entities(); vaAccount user = entity.vaAccounts.Where(a => a.PK == userId).FirstOrDefault(); List <Offer> allocations = new List <Offer>(); vaOffer offer; foreach (vaRequest request in user.vaRequests.Where(r => r.Confirmed)) { offer = request.vaOffers.Where(o => o.Confirmed).FirstOrDefault(); allocations.Add ( new Offer() { pk = offer.PK, firm = offer.vaAccount.Name, phone = offer.vaAccount.Field, date = offer.vaRequest.Date, from = offer.vaRequest.From, to = offer.vaRequest.To, population = offer.vaRequest.Population, type = offer.vaRequest.Type, fee = offer.Fee } ); } return(new JavaScriptSerializer().Serialize(allocations)); }
public string FirmRequests() { int pk = int.Parse(Request["id"]); Entities entity = new Entities(); vaAccount account = entity.vaAccounts.Where(a => a.PK == pk).FirstOrDefault(); if (account != null) { List <Request> listRequests = new List <Request>(); foreach (vaRequest request in entity.vaRequests.Where(r => !r.Confirmed)) { if (account.vaOffers.Where(o => o.RequestFK == request.PK && o.AccountFK == pk).FirstOrDefault() != null) { continue; } listRequests.Add ( new Abstract.Request() { pk = request.PK, name = request.vaAccount.Name, surname = request.vaAccount.Surname, date = request.Date, from = request.From, to = request.To, population = request.Population, type = request.Type } ); } return(new JavaScriptSerializer().Serialize(listRequests)); } else { return("account_does_not_exists"); } }
public string UserOffers() { int pk = int.Parse(Request["id"]); Entities entity = new Entities(); vaAccount account = entity.vaAccounts.Where(a => a.PK == pk).FirstOrDefault(); if (account != null) { List <Offer> listOffers = new List <Offer>(); foreach (vaRequest request in account.vaRequests.Where(r => !r.Confirmed)) { foreach (vaOffer offer in request.vaOffers.Where(o => !o.Confirmed).ToList()) { listOffers.Add ( new Offer() { pk = offer.PK, firm = offer.vaAccount.Name, phone = offer.vaAccount.Field, date = offer.vaRequest.Date, from = offer.vaRequest.From, to = offer.vaRequest.To, population = offer.vaRequest.Population, type = offer.vaRequest.Type, fee = offer.Fee } ); } } return(new JavaScriptSerializer().Serialize(listOffers)); } else { return("account_does_not_exist"); } }
public string TryLogin() { string username = Request["username"]; string password = Request["password"]; Entities entity = new Entities(); vaAccount account = entity.vaAccounts.Where(a => a.Username == username).FirstOrDefault(); if (account != null) { if (account.Password == password) { Account json = new Account() { pk = account.PK, type = account.vaAccountType.Value.ToLower(), username = account.Username, password = account.Password, field = account.Field, name = account.Name, surname = account.Surname }; return(new JavaScriptSerializer().Serialize(json)); } else { return("wrong_password"); } } else { return("wrong_username"); } }