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);
}
