// GET: Medical
public ActionResult Index()
{
var service = new MedicalService();
var model = service.GetMedicals();
return(View(model));
}
//获取专科下医生就诊人次列表
public List <MedicalService> GetDoctorSpecialistMedicalService(string zkid)
{
string cmd = @"select * from (Select count(*)hz,ysyhid from yyfz_yyxx where zkid=:ZKID and pbid in(
select pbid from yyfz_yspb where
trunc(sbsj) = trunc(sysdate) and zllx <>'15'and ztbz = '1'
and (zbyy is null or zbyy in(select dm from yyfz_ddlbn where lb = 'FZ15'and nblb = '01')))
and ztbz in('2','3','5') group by ysyhid) a left join
(Select count(*)jz,ysyhid from yyfz_yyxx where zkid=:ZKID and pbid in(
select pbid from yyfz_yspb where
trunc(sbsj) = trunc(sysdate) and zllx <>'15'and ztbz = '1'
and (zbyy is null or zbyy in(select dm from yyfz_ddlbn where lb = 'FZ15'and nblb = '01')))
and ztbz = '5'group by ysyhid) b on a.ysyhid = b.ysyhid left join (SELECT yhid, yhxm FROM XTGL_yhxx) on yhid=a.ysyhid order by hz desc";
List <MedicalService> list_MedicalService = new List <MedicalService>();
DbCommand queryCommand = db.GetSqlStringCommand(cmd);
db.AddInParameter(queryCommand, ":ZKID", DbType.String, zkid);
using (IDataReader reader = db.ExecuteReader(queryCommand))
{
while (reader.Read())
{
MedicalService medicalservice = new MedicalService();
medicalservice.DoctorID = reader["ysyhid"] is DBNull ? 0 : Convert.ToInt32(reader["ysyhid"]);
medicalservice.DoctorName = reader["yhxm"] is DBNull ? "" : (reader["yhxm"]).ToString();
//medicalservice.SpecialistID = reader["zkid"] is DBNull ? 0 : Convert.ToInt32(reader["zkid"]);
//medicalservice.SpecialistName = reader["BMMC"] is DBNull ? "" : (reader["BMMC"]).ToString();
medicalservice.HZnums = reader["hz"] is DBNull ? 0 : Convert.ToInt32(reader["hz"]);
medicalservice.JZnums = reader["jz"] is DBNull ? 0 : Convert.ToInt32(reader["jz"]);
list_MedicalService.Add(medicalservice);
}
}
return(list_MedicalService);
}
protected void AddMSButton_Click(object sender, EventArgs e)
{
Button btn = (Button)sender;
String btnId = btn.ID;
if (btnId.Equals("AddMSButton"))
{
if (IsValid)
{
System.Threading.Thread.Sleep(3000);
var msName = NameTextBox.Text;
var groupName = GroupNameTextBox.Text;
var groupId = GetGroupId(groupName)[0];
var msPrice = PriceTextBox.Text;
var ms = new MedicalService()
{
medicalServiceName = msName, medicalServiceGroupId = groupId, price = Convert.ToDecimal(msPrice)
};
_dataContext.MedicalServices.InsertOnSubmit(ms);
_dataContext.SubmitChanges();
MedicalServiceList.DataBind();
ResetInputField();
}
}
else if (btnId.Equals("ResetMSButton"))
{
ResetInputField();
}
}
public async Task <IActionResult> PutMedicalServices(long id, MedicalService medicalServices)
{
if (id != medicalServices.Id)
{
return(BadRequest());
}
_context.Entry(medicalServices).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!MedicalServicesExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public async Task <ActionResult <MedicalService> > PostMedicalServices(MedicalService medicalServices)
{
_context.MedicalServices.Add(medicalServices);
await _context.SaveChangesAsync();
return(CreatedAtAction(nameof(GetMedicalServices), new { id = medicalServices.Id }, medicalServices));
}
/// <summary>
/// Konstruktor tworzący usługi bazodanowe na potrzeby usług biznesowych obejmujących medyczne funkcje placówki.
/// </summary>
public MedicalBusinessService()
{
medicalService = new MedicalService();
patientService = new PatientService();
userService = new UserService();
userBusinessService = new UserBusinessService();
}
public void Save(RegisterMedicalOperationModel model, int type)
{
MedicalService medicalOperation = null;
Patient patient = new Patient
{
Name = model.PatientName,
Address = new Address
{
City = model.City,
Street = model.Street,
StreetNumber = model.StreetNumber
},
Phone = model.Phone,
Ucn = model.Ucn,
};
medicalOperation = new MedicalService
{
Patient = patient,
OperationDescription = model.OperationDescription,
DoctorId = model.DoctorId,
OperationResult = model.OperationResult,
MedicalServiceDate = DateTime.ParseExact(model.Date, "MM/dd/yyyy", null),
MedicalServiceType = (MedicalServiceType)type
};
medicalServiceRepository.Add(medicalOperation);
}
public MedicalService GetEmergencyDetails(int medicalId)
{
Query = "SELECT * FROM MedicalEmergency WHERE MedicalId = @medicalId";
Command = new SqlCommand(Query, Connection);
Command.Parameters.AddWithValue("medicalId", medicalId);
Connection.Open();
Reader = Command.ExecuteReader();
MedicalService aMedicalService = null;
while (Reader.Read())
{
aMedicalService = new MedicalService();
aMedicalService.Id = Convert.ToInt32(Reader["Id"]);
aMedicalService.TwentyFourService = Reader["TwentyFourService"].ToString();
aMedicalService.EmergencyService = Reader["EmergencyService"].ToString();
aMedicalService.AmbulanceService = Reader["AmbulanceService"].ToString();
aMedicalService.SeatCapacity = Convert.ToInt32(Reader["SeatCapacity"]);
aMedicalService.EmergencyPhoneNo = Reader["EmergencyPhoneNo"].ToString();
aMedicalService.EmergencyPhoneNo2 = Reader["EmergencyPhoneNo2"].ToString();
aMedicalService.AmbulancePhoneNo = Reader["AmbulancePhoneNo"].ToString();
aMedicalService.AmbulancePhoneNo2 = Reader["AmbulancePhoneNo2"].ToString();
}
Reader.Close();
Connection.Close();
return(aMedicalService);
}
protected void UpdateButton_Click(object sender, EventArgs e)
{
if (IsValid)
{
System.Threading.Thread.Sleep(3000);
var editedRowIndex = MedicalServiceList.EditIndex;
var lblId = MedicalServiceList.Rows[editedRowIndex].FindControl("EditId") as Label;
var txtbGroupId = MedicalServiceList.Rows[editedRowIndex].FindControl("EditGroupId") as TextBox;
var txtbName = MedicalServiceList.Rows[editedRowIndex].FindControl("EditName") as TextBox;
var txtbPrice = MedicalServiceList.Rows[editedRowIndex].FindControl("editPrice") as TextBox;
var id = long.Parse(lblId.Text);
var groupdId = GetGroupId(txtbGroupId.Text)[0];
var name = txtbName.Text;
var price = decimal.Parse(txtbPrice.Text);
var medicalService = new MedicalService()
{
medicalServiceId = id, medicalServiceGroupId = groupdId, medicalServiceName = name, price = price
};
_dataContext.MedicalServices.Attach(medicalService);
_dataContext.Refresh(RefreshMode.KeepCurrentValues, medicalService);
_dataContext.SubmitChanges();
MedicalServiceList.EditIndex = -1;
//Use For Debug passed value
//Debug.WriteLine("id: " + id);
//Debug.WriteLine("groupId: " + groupdId);
//Debug.WriteLine("Name: " + name);
//Debug.WriteLine("price: " + price);
}
}
public ActionResult Details(int id)
{
var svc = new MedicalService();
var model = svc.GetMedicalById(id);
return(View(model));
}
public void CalculateTotalPriceTest()
{
testpatient.RecordList.Add(new Record(testpatient));
testpatient.RecordList[0].CurrentBill = new Bill(testpatient.RecordList[0]);
MedicalService testservice = new MedicalService(30, "TestName", "TM");
testwife.RegisterTreatmentToBill(testpatient, testservice);
Assert.IsTrue(testpatient.RecordList[0].CurrentBill.TotalPrice == 30);
}
public void AddToBillItemListTest()
{
testpatient.RecordList.Add(new Record(testpatient));
testpatient.RecordList[0].CurrentBill = new Bill(testpatient.RecordList[0]);
MedicalService testservice = new MedicalService(30, "TestName", "TM");
testwife.RegisterTreatmentToBill(testpatient, testservice);
Assert.IsNotNull(testpatient.RecordList[0].CurrentBill.BillItemList);
}
public ActionResult DeletePost(int id)
{
var service = new MedicalService();
service.DeleteMedical(id);
TempData["SaveResult"] = "Medical Facility was deleted.";
return(RedirectToAction("Index"));
}
//获取全院医生就诊/候诊人次列表
public List <MedicalService> GetDoctorMedicalService()
{
List <MedicalService> res = new List <MedicalService>();
Random rand = new Random();
for (int i = 0; i < 10; i++)
{
MedicalService temp = new MedicalService();
temp.HZnums = rand.Next(100, 500);
temp.JZnums = rand.Next(50, 100);
temp.DoctorID = i;
temp.DoctorName = depts[i];
res.Add(temp);
}
res.Sort();
return(res);
}
public ActionResult Edit(int id)
{
var service = new MedicalService();
var detail = service.GetMedicalById(id);
var model =
new MedicalEdit
{
MedicalId = detail.MedicalId,
Name = detail.Name,
Location = detail.Location,
PhoneNumber = detail.PhoneNumber,
Website = detail.Website,
FinancialAid = detail.FinancialAid,
Details = detail.Details
};
return(View(model));
}
public bool SaveEmergencyDetails(MedicalService aMedicalService)
{
Query = "INSERT INTO MedicalEmergency VALUES(@twentyFourService, @emergencyService, @ambulanceService, @seatCapacity, @emergencyPhoneNo, @emergencyPhoneNo2, @ambulancePhoneNo, @ambulancePhoneNo2, @medicalId)";
Command = new SqlCommand(Query, Connection);
Command.Parameters.AddWithValue("twentyFourService", aMedicalService.TwentyFourService);
Command.Parameters.AddWithValue("emergencyService", aMedicalService.EmergencyService);
Command.Parameters.AddWithValue("ambulanceService", aMedicalService.AmbulanceService);
Command.Parameters.AddWithValue("seatCapacity", aMedicalService.SeatCapacity);
Command.Parameters.AddWithValue("emergencyPhoneNo", aMedicalService.EmergencyPhoneNo);
Command.Parameters.AddWithValue("emergencyPhoneNo2", aMedicalService.EmergencyPhoneNo2);
Command.Parameters.AddWithValue("ambulancePhoneNo", aMedicalService.AmbulancePhoneNo);
Command.Parameters.AddWithValue("ambulancePhoneNo2", aMedicalService.AmbulancePhoneNo2);
Command.Parameters.AddWithValue("medicalId", aMedicalService.MedicalId);
Connection.Open();
bool rowAffected = Convert.ToBoolean(Command.ExecuteNonQuery());
Connection.Close();
return(rowAffected);
}
public ActionResult Create(MedicalCreate model)
{
if (!ModelState.IsValid)
{
return(View(model));
}
var service = new MedicalService();
if (service.CreateMedical(model))
{
TempData["SaveResult"] = "Medical Facility was created.";
return(RedirectToAction("Index"));
}
ModelState.AddModelError("", "Medical Facility could not be created");
return(View(model));
}
public bool EditEmergencyDetails(MedicalService aMedicalService)
{
Query = "UPDATE MedicalEmergency SET TwentyFourService = @24service, EmergencyService = @emergency, AmbulanceService = @ambulance, SeatCapacity = @seat, EmergencyPhoneNo = @emerPhoneNo, EmergencyPhoneNo2 = @emerPhoneNo2, AmbulancePhoneNo = @ambuPhoneNo, AmbulancePhoneNo2 = @ambuPhoneNo2 WHERE MedicalId =@medicalId";
Command = new SqlCommand(Query, Connection);
Command.Parameters.AddWithValue("24service", aMedicalService.TwentyFourService);
Command.Parameters.AddWithValue("emergency", aMedicalService.EmergencyService);
Command.Parameters.AddWithValue("ambulance", aMedicalService.AmbulanceService);
Command.Parameters.AddWithValue("seat", aMedicalService.SeatCapacity);
Command.Parameters.AddWithValue("emerPhoneNo", aMedicalService.EmergencyPhoneNo);
Command.Parameters.AddWithValue("emerPhoneNo2", aMedicalService.EmergencyPhoneNo2);
Command.Parameters.AddWithValue("ambuPhoneNo", aMedicalService.AmbulancePhoneNo);
Command.Parameters.AddWithValue("ambuPhoneNo2", aMedicalService.AmbulancePhoneNo2);
Command.Parameters.AddWithValue("medicalId", aMedicalService.MedicalId);
Connection.Open();
bool rowAffected = Convert.ToBoolean(Command.ExecuteNonQuery());
Connection.Close();
return(rowAffected);
}
public ActionResult Edit(int id, MedicalEdit model)
{
if (!ModelState.IsValid)
{
return(View(model));
}
if (model.MedicalId != id)
{
ModelState.AddModelError("", "Id Mismatch");
return(View(model));
}
var service = new MedicalService();
if (service.UpdateMedical(model))
{
TempData["SaveResult"] = "Medical Facility was updated.";
return(RedirectToAction("Index"));
}
ModelState.AddModelError("", "Medical Facility could not be updated.");
return(View(model));
}
public ActionResult Services(MedicalService aMedicalService)
{
int medicalId = GetMedicalData().MedicalId;
if (User.IsInRole("Medical"))
{
if (aMedicalService.HospitalService != null)
{
aMedicalService.HospitalService.MedicalId = medicalId;
bool rowAffected = aMedicalGateway.SaveHospitalService(aMedicalService.HospitalService.ServiceName, aMedicalService.HospitalService.MedicalId);
if (rowAffected)
{
ViewBag.Message = "Medical Service added successfully";
}
else
{
ViewBag.Error = "Medical Service not added. Try again.";
}
}
if (aMedicalService.DiagnosticService != null)
{
aMedicalService.DiagnosticService.MedicalId = medicalId;
bool rowAffected = aMedicalGateway.SaveDiagnosticService(aMedicalService.DiagnosticService.ServiceName, aMedicalService.DiagnosticService.MedicalId);
if (rowAffected)
{
ViewBag.Message = "Diagnostic Service added successfully";
}
else
{
ViewBag.Error = "Diagnostic Service not added. Try again.";
}
}
if (aMedicalService.OtherService == null && aMedicalService.HospitalService == null && aMedicalService.DiagnosticService == null && aMedicalService.MedicalFacility == null && aMedicalService.Consultant == null)
{
MedicalService medicalService = aMedicalGateway.GetEmergencyDetails(medicalId);
if (medicalService != null)
{
aMedicalService.MedicalId = medicalId;
if (aMedicalService.EmergencyService == null)
{
aMedicalService.EmergencyService = medicalService.EmergencyService;
}
if (aMedicalService.AmbulanceService == null)
{
aMedicalService.AmbulanceService = medicalService.AmbulanceService;
}
if (aMedicalService.TwentyFourService == null)
{
aMedicalService.TwentyFourService = medicalService.TwentyFourService;
}
if (aMedicalService.EmergencyPhoneNo == null)
{
aMedicalService.EmergencyPhoneNo = medicalService.EmergencyPhoneNo;
}
if (aMedicalService.EmergencyPhoneNo2 == null)
{
aMedicalService.EmergencyPhoneNo2 = medicalService.EmergencyPhoneNo2;
}
if (aMedicalService.AmbulancePhoneNo == null)
{
aMedicalService.AmbulancePhoneNo = medicalService.AmbulancePhoneNo;
}
if (aMedicalService.AmbulancePhoneNo2 == null)
{
aMedicalService.AmbulancePhoneNo2 = medicalService.AmbulancePhoneNo2;
}
bool rowAffected = aMedicalGateway.EditEmergencyDetails(aMedicalService);
if (rowAffected)
{
ViewBag.Message = "Emergency details updated successfully";
}
else
{
ViewBag.Error = "Emergency details updating falied. Try again.";
}
}
else
{
aMedicalService.MedicalId = medicalId;
if (aMedicalService.EmergencyPhoneNo == null)
{
aMedicalService.EmergencyPhoneNo = "";
}
if (aMedicalService.EmergencyPhoneNo2 == null)
{
aMedicalService.EmergencyPhoneNo2 = "";
}
if (aMedicalService.AmbulancePhoneNo == null)
{
aMedicalService.AmbulancePhoneNo = "";
}
if (aMedicalService.AmbulancePhoneNo2 == null)
{
aMedicalService.AmbulancePhoneNo2 = "";
}
bool rowAffected = aMedicalGateway.SaveEmergencyDetails(aMedicalService);
if (rowAffected)
{
ViewBag.Message = "Emergency details saved successfully";
}
else
{
ViewBag.Error = "Emergency details saving falied. Try again.";
}
}
}
}
ViewBag.GetHospitalServices = aMedicalGateway.GetHospitalServices(medicalId);
ViewBag.GetDiagnosticServices = aMedicalGateway.GetDiagnosticServices(medicalId);
ViewBag.GetOtherServices = aMedicalGateway.GetOtherServices(medicalId);
ViewBag.GetMedicalFacilities = aMedicalGateway.GetMedicalFacilities(medicalId);
ViewBag.GetMedicalConsultants = aMedicalGateway.GetMedicalConsultants(medicalId);
ViewBag.GetEmergencyDetails = aMedicalGateway.GetEmergencyDetails(medicalId);
List <DoctorsSpecialities> doctorsSpecialities = aDoctorManager.GetSpecialities();
ViewBag.GetSpecialities = doctorsSpecialities;
ViewBag.GetName = GetMedicalData().MedicalName;
return(View());
}
protected void AddNewMedicalServiceDataSource_Inserted(object sender, LinqDataSourceStatusEventArgs e)
{
insertedMedicalService = (MedicalService)e.Result;
}