partial void DeleteAspNetUsers_Hangout(AspNetUsers_Hangout instance);
partial void UpdateAspNetUsers_Hangout(AspNetUsers_Hangout instance);
public void WaitlistHangout(string userId, int hangoutId) { if (AspNetUsers_Hangout_db.AspNetUsers_Hangouts.Any()) { var UserHangout = (from a in AspNetUsers_Hangout_db.AspNetUsers_Hangouts where a.HangoutId == hangoutId && a.AspNetUsers == userId select a).SingleOrDefault(); if (UserHangout == null) { UserHangout = new AspNetUsers_Hangout { AspNetUsers = userId, HangoutId = hangoutId, IsRSVPd = false, IsWaitlist = true }; AspNetUsers_Hangout_db.AspNetUsers_Hangouts.InsertOnSubmit(UserHangout); } else { UserHangout.IsWaitlist = true; UserHangout.IsRSVPd = false; } } else { var UserHangout = new AspNetUsers_Hangout { AspNetUsers = userId, HangoutId = hangoutId, IsRSVPd = false, IsWaitlist = true }; AspNetUsers_Hangout_db.AspNetUsers_Hangouts.InsertOnSubmit(UserHangout); } try { AspNetUsers_Hangout_db.SubmitChanges(); } catch (Exception e) { Console.WriteLine(e); // Make some adjustments. // ... // Try again. AspNetUsers_Hangout_db.SubmitChanges(); } }
partial void InsertAspNetUsers_Hangout(AspNetUsers_Hangout instance);
public void JoinHangout(string userId, int hangoutId) { var Hangout = (from a in Hangout_db.Hangouts where a.Id == hangoutId select a).SingleOrDefault(); var UserAccount = (from a in AspNetUsers_db.AspNetUsers where a.Id == userId select a).SingleOrDefault(); if ((Hangout.AttendeeCount < Hangout.PartySize && Hangout.GenderRatio == false) || (Hangout.AttendeeCount < Hangout.PartySize && Hangout.GenderRatio == true && (UserAccount.Gender == 0 && Hangout.MaleAttendingCount < Hangout.PartySize / 2) || (UserAccount.Gender == 1 && Hangout.FemaleAttendingCount < Hangout.PartySize / 2))) { //if (AspNetUsers_Hangout_db.AspNetUsers_Hangouts.Any()) // { var UserHangout = (from a in AspNetUsers_Hangout_db.AspNetUsers_Hangouts where a.HangoutId == hangoutId && a.AspNetUsers == userId select a).SingleOrDefault(); if (UserHangout == null) { UserHangout = new AspNetUsers_Hangout { AspNetUsers = userId, HangoutId = hangoutId, IsRSVPd = true, IsWaitlist = false, Showed = true }; AspNetUsers_Hangout_db.AspNetUsers_Hangouts.InsertOnSubmit(UserHangout); } else { UserHangout.IsRSVPd = true; } //} try { if (UserAccount.Gender == 0) { Hangout.MaleAttendingCount++; } else { Hangout.FemaleAttendingCount++; } Hangout.AttendeeCount++; ActivityLog actLog = new ActivityLog { AspNetUserId = UserAccount.Id, HangoutId = Hangout.Id, TimeStamp = DateTime.UtcNow, ActivityType = (int)ActivityType.Join }; ActivityLog_db.ActivityLogs.InsertOnSubmit(actLog); Hangout_db.SubmitChanges(); AspNetUsers_Hangout_db.SubmitChanges(); ActivityLog_db.SubmitChanges(); } catch (Exception e) { Console.WriteLine(e); // Make some adjustments. // ... // Try again. Hangout_db.SubmitChanges(); AspNetUsers_Hangout_db.SubmitChanges(); ActivityLog_db.SubmitChanges(); } } else { // Hangout too full/Hangout has too many boys/girls. Cant join. } }