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