public static bool AddUser(RegisterViewModel model) { try { using (var context = new HackathonContext()) { context.Users.Add(new User { UserId = model.UserId, Name = model.Name, LastName = model.LastName, EmailAddress = model.EmailAddress, Password = model.Password, Username = model.Username }); context.SaveChanges(); return(true); } } catch (Exception) { // ignored } return(false); }
public static bool AddLoanRequest(LoanRequest request) { try { using (var context = new HackathonContext()) { context.LoanRequests.Add(request); var user = context.Users.FirstOrDefault(x => x.UserId == request.User.UserId); if (user != null) { user.CreditPoints += 100; context.Entry(user).State = EntityState.Modified; } context.SaveChanges(); return(true); } } catch (Exception) { //ignored } return(false); }
public bool Save(DataAccessInstagram data) { try { using (var db = new HackathonContext()) { if (data.Id == Guid.Empty) { data.Id = Guid.NewGuid(); data.DueDate = null; data.IsValid = true; data.RegistrationDate = DateTime.Now; } db.Set <DataAccessInstagram>().Add(data); db.SaveChanges(); return(true); } } catch { return(false); } }
public void InsertNewCheckpoint(string meetingId, string checkpointTitle, int checkpointTypeId, string userMail, string checkpointAnswerOptions = null) { using (HackathonContext db = new HackathonContext()) { if (!db.Meetings.Any(x => x.MeetingId == meetingId)) { db.Meetings.Add(new Meetings() { MeetingId = meetingId }); db.SaveChanges(); } if (db.Checkpoints.Any(x => x.MeetingId == meetingId)) { int numberOfCheckpoints = db.Checkpoints.Where(x => x.MeetingId == meetingId).Count(); db.Checkpoints.Add(new Checkpoints() { MeetingId = meetingId, CheckpointIsEnded = false, CheckpointAnswerOptions = checkpointTypeId == 1 ? checkpointAnswerOptions : "", CheckpointOrdinalNumber = numberOfCheckpoints + 1, CheckpointTitle = checkpointTitle, CheckpointTypeId = checkpointTypeId, CreatedDate = DateTime.Now.AddMinutes(1), UserMail = userMail }); } else { db.Checkpoints.Add(new Checkpoints() { MeetingId = meetingId, CheckpointIsEnded = false, CheckpointAnswerOptions = checkpointTypeId == 1 ? checkpointAnswerOptions : "", CheckpointOrdinalNumber = 0, CheckpointTitle = checkpointTitle, CheckpointTypeId = checkpointTypeId, CreatedDate = DateTime.Now.AddMinutes(1), UserMail = userMail }); } db.SaveChanges(); } }
public void InsertCheckpointAnswer(int checkpointId, string checkpointAnswer) { using (HackathonContext db = new HackathonContext()) { db.CheckpointAnswer.Add(new CheckpointAnswer() { CheckpointId = checkpointId, CheckpointAnswerBody = checkpointAnswer }); db.SaveChanges(); Checkpoints checkpoints = db.Checkpoints.Where(x => x.CheckpointId == checkpointId).FirstOrDefault(); checkpoints.CheckpointAnswerId = db.CheckpointAnswer.FirstOrDefault(x => x.CheckpointId == checkpointId).CheckpointAnswerId; db.Checkpoints.Update(checkpoints); db.SaveChanges(); } }
public void UpdateIsCheckpointEnded(int checkpointId) { using (HackathonContext db = new HackathonContext()) { Checkpoints checkpoints = db.Checkpoints.Where(x => x.CheckpointId == checkpointId).FirstOrDefault(); checkpoints.CheckpointIsEnded = true; db.Checkpoints.Update(checkpoints); db.SaveChanges(); } }
public bool Update(DataAccessInstagram data) { try { using (var db = new HackathonContext()) { var table = db.Set <DataAccessInstagram>(); table.Attach(data); db.Entry <DataAccessInstagram>(data).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); return(true); } } catch { return(false); } }
public static bool RemoveLoanRequest(Guid requestGuid) { try { using (var context = new HackathonContext()) { var request = context.LoanRequests.Find(requestGuid); if (request != null) { context.LoanRequests.Remove(request); context.SaveChanges(); return(true); } } } catch (Exception) { //ignored } return(false); }
public static bool RemoveLoan(Guid loanGuid) { try { using (var context = new HackathonContext()) { var loan = context.Loans.Find(loanGuid); if (loan != null) { context.Loans.Remove(loan); context.SaveChanges(); return(true); } } } catch (Exception) { //ignored } return(false); }
public static bool AddLoan(Loan request) { try { using (var context = new HackathonContext()) { request.DisbursementAmount = 100; request.ExpirationDate = new DateTime(2020, 12, 31); request.OutstandingBalance = 10; request.UserId = context.Users.FirstOrDefault(x => x.Username == request.Username)?.UserId; context.Loans.Add(request); context.SaveChanges(); return(true); } } catch (Exception e) { //ignored } return(false); }