public IActionResult NewRegistration() { Contacts contact = Regs.Contact; contact.DateOfBirth = DateTime.Now.AddYears(0 - Convert.ToInt32(contact.Age)); contact.Save(HttpContext); CommunityUnit unit = new CommunityUnit(); string[] tokens = Regs.Unit.Split(' '); if (!string.IsNullOrEmpty(Regs.Unit) && tokens.Length > 1) { int.TryParse(tokens[0], out int idnt); unit.Id = idnt; } Referee referee = new Referee(); tokens = Regs.Referee.Split(' '); if (!string.IsNullOrEmpty(Regs.Referee) && tokens.Length > 1) { int.TryParse(tokens[0], out int idnt); referee.Id = idnt; } Facility facility = new Facility(); tokens = Regs.Facility.Split(' '); if (!string.IsNullOrEmpty(Regs.Facility) && tokens.Length > 1) { int.TryParse(tokens[0], out int idnt); facility.Id = idnt; } Record record = Regs.Record; record.Contact = contact; record.Referee = referee; record.Unit = unit; record.Save(HttpContext); Screening screen = Regs.Screen; screen.Record = record; screen.Save(HttpContext); Appointment appointment = Regs.Appointment; appointment.Contact = contact; appointment.Facility = facility; appointment.Source = new AppointmentSource { Id = 1 }; appointment.Service = new AppointmentService { Id = 1 }; appointment.Save(HttpContext); return(LocalRedirect("/contacts/")); }
public async Task <IActionResult> Edit(int id, [Bind("Id,Date")] Screening screening) { if (id != screening.Id) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(screening); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!ScreeningExists(screening.Id)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } return(View(screening)); }
public Screening GetScreening(int id) { try { Screening screeningModel; using (var context = new BiografContext()) { var screening = context.Screenings.Find(id); screeningModel = new Screening() { Id = screening.Id, MovieId = screening.MovieId, AuditoriumId = screening.AuditoriumId, Movie = GetMovie(context.Movies.Find(screening.MovieId).Id), Auditorium = GetAuditorium(context.Auditoria.Find(screening.AuditoriumId).Id), ScreeningStart = screening.ScreeningStart }; } return(screeningModel); } catch (Exception ex) { return(null); } }
public async Task <IActionResult> Edit(int id, [Bind("ScreeningId,UserId,IsJobDescOptSelected,IsCustomQuestionOptSelected,JobDesc,CandidateName,CandidateEmail,CandidatePhone,ScreeningStatus,CandidateSignInCode,CreatedOn,CreatedBy,LastUpdated,LastUpdatedBy")] Screening screening) { if (id != screening.ScreeningId) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(screening); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!ScreeningExists(screening.ScreeningId)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } ViewData["UserId"] = new SelectList(_context.User, "UserId", "UserId", screening.UserId); return(View(screening)); }
public async Task <ApiResultLite> UpdateAsync(ScreeningUpdateRequest request) { Screening screening = await _context.Screenings.FindAsync(request.Id); if (screening == null) { return(new ApiErrorResultLite("Không tìm thấy")); } else { screening.Id = request.Id; screening.TimeStart = request.TimeStart; //screening.Surcharge = request.Surcharge; screening.FilmId = request.FilmId; screening.RoomId = request.RoomId; screening.KindOfScreeningId = request.KindOfScreeningId; _context.Update(screening); int rs = await _context.SaveChangesAsync(); if (rs == 0) { return(new ApiErrorResultLite("Cập nhật thất bại")); } return(new ApiSuccessResultLite("Cập nhật thành công")); } }
public void Execute(ScreeningDto request) { var splitDate = request.Date.Split('-'); var searchDate = new DateTime(int.Parse(splitDate[0]), int.Parse(splitDate[1]), int.Parse(splitDate[2]), int.Parse(request.Time), 0, 0); var modifiedRequest = new ScreeningDto { MovieId = request.MovieId, AuditoriumId = request.AuditoriumId, ScreeningTime = searchDate }; _validator.ValidateAndThrow(modifiedRequest); var screening = new Screening { MovieId = request.MovieId, AuditoriumId = request.AuditoriumId, ScreeningTime = searchDate }; _context.Screenings.Add(screening); _context.SaveChanges(); }
public Screening CreateScreening(Screening screening) { try { if (IsTimeFree(screening)) { screening.Seats = CreateSeats(); _context.Add(screening); _context.SaveChanges(); } } catch (DbUpdateConcurrencyException) { return(null); } catch (DbUpdateException) { return(null); } catch (Exception) { return(null); } return(screening); }
static void Main(string[] args) { // SequenceCondition + AmountDiscountPolicy SequenceCondition sc1 = new SequenceCondition(1); SequenceCondition sc2 = new SequenceCondition(2); AmountDiscountPolicy adp = new AmountDiscountPolicy(Money.Wons(10000), sc1, sc2); Movie GodzillaVSKong = new Movie("고질라VS.콩", TimeSpan.FromMinutes(113), Money.Wons(18000), adp); Screening screening = new Screening(GodzillaVSKong, 1, new DateTime(2021, 4, 3)); Reservation reservation = screening.Reserve(new Customer(), 1); Console.WriteLine(reservation); // --- // PeriodCondition + PercentDiscountPolicy PeriodCondition pc1 = new PeriodCondition(DayOfWeek.Saturday, TimeSpan.FromHours(9), TimeSpan.FromHours(13)); PeriodCondition pc2 = new PeriodCondition(DayOfWeek.Sunday, TimeSpan.FromHours(9), TimeSpan.FromHours(13)); PeriodCondition pc3 = new PeriodCondition(DayOfWeek.Monday, TimeSpan.FromHours(18), TimeSpan.FromHours(24)); PercentDiscountPolicy pdp = new PercentDiscountPolicy(0.1, pc1, pc2, pc3); Movie theBookOfFish = new Movie("자산어보", TimeSpan.FromMinutes(126), Money.Wons(12000), pdp); Screening screening2 = new Screening(theBookOfFish, 3, new DateTime(2021, 4, 4, 11, 50, 00)); Reservation reservation2 = screening2.Reserve(new Customer() { Name = "jongfeel" }, 1); Console.WriteLine(reservation2); }
public void Handle(ReserveSeats command) { var state = new ScreeningState(_eventStore.EventsFor(command.ScreeningId)); var screening = new Screening(state, PublishWith(state)); screening.Reserve(command.CustomerId, command.Seats); }
private async Task FinalizeJobApplicationOnLastScreeningStep(string givenId, Screening newScreening) { if (newScreening.GetType() == typeof(FinalDecision_Screening)) { await _jobApplicationService.UpdateStatusOfJobApplication(givenId, 4); } }
public async Task <List <SeatingModel> > GetSeatingAsync(int id) { Screening screening = await _screeningRepo.GetAsync(id); IEnumerable <Reservation> screeningReservations = await _reservationRepo.GetByScreeningIdAsync(id); //gets reserved seats first List <SeatingModel> screeningSeats = screeningReservations.SelectMany(x => x.SeatReservations) .Select(x => new SeatingModel { IsReserved = true, Seat = _mapper.Map <SeatDto>(x.Seat) }).ToList(); //gets all seats IEnumerable <Seat> hallSeats = await _seatRepo.GetAsync(x => x.HallId == screening.HallId); IEnumerable <Seat> freeSeats = hallSeats.Where(x => !screeningSeats.Select(y => y.Seat.Id).Contains(x.Id)).ToList(); foreach (Seat seat in freeSeats) { SeatingModel seatingModel = new SeatingModel { IsReserved = false, Seat = _mapper.Map <SeatDto>(seat) }; screeningSeats.Add(seatingModel); } return(screeningSeats.OrderBy(x => x.Seat.SeatNumber).ToList()); }
public async Task <IActionResult> Edit(Screening screening) { db.Screenings.Update(screening); await db.SaveChangesAsync(); return(RedirectToAction("ScreeningMain")); }
public async Task <List <Screening> > NewScreening(string givenId, string givenComment) { var listOfScreenings = await GetAllScreeningsById(givenId); if (listOfScreenings.Count == 6) { return(listOfScreenings); } else if (listOfScreenings.Count != 0) { Screening lastScreening = listOfScreenings.FirstOrDefault(screening => screening.Status == true); if (lastScreening == null) { return(null); } var newScreening = lastScreening.CreateNextScreening(Guid.Parse(givenId), givenComment); await FinalizeJobApplicationOnLastScreeningStep(givenId, newScreening); await SaveScreeningToRepo(listOfScreenings, newScreening); } else { var newScreening = new CV_Screening(givenComment, Guid.Parse(givenId)); await SaveScreeningToRepo(listOfScreenings, newScreening); } return(listOfScreenings); }
public async Task <IActionResult> Edit(int?id) { if (id != null) { Screening screening = await db.Screenings.FirstOrDefaultAsync(p => p.ScreeningId == id); if (screening != null) { var vm = new ScreeningModel(); vm.Movies = db.Movies .Select(a => new SelectListItem() { Value = a.MovieId.ToString(), Text = a.Title }) .ToList(); vm.Audithoriums = db.Audithoria .Select(a => new SelectListItem() { Value = a.AudithoriumId.ToString(), Text = a.Name }) .ToList(); ViewBag.vm = vm.Movies; ViewBag.vm1 = vm.Audithoriums; return(View(screening)); } } return(NotFound()); }
public void Execute(OptionAttempt attempt) { Console.WriteLine("\nOption 5. Order Movie Tickets"); this.attempt = attempt; List <Ticket> ticketList = new List <Ticket>(); Order order = new Order(); order.Status = "Unpaid"; int movieIndex = Select.Movie(attempt) - 1; Screening session = SelectSession(movieIndex); int numOfTickets = GetNoOfTicket(session); CheckMovieClassification(movieIndex); // Ordering of tickets for (int i = 1; i <= numOfTickets; i++) { Console.WriteLine("\nTicket #" + i); // Hand resposibility over to TicketFactory Ticket ticket = TicketFactory.CreateTicket(GetTicketType(), session, attempt); order.AddTicket(ticket); } session.SeatsRemaining -= numOfTickets; PrintOrderSummary(order, session); }
public static Ticket CreateTicket(String type, Screening screening, OptionAttempt attempt) { type = type.ToUpper(); Ticket ticket; switch (type) { case "ADULT": ticket = new Adult(screening, attempt); break; case "SENIOR": case "SENIORCITIZEN": ticket = new SeniorCitizen(screening, attempt); break; case "STUDENT": ticket = new Student(screening, attempt); break; default: throw new SystemException(); // Throw SystemException as it can't be handled } return(ticket); }
public ActionResult CheckOut(Ticket od, Order ord, int[] AvailableSeats, Screening screening) { List <string> ListofSeats = new List <string>(); List <SelectListItem> AvailableSeatList = FindAvailableSeats(ord.Tickets).ToList(); var availableseats = FindAvailableSeats(ord.Tickets); var SeatCount = 0; SeatCount = AvailableSeatList.Count() - 1; List <Ticket> TicketList = new List <Ticket>(); foreach (var i in AvailableSeats) { Ticket t = new Ticket(); t.Screening = screening; t.Order = ord; SeatCount = SeatCount - 1; t.TicketPrice = od.TicketPrice; TicketList.Add(t); if (ModelState.IsValid) { db.Tickets.Add(t); db.SaveChanges(); } } //ViewBag.AllSeatNames = GetSeatName(); return(View(ord)); }
public DataSet RetrieveSeatsAvilable(int ScreeningID)//checked { DataTable dtUnAvilable = CinemaClass.RetrieveSeatsUnAvilable(ScreeningID); int iCinemaID = Screening.RetrieveCinemaID(ScreeningID); DataTable dt2 = new DataTable(); DataColumn dc = new DataColumn(); dc.ColumnName = "freeSeats"; dt2.Columns.Add(dc); int seats = CinemaClass.NumberOfSeatsInCinema(iCinemaID); for (int i = 0; i < seats; i++) { //Console.WriteLine(i); int z = i + 1; int j = 0; bool flag = true; while ((j < dtUnAvilable.Rows.Count) && (flag == true)) { string snum = dtUnAvilable.Rows[j][0].ToString(); int num = int.Parse(snum); if (z == num) { flag = false; } j = j + 1; } if (flag == true) { DataRow dr = dt2.NewRow(); dr["freeSeats"] = z; dt2.Rows.Add(dr); } } for (int i = 0; i < dt2.Rows.Count; i++) { for (int j = 0; j < dt2.Columns.Count; j++) { Console.Write(dt2.Rows[i][j] + " "); } Console.WriteLine(); } //Console.WriteLine(dt2.Rows[2][0]); //Console.WriteLine(dt2.Rows[0][0]); //Console.ReadKey(); //Console.WriteLine(dt2.Rows.Count); DataSet ds = new DataSet(); ds.Tables.Add(dt2); return(ds); //ds.Tables.Add }
private static async Task <ICollection <Screening> > DummyScreenings(webnetlabb3Context _context, int amountPerSalon = 10) { var x = new List <Screening>(); var TimeStarted = DateTime.Now; var prices = new decimal[] { 100, 120, 150 }; foreach (var salon in await _context.Salon.ToListAsync()) { var date = TimeStarted; for (int i = 0; i < amountPerSalon; i++) { var movie = await RandomMovie(_context.Movie); var s = new Screening { Date = date, SalonID = salon.SalonID, MovieID = movie.MovieID, Price = prices[new Random().Next(0, prices.Length)], Tickets = new List <Ticket>() }; date = s.Date.AddMinutes(movie.Length); x.Add(s); } } return(x); }
public string CancelInvite(int InvitationID) { //int iInvitationID = Invitation.RetrieveInvitationID(UserID, ScreeningID, SeatNumber); //string iInvitationTime = Invitation.InvitationDateTime(InvitationID); int screeningid = Invitation.InvitationsScreeningID(InvitationID); string screeningDate = Screening.ScreeningDate(screeningid); string msg; DateTime invitationdate = DateTime.Parse(Invitation.InvitationDateTime(InvitationID)); DateTime timetoday = DateTime.Today; DateTime sdate = DateTime.Parse(screeningDate); //int dateComp = dt1.CompareTo(dt2); TimeSpan dateDiff = sdate - timetoday; if (dateDiff.Days > 2) { Invitation.DeleteInvitation(InvitationID); msg = "Invitation Has Been Canceled"; } else if (sdate < invitationdate) { Invitation.DeleteInvitation(InvitationID); msg = "Invitation Has Been Canceled"; } else { msg = "System Can not Delete Your Invitation"; } Console.WriteLine(msg); return(msg); }
public Reservation(Customer customer, Screening screening, Money fee, int audienceCount) { Customer = customer; Screening = screening; Fee = fee; AudienceCount = audienceCount; }
public async Task <ActionResult <Screening> > AddScreening([FromForm] Screening screening) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } var movie = context.Movies.FirstOrDefault(m => m.MovieId == screening.MovieId); if (movie == null) { return(NotFound()); } screening.Movie = movie; var screeningRoom = context.ScreeningRooms.FirstOrDefault(sr => sr.ScreeningRoomId == screening.ScreeningRoomId); if (screeningRoom == null) { return(NotFound()); } screening.ScreeningRoom = screeningRoom; context.Add(screening); await context.SaveChangesAsync(); return(new OkObjectResult(screening)); }
public ActionResult AddToOrder(Ticket od, int SelectedScreening) { //Find the screening associated with the int SelectedScreening Screening screening = db.Screenings.Find(SelectedScreening); //set the screening property of the order detail to this newly found screening od.Screening = screening; //Find the order associated with the order detail Order ord = db.Orders.Find(od.Order.OrderID); //set the property of the order detail to this newly found order od.Order = ord; //set the value of the product price od.TicketPrice = screening.Price; ////set the value of the extended price od.ExtendedPrice = od.TicketPrice * od.SeatsReserved; if (ModelState.IsValid)//model meets all requirements { //add the order detail to the database db.Tickets.Add(od); db.SaveChanges(); return(RedirectToAction("AvailableSeats", "Orders", new { id = ord.OrderID })); } ViewBag.AllScreenings = GetAllScreenings(); return(View(od)); }
public bool CreateScreening(int id, int movieId, int auditoriumId, DateTime?screeningStart) { try { using (var context = new BiografContext()) { var screening = new Screening() { Id = id, MovieId = context.Movies.Find(movieId).Id, AuditoriumId = context.Auditoria.Find(auditoriumId).Id, ScreeningStart = screeningStart }; context.Screenings.Add(screening); context.SaveChanges(); } return(true); } catch (Exception ex) { return(false); } }
//[HttpPost("DailyUpload")] //public async Task<IActionResult> DailyUpload(List<IFormFile> files) //{ // long size = files.Sum(f => f.Length); // // full path to file in temp location // var filePath = Path.GetTempFileName(); // //var uploads = Path.Combine(_environment.WebRootPath, "uploads"); // foreach (var formFile in files) // { // if (formFile.Length > 0) // { // //using (var fileStream = new FileStream(Path.Combine(uploads, file.FileName), FileMode.Create)) // using (var stream = new FileStream(filePath, FileMode.Create)) // { // await formFile.CopyToAsync(stream); // } // var stream2 = new FileStream(filePath, FileMode.Open, FileAccess.Read); // using (var streamReader = new StreamReader(stream2, Encoding.UTF8)) // { // string line = ""; // while ((line = streamReader.ReadLine()) != null) // { // // process the line // //Stock Code, Stock Name, High, Low, Close, Change, Volume, Value, Frequency // string[] result = line.Split('|'); // if (result[0].ToUpper() != "STOCK CODE") // { // if (!_context.Stock.Any(m => m.StockID == result[0])) // { // _context.Stock.Add(new Stock() { StockID = result[0], Name = "Stock " + result[0] }); // await _context.SaveChangesAsync(); // } // if (_context.StockPrice.Any(m => m.StockID == result[0] && m.Date == DateTime.Today)) // { // var stock = await _context.StockPrice.SingleOrDefaultAsync(m => m.StockID == result[0] && m.Date == DateTime.Today); // stock.High = Convert.ToDecimal(result[3]); // stock.Low = Convert.ToDecimal(result[4]); // stock.Close = Convert.ToDecimal(result[5]); // stock.Open = stock.Close + Convert.ToDecimal(result[2]); // stock.Volume = (long)Convert.ToDecimal(result[6]); // stock.Frequency = (long)Convert.ToDecimal(result[7]); // await _context.SaveChangesAsync(); // } // else // { // StockPrice stock = new StockPrice(); // stock.StockID = result[0]; // stock.Date = DateTime.Today; // stock.High = Convert.ToDecimal(result[3]); // stock.Low = Convert.ToDecimal(result[4]); // stock.Close = Convert.ToDecimal(result[5]); // stock.Open = stock.Close + Convert.ToDecimal(result[2]); // stock.Volume = (long)Convert.ToDecimal(result[6]); // stock.Frequency = (long)Convert.ToDecimal(result[7]); // _context.StockPrice.Add(stock); // await _context.SaveChangesAsync(); // } // } // } // } // } // } // // process uploaded files // // Don't rely on or trust the FileName property without validation. // //return Ok(new { count = files.Count, size, filePath }); // ViewData["Message"] = "Success"; // return View(); //} private async Task <int> CreateStockPriceFile(string filePath) { var stream = new FileStream(filePath, FileMode.Create); using (var streamWriter = new StreamWriter(stream, Encoding.UTF8)) { var header = "Date;Stock;Open;High;Low;Close;Resist;Support;GSLine;Trend"; streamWriter.WriteLine(header); foreach (var stock in await _context.Stock.ToListAsync()) { var lastPrice = await _context.StockPrice.Where(m => m.StockID == stock.StockID).OrderByDescending(x => x.Date).FirstOrDefaultAsync(); var line = ""; var trend = Screening.DetermineTrendByWord(lastPrice); if (lastPrice != null) { line = lastPrice.Date.ToString("yyyy/MM/dd") + ";" + stock.StockID + ";" + lastPrice.Open + ";" + lastPrice.High + ";" + lastPrice.Low + ";" + lastPrice.Close + ";" + lastPrice.Resistance + ";" + lastPrice.Support + ";" + lastPrice.GSLineDirection + ";" + trend; } else { line = lastPrice.Date.ToString("yyyy/MM/dd") + ";" + stock.StockID + ";0;0;0;0;0;0;0;0"; } streamWriter.WriteLine(line); } } return(1); }
public Reservation(Customer customer, Screening screening, Money fee, int audienceCount) { m_Customer = customer; m_Screening = screening; m_Fee = fee; m_AudienceCount = audienceCount; }
public async void AddsScreening() { var context = InMemoryDbContextFactory.GetDbContext(); context.Movies.Add(new Movie { MovieId = 1 }); context.ScreeningRooms.Add(new ScreeningRoom { ScreeningRoomId = 1 }); await context.SaveChangesAsync(); var controller = new ScreeningController(context); var time = DateTime.Now; var Screening = new Screening { DateTime = time, ScreeningRoomId = 1, MovieId = 1 }; var response = await controller.AddScreening(Screening); Assert.IsType <OkObjectResult>(response.Result); var okRes = (OkObjectResult)response.Result; Assert.Equal(time, ((Screening)okRes.Value).DateTime); }
public async Task <IActionResult> Pay(Payment payment) { bool isCardNumberValid = await ValidateCreditCardAsync(payment.CardNumber); if (!isCardNumberValid) { ModelState.AddModelError("CardNumber", "Card number is invalid"); } Screening screening = context.Screenings.Include(s => s.Movie).SingleOrDefault(s => s.Id == payment.ScreeningId); Seat seat = context.Seats.SingleOrDefault(s => s.Id == payment.SeatId); if (!ModelState.IsValid || !isCardNumberValid) { return(View("Index", new PaymentViewModel(screening, seat, User.Identity.GetUserId()))); } SeatScreening seatScreening = context.SeatScreeningMediator.SingleOrDefault(s => s.ScreeningId == payment.ScreeningId && s.SeatId == payment.SeatId); if (seatScreening != null) { // Update seat in db to be occupied so it cannot be booked again seatScreening.Occupied = true; // add payment to db context.Payments.Add(payment); context.SaveChanges(); // if success, redirect to ThankYou page return(RedirectToAction("ThankYou", "Payment")); } return(Content("Payment was not successful!")); }
public IActionResult LogIn(string login = "", string password = "") //Переделать название функции { var db = new DbConfig(); var sr = new Screening(); if (string.IsNullOrEmpty(login) || string.IsNullOrEmpty(password)) { return(RedirectToAction("Authorization", new RouteValueDictionary( new { controller = "User", action = "Authorization", ex = 4 }))); } else { var userId = db.GetSqlQuaryData("select id from users where login = lower(" + "'" + login + "'" + ") " + "AND password = crypt(" + "'" + password + "'" + ", password)"); if (userId.Count() == 0) { return(RedirectToAction("Authorization", new RouteValueDictionary( new { controller = "User", action = "Authorization", ex = 1 }))); } else { login = login.ToLower(); HttpContext.Session.SetString("login", "" + login); HttpContext.Session.SetString("password", "" + password); } } return(RedirectToAction("Profile", new RouteValueDictionary( new { controller = "User", action = "Profile" }))); }
public IViewComponentResult Invoke() { var sr = new Screening(); var db = new DbConfig(); var menu = new List <List <string> >(); var login = HttpContext.Session.GetString("login"); var isAuthorizationUser = false; if (string.IsNullOrEmpty(login)) { menu.Add(userMenu[0]); menu.Add(userMenu[1]); } else { var userProfile = userMenu[2]; userProfile[0] = "" + login; isAuthorizationUser = true; menu.Add(userProfile); menu.Add(userMenu[3]); menu.Add(userMenu[4]); menu.Add(userMenu[5]); menu.Add(userMenu[6]); } ViewBag.isAuthorizationUser = isAuthorizationUser; ViewBag.Menu = menu; return(View()); }
public int SaveScreening(Screening screening) { using (var context = new impiloEntities()) { if (screening.ScreeningID != String.Empty) { context.Screening.Attach(screening); context.Entry(screening).State = EntityState.Modified; context.SaveChanges(); } else { context.Screening.Add(screening); context.SaveChanges(); } } return 0; }
public ActionResult PatientHealthRecord(string arogyaID, int tokenNumber) { ArogyaParivarEntities context = new ArogyaParivarEntities(); Screening model = new Screening(); string searchString = ""; if (arogyaID != "") { searchString = arogyaID; } Session["strArogyaID"] = arogyaID; Session["intTokenNumber"] = tokenNumber; strArogyaID = Session["strArogyaID"].ToString(); intTokenNumber = Convert.ToInt32(Session["intTokenNumber"]); string sortOrder = ""; ViewBag.NameSortParm = String.IsNullOrEmpty(sortOrder) ? "name_desc" : ""; IList<PatientModel> BookList = new List<PatientModel>(); ViewBag.DateSortParm = sortOrder == "Date" ? "date_desc" : "Date"; if (!String.IsNullOrEmpty(searchString)) { BookList = patientBll.Get_PrintCard(sortOrder, searchString); } else { searchString = ""; BookList = patientBll.Get_PrintCard(sortOrder, searchString); } var query2 = from allergy in context.T_Allergies from at in context.M_AllergyType .Where(x => x.ID == allergy.AllergenID).DefaultIfEmpty() //on allergy.AllergenID equals at.ID from ar in context.M_Reaction .Where(x => x.ID == allergy.ReactionID).DefaultIfEmpty() //on allergy.ReactionID equals ar.ID from asev in context.M_Severity .Where(x => x.ID == allergy.SeverityID).DefaultIfEmpty() //on allergy.SeverityID equals asev.ID from ast in context.M_Status .Where(x => x.ID == allergy.StatusID).DefaultIfEmpty() //on allergy.StatusID equals ast.ID where allergy.Token_Number == tokenNumber && EntityFunctions.TruncateTime(allergy.CreateDate).Value == EntityFunctions.TruncateTime(DateTime.Now).Value && allergy.ArogyaID == arogyaID select new Allergy { AllergyType = at.AllergyType, ReactionName = ar.Reaction, SeverityrName = asev.Severity, Status = ast.M_StatusName, // CreateDate = EntityFunctions.TruncateTime(allergy.CreateDate).Value.ToString() //CreateDateString=allergy.CreateDate.Value.ToString("dd/MM/yyyy") }; model.Allergys = query2.ToList(); return View(model); }
public ActionResult PatientHealthRecord(Screening model, string command) { ArogyaParivarEntities context = new ArogyaParivarEntities(); try { try { T_Vitals Vitals = new T_Vitals() { Height = model.Height, Weight = model.Weight, BMI = model.BMI, SysBP = model.SysBP, DiaBP = model.DiaBP, Temparature = model.Temparature, Pulse = model.Pulse, Respiratory = model.Respiratory, Token_Number = 1 }; T_Screenings screenings = new T_Screenings() { ComplaintID = model.ComplaintID, CheckListID = model.CheckListID, PresentingComplaint = model.PresentingComplaint, PastMedicalHistory = model.PastMedicalHistory, PastSurgicalHistory = model.PastSurgicalHistory, FamilyHistory = model.FamilyHistory, CurrentMedication = model.CurrentMedication, ECGOutcomeID = model.ECGOutcomeID, ScreenOutcomeID = model.ScreenOutcomeID, SpecialtyID = model.SpecialtyID, AppointDate = model.AppointDate, CreateDate = model.CreateDate, Token_Number = 1 }; context.T_Screenings.Add(screenings); context.SaveChanges(); return RedirectToAction("PatientSearch"); } catch { return View(model); } } catch { return View(model); } }
public JsonResult saveScreenData(Screening model) { try { ArogyaParivarEntities context = new ArogyaParivarEntities(); T_Screenings modelScreenings = new T_Screenings() { PresentingComplaint = model.PresentingComplaint, PastMedicalHistory = model.PastMedicalHistory, PastSurgicalHistory = model.PastSurgicalHistory, FamilyHistory = model.FamilyHistory, CurrentMedication = model.CurrentMedication, ECGOutcomeID = model.ECGOutcomeID, ScreenOutcomeID = model.ScreenOutcomeID, ArogyaID = Session["strArogyaID"].ToString(), Token_Number = Convert.ToInt32(Session["intTokenNumber"].ToString()), ComplaintID = model.ComplaintID, CheckListID = model.chkId, CreateDate = DateTime.Now, UserID = Convert.ToInt32(Session["UserID"]), }; context.T_Screenings.Add(modelScreenings); context.SaveChanges(); return Json(1, JsonRequestBehavior.AllowGet); } catch { return Json(-1, JsonRequestBehavior.AllowGet); } }
public JsonResult CadSaveData(Screening model) { //string str = "Anemia"; ArogyaParivarEntities context = new ArogyaParivarEntities(); double k = 0.0; try { for (int i = 1; i <= 7; i++) { k += model.Cadmiaradio[i - 1] * model.CadmiaWeightage[i - 1] / 100.0; T_ChkAnemia chkanemia = new T_ChkAnemia() { ChkID = i, AnsID = model.Cadmiaradio[i - 1], ArogyaID = Session["strArogyaID"].ToString(), Token_Number = Convert.ToInt32(Session["intTokenNumber"].ToString()), CreateDate = DateTime.Now, UserID = Convert.ToInt32(Session["UserID"]) }; context.T_ChkAnemia.Add(chkanemia); context.SaveChanges(); } return Json(new { score = k }, JsonRequestBehavior.AllowGet); } catch { return Json(-1, JsonRequestBehavior.AllowGet); } }
public JsonResult saveVitaltData(Screening model) { try { ArogyaParivarEntities context = new ArogyaParivarEntities(); T_Vitals modelVitals = new T_Vitals() { Height = model.Height, Weight = model.Weight, BMI = model.BMI, SysBP = model.SysBP, Pulse = model.Pulse, DiaBP = model.DiaBP, Temparature = model.Temparature, Respiratory = model.Respiratory, ArogyaID = Session["strArogyaID"].ToString(), UserID = Convert.ToInt32(Session["UserID"]), Token_Number = Convert.ToInt32(Session["intTokenNumber"].ToString()), CreateDate = DateTime.Now, }; context.T_Vitals.Add(modelVitals); context.SaveChanges(); return Json(1, JsonRequestBehavior.AllowGet); } catch { return Json(-1, JsonRequestBehavior.AllowGet); } }