public static User FindUser(string username)
{
using (var context = new HackathonContext())
{
return(context.Users.FirstOrDefault(x => x.Username == username));
}
}
public static Loan FindLoan(Guid loanGuid)
{
using (var context = new HackathonContext())
{
return(context.Loans.Find(loanGuid));
}
}
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 IActionResult Index()
{
ViewData["Name"] = HttpContext.Session.GetString("UName");
ViewData["Type"] = HttpContext.Session.GetString("Type");
UserContext userContext = HttpContext.RequestServices.GetService(typeof(UserContext)) as UserContext;
HackathonContext context = HttpContext.RequestServices.GetService(typeof(HackathonContext)) as HackathonContext;
Hackathon_UserContext HuContext = HttpContext.RequestServices.GetService(typeof(Hackathon_UserContext)) as Hackathon_UserContext;
dynamic user = null;
var UserHackathons = new List <Hackathon>();
if (ViewData["Name"] != null)
{
user = userContext.GetUserByUserName(ViewData["Name"].ToString());
var UserHackathonList = HuContext.GetUserHackathons(user);
foreach (int i in UserHackathonList)
{
UserHackathons.Add(context.GetByID(i));
}
}
dynamic Model = new ExpandoObject();
Model.UserHackathonList = UserHackathons;
Model.NextHackathons = context.GetNextHackathons();
Model.PreviousHackathons = context.GetPreviousHackathons();
Model.CurrentHackathons = context.GetCurrentHackathons();
return(View(Model));
}
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 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 async Task <List <MeetInformation> > GetUserMeetings(bool webApp)
{
string bearerToken = string.Empty;
var response = string.Empty;
List <Value> values = new List <Value>();
List <MeetInformation> meetings = new List <MeetInformation>();
using (var client = new HttpClient())
{
using (HackathonContext db = new HackathonContext())
{
bearerToken = webApp ? db.MrkApiToken.First().Token : db.MrkApiTokenStudent.First().Token;
client.DefaultRequestHeaders.Authorization = new System.Net.Http.Headers.AuthenticationHeaderValue("Bearer", bearerToken);
HttpResponseMessage result = await client.GetAsync("https://graph.microsoft.com/v1.0/me/events");
if (result.IsSuccessStatusCode)
{
response = await result.Content.ReadAsStringAsync();
var temperatures = JsonConvert.DeserializeObject <Temperatures>(response);
foreach (var tem in temperatures.Value.Where(x => x.IsCancelled == false))
{
bool isCheckpointsExist = db.Checkpoints.Any(x => x.MeetingId == tem.Id);
string startTime = DateTime.Parse(tem.Start.DateTime).ToString("MM/dd/yyyy HH:mm:ss");
string endTime = DateTime.Parse(tem.End.DateTime).ToString("MM/dd/yyyy HH:mm:ss");
if (tem.Subject != "test")
{
if (tem.Subject != null)
{
if (tem.Subject.ToLower() != "canceled")
{
if (!tem.Subject.ToLower().Contains("prezentacje projektów"))
{
meetings.Add(new MeetInformation()
{
MeetId = tem.Id,
MeetSubject = tem.Subject,
StartTime = startTime,
EndTime = endTime,
IsCheckpointsExist = isCheckpointsExist
});
}
}
}
}
}
}
else
{
response = "Fail \n" + result.StatusCode;
}
}
}
return(meetings);
}
public BasicAuthenticationHandler(
IOptionsMonitor <AuthenticationSchemeOptions> options,
ILoggerFactory logger, UrlEncoder encoder,
ISystemClock clock,
HackathonContext context) : base(options, logger, encoder, clock)
{
_unit = new UnitOfWork(context);
}
public DataAccessInstagram GetByCode(string code)
{
using (var db = new HackathonContext())
{
return(db.Set <DataAccessInstagram>()
.Where(x => x.AccessToken == code).FirstOrDefault());
}
}
public static List <LoanRequest> GetLoanRequests(short loanRequestStatus)
{
using (var context = new HackathonContext())
{
return(context.LoanRequests
.Where(x => x.Status == loanRequestStatus).ToList());
}
}
public static List <Loan> GetLoans(string username, short loanStatus)
{
using (var context = new HackathonContext())
{
return(context.Loans
.Where(x => x.Username == username &&
x.Status == loanStatus).ToList());
}
}
public DataAccessInstagram GetIsValid()
{
using (var db = new HackathonContext())
{
return(db.Set <DataAccessInstagram>()
.Where(x => !x.DueDate.HasValue && x.IsValid).OrderByDescending(x => x.RegistrationDate)
.FirstOrDefault());
}
}
public IActionResult Search(string S)
{
ViewData["Name"] = HttpContext.Session.GetString("UName");
ViewData["Type"] = HttpContext.Session.GetString("Type");
HackathonContext hContext = HttpContext.RequestServices.GetService(typeof(HackathonContext)) as HackathonContext;
return(View(hContext.Search(S)));
}
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 ActionResult ShowLoanRequest(Guid loanRequestGuid)
{
using (var context = new HackathonContext())
{
var request = context.LoanRequests.Find(loanRequestGuid);
if (request != null)
{
return(View(request));
}
}
return(RedirectToAction("Index"));
}
//public IActionResult AddProblemStatements()
public IActionResult Index(int hid)
{
ViewData["Name"] = HttpContext.Session.GetString("UName");
ViewData["Type"] = HttpContext.Session.GetString("Type");
TempData["id"] = hid;
HackathonContext hackathonContext = HttpContext.RequestServices.GetService(typeof(HackathonContext)) as HackathonContext;
Hackathon Selection = hackathonContext.GetByID(hid);
ProblemStatementContext problemStatementContext = HttpContext.RequestServices.GetService(typeof(ProblemStatementContext)) as ProblemStatementContext;
var SelectionPS = problemStatementContext.GetProblemStatementsById(hid);
dynamic JointModel = new ExpandoObject();
JointModel.ProblemStatements = SelectionPS;
JointModel.Hackathon = Selection;
return(View(JointModel));
}
public MeetingCheckpoint GetCheckpointsByMeetings(string meetingId, string userMail)
{
var response = string.Empty;
MeetingCheckpoint meetingCheckpoint = new MeetingCheckpoint();
using (HackathonContext db = new HackathonContext())
{
List <Checkpoints> checkpoints = db.Checkpoints.Where(x => x.MeetingId == meetingId &&
x.CreatedDate > DateTime.Now &&
x.UserMail.ToLower() == userMail.ToLower() &&
x.CheckpointIsEnded == false).ToList();
meetingCheckpoint.Checkpoints = checkpoints;
meetingCheckpoint.MeetingId = meetingId;
return(meetingCheckpoint);
}
}
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 static bool MakeNextPayment(Guid paymentGuid)
{
try
{
using (var context = new HackathonContext())
{
var payment = context.Payments.ToList();
return(true);
}
}
catch (Exception)
{
// ignored
}
return(false);
}
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 async Task <MeetingUsers> CheckIsMeetingActiveAndGetUsers(string meetId, bool webApp)
{
var response = string.Empty;
MeetingUsers meetingUsers = new MeetingUsers();
using (var client = new HttpClient())
{
using (HackathonContext db = new HackathonContext())
{
string bearerToken = webApp ? db.MrkApiToken.First().Token : db.MrkApiTokenStudent.First().Token;
client.DefaultRequestHeaders.Authorization = new System.Net.Http.Headers.AuthenticationHeaderValue("Bearer", bearerToken);
}
HttpResponseMessage result = await client.GetAsync("https://graph.microsoft.com/v1.0//me/events/" + meetId);
if (result.IsSuccessStatusCode)
{
response = await result.Content.ReadAsStringAsync();
var attendeeValue = JsonConvert.DeserializeObject <Value>(response);
List <Attendee> listOfAttende = new List <Attendee>();
foreach (var att in attendeeValue.Attendees)
{
HttpResponseMessage resultByMail = await client.GetAsync("https://graph.microsoft.com/v1.0/users/" + att.EmailAddress.Address);
dynamic userObject = JObject.Parse(await resultByMail.Content.ReadAsStringAsync());
string userId = userObject.id;
HttpResponseMessage photo = await client.GetAsync("https://graph.microsoft.com/v1.0/users/" + userId + "/photo/$value");
att.Photo = await photo.Content.ReadAsStringAsync();
listOfAttende.Add(att);
}
meetingUsers.attendees = listOfAttende;
meetingUsers.organizer = attendeeValue.Organizer;
}
else
{
response = "Fail \n" + result.StatusCode;
}
}
return(meetingUsers);
}
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 async Task <string> Test(bool webApp)
{
string bearerToken = string.Empty;
var response = string.Empty;
using (var client = new HttpClient())
{
using (HackathonContext db = new HackathonContext())
{
bearerToken = webApp ? db.MrkApiToken.First().Token : db.MrkApiTokenStudent.First().Token;
client.DefaultRequestHeaders.Authorization = new System.Net.Http.Headers.AuthenticationHeaderValue("Bearer", bearerToken);
HttpResponseMessage result = await client.GetAsync("https://graph.microsoft.com/v1.0/reports/getTeamsUserActivityUserDetail(period='D30')");
response = await result.Content.ReadAsStringAsync();
return(response);
}
}
}
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 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 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);
}
public ActionResult MakePayment(Guid loanGuid)
{
try
{
using (var context = new HackathonContext())
{
Loan loan = LoanService.FindLoan(loanGuid);
if (loan != null)
{
var payment =
context.Payments.FirstOrDefault(x => x.Status == (short)Enumerators.PaymentStatus.NotPayed);
HOP_PaymentClient hopClient = new HOP_PaymentClient();
string redirectUrl = "http://localhost:50162" + Url.Action("Index", new { username = "******" });
//var url = hopClient.PaymentRequest(loan.User.EmailAddress, payment.InvoicedAmount, "",
// payment.InvoiceNumber,
// redirectUrl);
//payment.InvoicedAmount = 13.25;
//var a = hopClient.GetAuthorizationToken("1691709", payment.InvoicedAmount);
var a = "785b518590c14b5831de8674299bf1b39f49dca2";
var url = "https://testhop.hakrinbank.com/gateway/service/PaymentController.php?TokenID=" + a + "&Amount=" + payment.InvoicedAmount + "&Desc=" + "Description" + "&Inv=" + payment.InvoiceNumber +
"&returnURL=" + redirectUrl;
Response.Redirect(url);
//context.Loans.Remove(loan);
//context.SaveChanges();
//return RedirectToAction("ShowLoan");
}
}
}
catch (Exception e)
{
// ignored
}
return(RedirectToAction("ShowLoanRequest"));
}
public ApartmentsController(HackathonContext context) : base(context)
{
}
public UsersController(HackathonContext context) : base(context)
{
}
public TransportsController(HackathonContext context) : base(context)
{
}
