public frmReservation(UserControl register, int?id = null)
{
InitializeComponent();
modernFont = new PrivateFontCollection();
ChangeFont(this, 10);
ClincDbContext = new ClinicDBContext();
PatientRepository = new PatientRepository();
cmbPatiendGender.DataSource = ClincDbContext.Genders.ToList();
cmbPatiendGender.ValueMember = "Id";
cmbPatiendGender.DisplayMember = "GenderType";
ControlForAll = register;
if (id.HasValue)
{
btnReservation.Text = "تعديل";
PatientId = id.Value;
Patient patient = PatientRepository.Find(PatientId);
txtPatientName.Text = patient.FullName;
txtPatientPhone.Text = patient.Phone;
txtPatientAge.Text = patient.Age + "";
txtPatientAddress.Text = patient.Address;
}
}
protected void btnClinicSave_Click(object sender, EventArgs e)
{
if (txtEntityName.Text == "")
{
ClinclblSaveStatus.Text = "Please Fill a Entity Name";
lblNameReq.Visible = true;
}
else if (ddlEntityTypeID.SelectedIndex == 0)
{
ClinclblSaveStatus.Text = "Please Select Entity Type";
lbltypeReq.Visible = true;
}
else if (ddlAreaID.SelectedIndex == 0)
{
ClinclblSaveStatus.Text = "Please Select Area";
lblAreaReq.Visible = true;
}
else
{
using (ClinicDBContext newEn = new ClinicDBContext())
{
Entity en = new Entity();
en.EntityName = txtEntityName.Text;
//en.EntityCode = int.Parse(txtEntityCode.Text);
en.EntityAddress = txtEntityAddress.Text;
en.EntityTypeID = int.Parse(ddlEntityTypeID.SelectedValue);
en.Tel1 = txtTel1.Text;
en.Tel2 = txtTel2.Text;
en.Tel3 = txtTel3.Text;
en.Fax = txtFax.Text;
en.EntityEmailAddress = txtEntityEmailAddress.Text;
en.EntityWebSite = txtEntityWebSite.Text;
en.BrickID = int.Parse(ddlAreaID.SelectedValue);
en.Deleted = false;
en.EntryDate = DateTime.Now;
en.EntryEmployeeID = int.Parse(Session["EmployeeHRCodeFromAdmin"].ToString());
newEn.Entities.Add(en);
int roweffected = newEn.SaveChanges();
if (roweffected > 0)
{
ClinclblSaveStatus.Text = "Saved";
lblNameReq.Visible = false;
lbltypeReq.Visible = false;
lblAreaReq.Visible = false;
clearFields();
}
else
{
ClinclblSaveStatus.Text = "Error";
}
}
}
using (EntitiesViewDBContext db = new EntitiesViewDBContext())
{
int maxent = db.View_Entities.Max(en => en.EntityID);
var clinicdata = from clinic_tbl in db.View_Entities where (clinic_tbl.Deleted == null || clinic_tbl.Deleted == false) && clinic_tbl.EntityID == maxent select clinic_tbl;
GridViewClinic.DataSource = clinicdata.ToList();
GridViewClinic.DataBind();
}
}
protected void Button2_Click(object sender, EventArgs e)
{
{
using (ClinicDBContext Entdb = new ClinicDBContext())
{
if (txtEntityNameSe.Text != "" & rbEntityName.Checked == true)
{
var clinicdata = (from clinic_tbl in Entdb.Entities where clinic_tbl.EntityName.Contains(txtEntityNameSe.Text) select clinic_tbl).ToList();
ddlEntityIDSe.DataValueField = "EntityID";
ddlEntityIDSe.DataTextField = "EntityName";
ddlEntityIDSe.DataSource = clinicdata;
ddlEntityIDSe.DataBind();
}
else if (txtEntityNameSe.Text != "" & rbEntityCode.Checked == true)
{
int EntityCode = int.Parse(txtEntityNameSe.Text);
var clinicdata = (from clinic_tbl in Entdb.Entities where clinic_tbl.EntityID == EntityCode select clinic_tbl).ToList();
ddlEntityIDSe.DataValueField = "EntityID";
ddlEntityIDSe.DataTextField = "EntityName";
ddlEntityIDSe.DataSource = clinicdata;
ddlEntityIDSe.DataBind();
}
}
}
}
public ActionResult Index()
{
DashBoardInfoData infoData = new DashBoardInfoData();
using (ClinicDBContext db = new ClinicDBContext())
{
DateTime date = DateTime.Today;
infoData.TodayEarning = db.Incomes.Where(c => DbFunctions.TruncateTime(c.IncomeDate) == DbFunctions.TruncateTime(date)).Sum(s => (decimal?)s.Amount) ?? 0;
infoData.MonthlyEarning = db.Incomes.Where(c => DbFunctions.TruncateTime(c.IncomeDate).Value.Month == date.Month).Sum(s => (decimal?)s.Amount) ?? 0;
infoData.YearlyEarning = db.Incomes.Where(c => DbFunctions.TruncateTime(c.IncomeDate).Value.Year == date.Year).Sum(s => (decimal?)s.Amount) ?? 0;
infoData.Appointments = db.Appointments.Where(c => DbFunctions.TruncateTime(c.Date) >= date).Include(c => c.Person).ToList();
}
if (infoData.TodayEarning == null)
{
infoData.TodayEarning = 0;
}
if (infoData.YearlyEarning == null)
{
infoData.YearlyEarning = 0;
}
if (infoData.MonthlyEarning == null)
{
infoData.MonthlyEarning = 0;
}
return(View(infoData));
}
private void LoadEntity()
{
using (ClinicDBContext db = new ClinicDBContext())
{
var clinicdata = from clinic_tbl in db.Entities where (clinic_tbl.Deleted == null || clinic_tbl.Deleted == false) select clinic_tbl;
GridViewClinic.DataSource = clinicdata.ToList();
GridViewClinic.DataBind();
}
}
public UC6_showProcess(ClinicDBContext dbContext, StaffLogin login)
{
InitializeComponent();
this.db = new ClinicDB(dbContext);
technician = login;
uc6_showProcess = new UC6_ShowProcess(db);
procesSpec = new List<ProcesSpec>();
}
public TechnicianMainWindow()
{
InitializeComponent();
context = new ClinicDBContext();
db = new ClinicDB(context);
//db = new ClinicNoDB();
timeStamp = new TimeStamp();
printer = new NoPrinter(timeStamp);
scanner = new NoScanner(timeStamp);
technician = new StaffLogin();
}
public ClinicianDBLogic(ClinicDBContext dbContext)
{
_dbContext = dbContext;
}
static void Main(string[] args)
{
ClinicDBContext dbContext = new ClinicDBContext();
ClinicianDBLogic clinicianDbLogic = new ClinicianDBLogic(dbContext);
ProgramHL7 program = new ProgramHL7();
program.metode();
#region Create (CRUD)
#region Create patient
Patient newPatient = new Patient()
{
CPR = "123456-2332",
Name = "Accepttest",
Lastname = "Patient",
Adress = "Testvej 1",
zipcode = 4321,
Age = 20,
City = "TestBy",
Email = "*****@*****.**",
MobilNummer = "30405060"
};
clinicianDbLogic.CreatePatient(newPatient);
#endregion
#region Create Staff
StaffLogin newStaffLogin = new StaffLogin()
{
Name = "Kliniker",
Password = "******",
StaffStatus = Status.Clinician,
};
//clinicianDbLogic.CreateStaffLogin(newStaffLogin);
StaffLogin nStaffLogin = new StaffLogin()
{
Name = "Tekniker",
Password = "******",
StaffStatus = Status.Technician
};
//clinicianDbLogic.CreateStaffLogin(nStaffLogin);
#region Create EarCast 2
EarCast newCast = new EarCast()
{
EarSide = Ear.Right,
};
//clinicianDbLogic.CreateEarCast(newCast);
#endregion
#endregion
#region Create GeneralSpec
GeneralSpec newGeneralSpecL = new GeneralSpec()
{
//CPR = "111111-1111",
Type = Material.AntiAllergi,
Color = PlugColor.Honey,
EarSide = Ear.Left,
CreateDate = DateTime.Now,
StaffLoginFK = 1,
};
//clinicianDbLogic.CreateNewGeneralSpec(newGeneralSpecL);
GeneralSpec newGeneralSpecR = new GeneralSpec()
{
//CPR = "111111-1111",
Type = Material.AntiAllergi,
Color = PlugColor.Honey,
EarSide = Ear.Right,
CreateDate = DateTime.Now,
StaffLoginFK = 1,
};
//clinicianDbLogic.CreateNewGeneralSpec(newGeneralSpecR);
#endregion
#region Create TecnicalSpec
TecnicalSpec newTecnicalSpecR = new TecnicalSpec()
{
EarSide = Ear.Right,
CreateDate = DateTime.Now,
StaffLoginFK = 1,
//CPR = "111111-1111"
};
//clinicianDbLogic.CreateTechnicalSpec(newTecnicalSpecR);
TecnicalSpec newTecnicalSpecL = new TecnicalSpec()
{
EarSide = Ear.Left,
CreateDate = DateTime.Now,
StaffLoginFK = 1,
//CPR = "111111-1111",
};
//clinicianDbLogic.CreateTechnicalSpec(newTecnicalSpecL);
#endregion
#region Create rawEarPrint
RawEarPrint print = new RawEarPrint()
{
EarSide = Ear.Left,
StaffLoginFK = 1,
PrintDate = DateTime.Now,
};
//clinicianDbLogic.SavePrint(print, "111111-1111");
#endregion
#endregion
#region Delete (CRUD)
#region Delete patient
//Patient DeletePatient = new Patient()
//{
// PCPR = "110396-0000",
//};
//clinicianDbLogic.DeletePatient(DeletePatient);
#endregion
#region Delete EarCast
//EarCast DeleteEarCast = new EarCast()
//{
// EarCastID = 2,
//};
// clinicianDbLogic.DeleteEarCast(DeleteEarCast);
#endregion
#endregion
#region Update (CRUD)
#region Update patient
//Patient UpdatePatient = new Patient()
//{
// PCPR = "110396-0000",
// Lastname = "Nedergaard Enevoldsen",
// Adress = "Trøjbordvej 72",
//};
//clinicianDbLogic.UpdatePatient(UpdatePatient);
#endregion
#endregion
#region Retrive (CRUD)
#region Retrieve Alle patienter
//List<Patient> Patients = clinicianDbLogic.GetAllPatients();
//foreach (Patient patient in Patients)
//{
// Console.WriteLine(patient.Name);
//}
#endregion
#region Retrieve Patient tilhørende øre afstøbning
//Patient Patient = clinicianDbLogic.GetPatientFromEarCast(2);
//Console.WriteLine(Patient.Name);
#endregion
#region Create afstøbning
//EarCast earCast = clinicianDbLogic.Get
//Patient Patient = clinicianDbLogic.GetPatient("250997-0000");
// Console.WriteLine(Patient.Name);
#endregion
#region Retrieve Patient tilhørende øre afstøbning
//Patient earPatient = clinicianDbLogic.GetPatientWithEarCast("250997-0000");
//foreach (EarCast earPatientEarCast in earPatient.EarCasts)
//{
// Console.WriteLine($"PCPR: {earPatientEarCast.PCPR} Øre side: {earPatientEarCast.EarSide.ToString()} ID: {earPatientEarCast.EarCastID}");
//}
#endregion
#region Hent en patient med alle parametre udfyldt
//Patient patient = clinicianDbLogic.GetPatientWithGeneralSpecAndTechnicalSpec("111111-1111");
#endregion
#endregion
}
public ClinicDatabase()
{
_dbContext = new ClinicDBContext();
}
public DB_Login()
{
context = new ClinicDBContext();
}
public ClinicDB(ClinicDBContext dbContext)
{
_dbContext = new ClinicDBContext();
//= dbContext;
}
public DLLShowProcess(ClinicDBContext dbContext)
{
_dbContext = dbContext;
}
public ClinicController(ClinicDBContext context)
{
_context = context;
}