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