public int createParty(int uid, PublishReq req) { Party newParty = new Party(); newParty.pubtime = DateTime.Now; newParty.party_name = req.title; newParty.party_desc = req.desc; newParty.party_type = req.type; newParty.party_connection = req.connection; newParty.party_aim = req.aim; if (req.noob) { newParty.party_noob = 1; } else { newParty.party_noob = 0; } if (req.longterm) { newParty.party_longterm = 1; } else { newParty.party_longterm = 0; } newParty.party_game = req.game; newParty.party_status = 0; newParty.party_num = req.num; newParty.current_num = 0; try { var maxID = (from x in db.Parties select x.party_id).Max() + 1; newParty.party_id = maxID; var newMem = new PartyMem(); newMem.party_id = maxID; newMem.user_id = uid; newMem.is_leader = 1; db.Parties.Add(newParty); db.PartyMems.Add(newMem); db.SaveChanges(); return(maxID); }catch (Exception e) { return(-1); } }
public bool AddUser(string username, string password) { var findExisting = (from u in db.Users where u.username == username select u); if (findExisting.Count() >= 1) { return(false); } User newUser = new User(); // newUser.uid = -1; newUser.username = username; newUser.password = password; db.Users.Add(newUser); db.SaveChanges(); return(true); }