// GET: /Scheduler/id
public ActionResult PartialScheduler(string Id)
{
string name = Id;
if (name == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
AppointmentDBContext db = new AppointmentDBContext();
Resources Resource = db.Resources.Find(name);
ApplicationDbContext db2 = new ApplicationDbContext();
ApplicationUser usr = db2.Users
.Where(y => y.UserName.Equals(name))
.ToList()
.FirstOrDefault();
var RoleName = db2.UsersArch
.Where(y => y.UserName.Equals(name) && y.TypeOfChange.Equals("INSERTED"))
.Select(y => y.RId)
.FirstOrDefault();
usr = db2.Users.Find(usr.Id);
ViewBag.RoleName = RoleName.ToLower();
if (Resource == null || usr == null)
{
return(HttpNotFound());
}
Session["ID"] = name;
return(View(usr));
}
static async Task Main(string[] args)
{
string baseDir = AppDomain.CurrentDomain.BaseDirectory;
string configPath = AppDomain.CurrentDomain.BaseDirectory + "settings.json";
if (args.Length > 0)
{
configPath = args[0];
}
Console.WriteLine("Using settings path: " + configPath);
if (!File.Exists(configPath))
{
Console.WriteLine("Error: Config file cannot be found in the specified path.");
Console.ReadLine();
return;
}
//setup
var config = JsonConvert.DeserializeObject <AppSettings>(File.ReadAllText(configPath));
//check/create logs folder
if (!Directory.Exists(AppDomain.CurrentDomain.BaseDirectory + Logs.LogFolderName))
{
Directory.CreateDirectory(AppDomain.CurrentDomain.BaseDirectory + Logs.LogFolderName);
}
//services
#if DEBUG
var logs = Console.Out; //TODO: move to file
#else
var logs = File.CreateText(baseDir + Logs.LogFolderName + '/' + DateTime.Now.ToString(Logs.LogNameFormat) + Logs.LogFileExtension);
#endif
var cap = new AppointmentDBContext(config.CAPDBPath);
var zoom = new ZoomService(config.ZoomAPIKey, config.ZoomAPISecret);
var cache = new MeetingCache(config.CacheFilePath);
PhoneService.Init(config.TwilioAccountSID, config.TwilioAuthToken);
//main functionality
var sync = new MeetingSync(cap, zoom, cache, logs, config);
#if DEBUG
//test date
var syncDate = new DateTime(2021, 5, 31);
//sync appointments
await sync.SyncAppointments(syncDate, DateTime.MaxValue);
#else
var syncDate = DateTime.Now.Subtract(DateTime.Now.TimeOfDay);
//sync appointments
await sync.SyncAppointments(syncDate, DateTime.MaxValue);
#endif
//save cache
cache.RemoveBefore(syncDate.AddDays(-7));
cache.Dispose();
}
public MeetingSync(AppointmentDBContext CAP, ZoomService Zoom, MeetingCache Cache, TextWriter Logger, AppSettings config)
{
this.log = Logger;
this.db = CAP;
this.zoom = Zoom;
this.cache = Cache;
this.employees = config.Employees;
this.createdMsg = config.MeetingCreatedMsg;
this.updatedMsg = config.MeetingUpdateMsg;
this.deletedMsg = config.MeetingDeletedMsg;
this.fromPhone = config.TwilioFromPhone;
}
public JsonResult DeleteEvent(int id)
{
var status = false;
using (AppointmentDBContext dc = new AppointmentDBContext())
{
Appointment deletedEvent = dc.Appointment.Where(x => x.AppointmentID == id).FirstOrDefault();
if (deletedEvent != null)
{
dc.Appointment.Remove(deletedEvent);
dc.SaveChanges();
status = true;
}
}
return new JsonResult { Data = new { status = status } };
}
public ActionResult Edit(ApplicationUser user)
{
ApplicationDbContext context = new ApplicationDbContext();
AppointmentDBContext Appdb = new AppointmentDBContext();
if (ModelState.IsValid)
{
double time = -1;
context.Entry(user).State = EntityState.Modified;
try
{
context.SaveChanges();
}
catch (System.Data.Entity.Validation.DbEntityValidationException dbEx)
{
Exception raise = dbEx;
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
string message = string.Format("{0}:{1}",
validationErrors.Entry.Entity.ToString(),
validationError.ErrorMessage);
// raise a new exception nesting
// the current instance as InnerException
raise = new InvalidOperationException(message, raise);
}
}
throw raise;
}
// Dodanie do archiwum użytkownika, który zmienił dane pacjenta:
string query = "UPDATE [dbo].[UsersArch] SET RId = (SELECT RId FROM [dbo].[UsersArch] WHERE TypeOfChange = 'INSERTED' AND UserName = "******"), DBUSer = '******' WHERE TypeOfChange = 'UPDATED-INSERTED' AND UserName = "******" AND DateOfChange >= '" + DateTime.Now.AddSeconds(time) + "'";;
context.Database.ExecuteSqlCommand(query);
query = "UPDATE [dbo].[UsersArch] SET RId = (SELECT RId FROM [dbo].[UsersArch] WHERE TypeOfChange = 'INSERTED' AND UserName = "******"), DBUSer = '******' WHERE TypeOfChange = 'UPDATED-DELETED' AND UserName = "******" AND DateOfChange >= '" + DateTime.Now.AddSeconds(time) + "'";
context.Database.ExecuteSqlCommand(query);
query = "UPDATE [dbo].[Resources] SET fsname = '" + user.Name + " " + user.Surname + "' WHERE name = '" + user.UserName + "'";
Appdb.Database.ExecuteSqlCommand(query);
return(RedirectToAction("WorkerSearch", "Search"));
}
return(View(user));
}
public ActionResult AppointmentSearch(string searching, string sortOrder)
{
ViewBag.DateSortParm = String.IsNullOrEmpty(sortOrder) ? "date_desc" : "";
ViewBag.NameSortParm = sortOrder == "name" ? "name_desc" : "name";
ViewBag.PriceSortParm = sortOrder == "price" ? "price_desc" : "price";
ViewBag.AddPriceSortParm = sortOrder == "addPrice" ? "addPrice_desc" : "addPrice";
ViewBag.TotalPriceSortParm = sortOrder == "totalPrice" ? "totalPrice_desc" : "totalPrice";
AppointmentDBContext context = new AppointmentDBContext();
DateTime dateTime;
DateTime.TryParse(searching, out dateTime);
var appointmentsList = context.Appointments.Where(x => x.service_name.Contains(searching) ||
(x.appoint_date.Year == dateTime.Year && x.appoint_date.Month == dateTime.Month &&
x.appoint_date.Day == dateTime.Day) ||
(x.service_price.ToString() == searching) ||
(x.supplies_price.ToString() == searching) ||
((x.supplies_price + x.service_price).ToString() == searching) ||
searching == null || searching == "\0");
switch (sortOrder)
{
case "name": appointmentsList = appointmentsList.OrderBy(s => s.service_name); break;
case "name_desc": appointmentsList = appointmentsList.OrderByDescending(s => s.service_name); break;
case "price": appointmentsList = appointmentsList.OrderBy(s => s.service_price); break;
case "price_desc": appointmentsList = appointmentsList.OrderByDescending(s => s.service_price); break;
case "addPrice": appointmentsList = appointmentsList.OrderBy(s => s.supplies_price); break;
case "addPrice_desc": appointmentsList = appointmentsList.OrderByDescending(s => s.supplies_price); break;
case "date_desc": appointmentsList = appointmentsList.OrderByDescending(s => s.appoint_date); break;
case "totalPrice": appointmentsList = appointmentsList.OrderBy(x => (x.supplies_price + x.service_price)); break;
case "totalPrice_desc": appointmentsList = appointmentsList.OrderByDescending(x => (x.supplies_price + x.service_price)); break;
default: appointmentsList = appointmentsList.OrderBy(s => s.appoint_date); break;
}
return(View(appointmentsList.ToList()));
}
public ActionResult DeleteConfirmed(string id)
{
ApplicationDbContext context = new ApplicationDbContext();
AppointmentDBContext Appdb = new AppointmentDBContext();
ApplicationUser user = context.Users.Find(id);
context.Users.Remove(user);
context.SaveChanges();
string query = "UPDATE [dbo].[UsersArch] SET RId = (SELECT RId FROM [dbo].[UsersArch] WHERE TypeOfChange = 'INSERTED' AND UserName = '******'), DBUSer = '******' WHERE TypeOfChange = 'DELETED' AND UserName = '******'";
context.Database.ExecuteSqlCommand(query);
query = "DELETE FROM [dbo].[WorkingTime] WHERE resource = (SELECT id FROM [dbo].[Resources] WHERE name = '" + user.UserName + "')";
Appdb.Database.ExecuteSqlCommand(query);
query = "DELETE FROM [dbo].[Resources] WHERE name = '" + user.UserName + "'";
Appdb.Database.ExecuteSqlCommand(query);
return(RedirectToAction("WorkerSearch", "Search"));
}
public ActionResult ListExpertInfos()
{
using (AppointmentDBContext ctx = new AppointmentDBContext())
{
var ExpertInfos = (from c in ctx.Expert
join co in ctx.Contact on c.ExpertID equals co.ExpertID
where c.ExpertID != 1 && co.IsActive == true && c.CompanyID==AccountController._compID
select new ExpertInfosDTO
{
ID = c.ExpertID,
Uzmanlik = c.Profession,
AdSoyad = c.Name+" "+c.Surname ,
//Soyad = c.Surname,
Telno = co.PhoneNumber1,
Not = c.Note
}).OrderBy(x => x.AdSoyad).ToList();
return View(ExpertInfos);
}
}
public ActionResult Edit([Bind(Include = "ID, patients_pesel, estim_disease, real_disease, dis_descript, appoint_date, specialization, docs_pesel, service_type, service_name, service_price, is_paid, supplies_price")] Appointment appointment)
{
AppointmentDBContext context = new AppointmentDBContext();
if (ModelState.IsValid)
{
double time = -1;
context.Entry(appointment).State = EntityState.Modified;
context.SaveChanges();
string query = "UPDATE [dbo].[AppointmentsArch] SET DBUSer = '******' WHERE Idd = '" + appointment.ID + "' AND TypeOfChange = 'UPDATED-INSERTED' AND DateOfChange >= '" + DateTime.Now.AddSeconds(time) + "'";
db.Database.ExecuteSqlCommand(query);
query = "UPDATE [dbo].[AppointmentsArch] SET DBUSer = '******' WHERE Idd = '" + appointment.ID + "' AND TypeOfChange = 'UPDATED-DELETED' AND DateOfChange >= '" + DateTime.Now.AddSeconds(time) + "'";
db.Database.ExecuteSqlCommand(query);
return(RedirectToAction("Index"));
}
return(View(appointment));
}
public ActionResult ListClientInfos()
{
using (AppointmentDBContext ctx = new AppointmentDBContext())
{
var ClientInfos = (from c in ctx.Client
join co in ctx.Contact on c.ClientID equals co.ClientID
where c.ClientID != 8 && co.IsActive == true && c.CompanyID==AccountController._compID
select new ClientInfosDTO
{
ID = c.ClientID,
DanisanTuru = (DateTime.Now.Year - c.BirthDate.Year) > 18 ? "Yetişkin" : "Çocuk",
TCKimlik = c.TcKimlik,
AdSoyad = c.Name+" "+c.Surname,
//Soyad = c.Surname,
Telno = co.PhoneNumber1,
Adres = co.Address,
DevamDurumu = c.Continuity,
}).OrderBy(x=>x.AdSoyad).ToList();
return View(ClientInfos);
}
}
public DoctorsController(AppointmentDBContext context)
{
this.context = context;
}
public AppointmentsController(AppointmentDBContext context, UserDBContext userContext)
{
_context = context;
_userContext = userContext;
}
public async Task <ActionResult> Register(RegisterViewModel model)
{
if (ModelState.IsValid)
{
if (model.UserRoles != "Lekarz")
{
model.Specialization = null;
}
var user = new ApplicationUser
{
Name = model.Name,
Surname = model.Surname,
Seniority = model.Seniority,
Experience = model.Experience,
UserName = model.UserName,
Email = model.Email,
Specialization = model.Specialization
};
var result = await UserManager.CreateAsync(user, model.Password);
if (result.Succeeded)
{
// Wyłączenie automatycznego logowania po rejestracji:
// await SignInManager.SignInAsync(user, isPersistent:false, rememberBrowser:false);
// For more information on how to enable account confirmation and password reset please visit https://go.microsoft.com/fwlink/?LinkID=320771
// Send an email with this link
// string code = await UserManager.GenerateEmailConfirmationTokenAsync(user.Id);
// var callbackUrl = Url.Action("ConfirmEmail", "Account", new { userId = user.Id, code = code }, protocol: Request.Url.Scheme);
// await UserManager.SendEmailAsync(user.Id, "Confirm your account", "Please confirm your account by clicking <a href=\"" + callbackUrl + "\">here</a>");
// Dodanie roli dla nowego użytkownika.
// Rola dodawania jest później, stąd dwa wpisy w archiwum przy tworzeniu nowego konta.
await this.UserManager.AddToRoleAsync(user.Id, model.UserRoles);
// Dodanie do archiwum ID osoby, która stworzyła nowe konto użytkownika, a także dodanie roli dodanego użytkownika:
string query = "UPDATE [dbo].[UsersArch] SET RId = '" + model.UserRoles + "', DBUSer = '******' WHERE TypeOfChange = 'INSERTED' AND UserName = "******"DELETE FROM [dbo].[UsersArch] WHERE TypeOfChange = 'UPDATED-DELETED' AND UserName = "******"DELETE FROM [dbo].[UsersArch] WHERE TypeOfChange = 'UPDATED-INSERTED' AND UserName = "******"INSERT INTO [dbo].[Resources] (name, fsname) VALUES ('" + model.UserName + "', '" + model.Name + " " + model.Surname + "')";
Appdb.Database.ExecuteSqlCommand(query);
return(RedirectToAction("ConfirmRegistration", "Account"));
}
AddErrors(result);
}
if (User.IsInRole("Administrator"))
{
ViewBag.UserRoles = new SelectList(context.Roles.Where(u => !u.Name.Contains("Administrator"))
.ToList(), "Name", "Name");
}
else if (User.IsInRole("Manager"))
{
ViewBag.UserRoles = new SelectList(context.Roles.Where(u => !u.Name.Contains("Administrator") && !u.Name.Contains("Manager"))
.ToList(), "Name", "Name");
}
List <SelectListItem> Specializations = new List <SelectListItem>()
{
new SelectListItem {
Text = "Alergologia"
},
new SelectListItem {
Text = "Alergologia"
},
new SelectListItem {
Text = "Anestezjologia i intensywna terapia"
},
new SelectListItem {
Text = "Angiologia"
},
new SelectListItem {
Text = "Audiologia i foniatria"
},
new SelectListItem {
Text = "Balneologia i medycyna fizykalna"
},
new SelectListItem {
Text = "Chirurgia dziecięca"
},
new SelectListItem {
Text = "Chirurgia klatki piersiowej"
},
new SelectListItem {
Text = "Chirurgia naczyniowa"
},
new SelectListItem {
Text = "Chirurgia ogólna"
},
new SelectListItem {
Text = "Chirurgia onkologiczna"
},
new SelectListItem {
Text = "Chirurgia plastyczna"
},
new SelectListItem {
Text = "Chirurgia stomatologiczna"
},
new SelectListItem {
Text = "Chirurgia szczękowo-twarzowa"
},
new SelectListItem {
Text = "Chirurgia płuc"
},
new SelectListItem {
Text = "Chirurgia płuc dzieci"
},
new SelectListItem {
Text = "Choroby płuc"
},
new SelectListItem {
Text = "Choroby płuc dzieci"
},
new SelectListItem {
Text = "Choroby wewnętrzne"
},
new SelectListItem {
Text = "Choroby zakaźne"
},
new SelectListItem {
Text = "Dermatologia i wenerologia"
},
new SelectListItem {
Text = "Diabetologia"
},
new SelectListItem {
Text = "Endokrynologia"
},
new SelectListItem {
Text = "Endokrynologia ginekologiczna i rozrodczość"
},
new SelectListItem {
Text = "Endokrynologia i diabetologia dziecięca"
},
new SelectListItem {
Text = "Epidemiologia"
},
new SelectListItem {
Text = "Farmakologia kliniczna"
},
new SelectListItem {
Text = "Gastroenterologia"
},
new SelectListItem {
Text = "Gastroenterologia dziecięca"
},
new SelectListItem {
Text = "Genetyka kliniczna"
},
new SelectListItem {
Text = "Geriatria"
},
new SelectListItem {
Text = "Ginekologia onkologiczna"
},
new SelectListItem {
Text = "Hematologia"
},
new SelectListItem {
Text = "Hipertensjologia"
},
new SelectListItem {
Text = "Immunologia kliniczna"
},
new SelectListItem {
Text = "Intensywna terapia"
},
new SelectListItem {
Text = "Kardiochirurgia"
},
new SelectListItem {
Text = "Kardiologia"
},
new SelectListItem {
Text = "Kardiologia dziecięca"
},
new SelectListItem {
Text = "Medycyna lotnicza"
},
new SelectListItem {
Text = "Medycyna morska i tropikalna"
},
new SelectListItem {
Text = "Medycyna nuklearna"
},
new SelectListItem {
Text = "Medycyna paliatywna"
},
new SelectListItem {
Text = "Medycyna pracy"
},
new SelectListItem {
Text = "Medycyna ratunkowa"
},
new SelectListItem {
Text = "Medycyna rodzinna"
},
new SelectListItem {
Text = "Medycyna sądowa"
},
new SelectListItem {
Text = "Medycyna sportowa"
},
new SelectListItem {
Text = "Mikrobiologia lekarska"
},
new SelectListItem {
Text = "Nefrologia"
},
new SelectListItem {
Text = "Nefrologia dziecięca"
},
new SelectListItem {
Text = "Neonatologia"
},
new SelectListItem {
Text = "Neurochirurgia"
},
new SelectListItem {
Text = "Neurologia"
},
new SelectListItem {
Text = "Neurologia dziecięca"
},
new SelectListItem {
Text = "Neuropatologia"
},
new SelectListItem {
Text = "Okulistyka"
},
new SelectListItem {
Text = "Onkologia i hematologia dziecięca"
},
new SelectListItem {
Text = "Onkologia kliniczna "
},
new SelectListItem {
Text = "Ortodoncja"
},
new SelectListItem {
Text = "Ortopedia i traumatologia narządu ruchu"
},
new SelectListItem {
Text = "Otorynolaryngologia"
},
new SelectListItem {
Text = "Otorynolaryngologia dziecięca"
},
new SelectListItem {
Text = "Patomorfologia"
},
new SelectListItem {
Text = "Pediatria"
},
new SelectListItem {
Text = "Pediatria metaboliczna"
},
new SelectListItem {
Text = "Perinatologia"
},
new SelectListItem {
Text = "Periodontologia"
},
new SelectListItem {
Text = "Położnictwo i ginekologia"
},
new SelectListItem {
Text = "Protetyka stomatologiczna"
},
new SelectListItem {
Text = "Psychiatria"
},
new SelectListItem {
Text = "Psychiatria dzieci i młodzieży"
},
new SelectListItem {
Text = "Radiologia i diagnostyka obrazowa"
},
new SelectListItem {
Text = "Radioterapia onkologiczna"
},
new SelectListItem {
Text = "Rehabilitacja medyczna"
},
new SelectListItem {
Text = "Reumatologia"
},
new SelectListItem {
Text = "Seksuologia"
},
new SelectListItem {
Text = "Stomatologia dziecięca"
},
new SelectListItem {
Text = "Stomatologia zachowawcza z endodoncją"
},
new SelectListItem {
Text = "Toksykologia kliniczna"
},
new SelectListItem {
Text = "Transfuzjologia kliniczna"
},
new SelectListItem {
Text = "Transplantologia kliniczna"
},
new SelectListItem {
Text = "Urologia"
},
new SelectListItem {
Text = "Urologia dziecięca"
},
new SelectListItem {
Text = "Zdrowie publiczne "
},
};
ViewBag.Spec = Specializations;
return(View(model));
}
public RBookAppointment(AppointmentDBContext context)
{
this.context = context;
}
public AppointmentStatusController(AppointmentDBContext context)
{
_context = context;
}
public BenchesController(AppointmentDBContext context)
{
_context = context;
}
public BaseRepository()
{
_context = new AppointmentDBContext();
_dbSet = _context.Set <TEntity>();
}
public HomeController(AppointmentDBContext cxt)
{
context = cxt;
}
