public List <PatientInfo> DischargePatientWebMethod(int patientID)
{
DischargePatient dischargePatientObj = new DischargePatient();
dischargePatientObj.DischargeandDeallocateBed(patientID, _listOfBeds, listOfPatients);
return(listOfPatients);
}
public DataTable GetDischargeDetails(DischargePatient _dischargePatient)
{
DataTable data = new DataTable();
aMedicalGatway = new MedicalGatway();
data = aMedicalGatway.GetDischargeDetails(_dischargePatient);
return(data);
}
//public DataTable GetDischargeInfo()
//{
// DataTable data = new DataTable();
// aMedicalGatway = new MedicalGatway();
// data = aMedicalGatway.GetDischargeInfo();
// return data;
//}
public DataTable GetDischargeInfo(DischargePatient dischargePatient)
{
DataTable data = new DataTable();
aMedicalGatway = new MedicalGatway();
data = aMedicalGatway.GetDischargeInfo(dischargePatient);
return(data);
}
//public DataTable GetDischargeInfo()
//{
// Query = "SELECT * FROM tbl_MasterDischargeForm";
// Command = new SqlCommand(Query, Connection);
// Command.CommandType = CommandType.Text;
// Reader = Command.ExecuteReader();
// DataTable data = new DataTable();
// data.Load(Reader);
// return data;
//}
public DataTable GetDischargeDetails(DischargePatient _dischargePatient)
{
Query = "SELECT * FROM tbl_DischargeDrugDetials WHERE OPID='" + _dischargePatient.OPID + "'";
Command = new SqlCommand(Query, Connection);
Command.CommandType = CommandType.Text;
Reader = Command.ExecuteReader();
DataTable data = new DataTable();
data.Load(Reader);
return(data);
}
public DataTable GetDischargeInfo(DischargePatient dischargePatient)
{
DataTable dtDataTable = new DataTable();
Query = "SELECT * FROM ViewGetDischargeInfo WHERE OPID NOT IN (SELECT OPID FROM tbl_DischargeBill) AND OPID='" + dischargePatient.OPID + "'";
Command = new SqlCommand(Query, Connection);
Command.CommandType = CommandType.Text;
Reader = Command.ExecuteReader();
dtDataTable.Load(Reader);
return(dtDataTable);
}
public MessageModel DeleteDischargePatient(DischargePatient dischargePatient)
{
MessageModel model = new MessageModel();
int count = new MedicalGatway().DeleteDischargePatient(dischargePatient);
if (count > 0)
{
model.MessageBody = "Discharge patient deleted successfully. \n Thank you.";
model.MessageTitle = "Successfull";
}
return(model);
}
public MessageModel UpdateDischargePatient(DischargePatient dischargePatient)
{
MessageModel model = new MessageModel();
int count = new MedicalGatway().UpdateDischargePatient(dischargePatient);
if (count > 0)
{
model.MessageBody = "Patient is Discharge ";
model.MessageTitle = "Success";
}
return(model);
}
public void Given_PatientID_When_DischargeandDeallocateBed_Then_Patient_Is_Not_Available()
{
int patientID = 1;
List <BedData> bedListObj = new List <BedData>();
BedData bedData = new BedData();
bedListObj.Add(bedData);
List <PatientInfo> patientsListObj = new List <PatientInfo>();
PatientInfo newPatient = new PatientInfo();
patientsListObj.Add(newPatient);
DischargePatient dischargePatient = new DischargePatient();
dischargePatient.DischargeandDeallocateBed(patientID, bedListObj, patientsListObj);
}
public int DeleteDischargePatient(DischargePatient dischargePatient)
{
int rowAffect2 = 0;
Query = "DELETE tbl_MasterDischargeForm WHERE OPID='" + dischargePatient.OPID + "'";
Command = new SqlCommand(Query, Connection);
int rowAffect = Command.ExecuteNonQuery();
if (rowAffect > 0)
{
Query = "DELETE tbl_DischargeDrugDetials WHERE OPID='" + dischargePatient.OPID + "'";
Command = new SqlCommand(Query, Connection);
rowAffect2 = Command.ExecuteNonQuery();
}
return(rowAffect2);
}
private void searchLookUpGetDischargeInfo_EditValueChanged(object sender, EventArgs e)
{
//PatientByOPID(cmbPatient.Properties.View.GetFocusedRowCellValue("OPID").ToString());
//txtDiagonsisAdmisson.Focus();
DischargePatient _dischargePatient = new DischargePatient();
_dischargePatient.OPID = searchLookUpGetDischargeInfo.Properties.View.GetFocusedRowCellValue("OPID").ToString();
txtFahterHusbandName.Text = searchLookUpGetDischargeInfo.Properties.View.GetFocusedRowCellValue("FatherHusbandName").ToString();
txtRegNo.Text = searchLookUpGetDischargeInfo.Properties.View.GetFocusedRowCellValue("RegNo").ToString();
txtFahterHusbandName.Text = searchLookUpGetDischargeInfo.Properties.View.GetFocusedRowCellValue("FatherHusbandName").ToString();
txtGender.Text = searchLookUpGetDischargeInfo.Properties.View.GetFocusedRowCellValue("Gender").ToString();
txtAge.Text = searchLookUpGetDischargeInfo.Properties.View.GetFocusedRowCellValue("Age").ToString();
txtBloodGroup.Text = searchLookUpGetDischargeInfo.Properties.View.GetFocusedRowCellValue("BloodGroup").ToString();
txtConsult.Text = searchLookUpGetDischargeInfo.Properties.View.GetFocusedRowCellValue("Consult").ToString();
txtWeight.Text = searchLookUpGetDischargeInfo.Properties.View.GetFocusedRowCellValue("weight").ToString();
txtCabinBedNo.Text = searchLookUpGetDischargeInfo.Properties.View.GetFocusedRowCellValue("Cabin_BedNo").ToString();
txtContactNo.Text = searchLookUpGetDischargeInfo.Properties.View.GetFocusedRowCellValue("ContactNo").ToString();
txtDiagonsisAdmisson.Text = searchLookUpGetDischargeInfo.Properties.View.GetFocusedRowCellValue("DiagOnAdmission").ToString();
txtDiagOnDischarge.Text = searchLookUpGetDischargeInfo.Properties.View.GetFocusedRowCellValue("DiagOnDischarge").ToString();
txtAdmissionOnDate.Text = searchLookUpGetDischargeInfo.Properties.View.GetFocusedRowCellValue("AddmissionOn").ToString();
txtDischargeOnDate.Text = searchLookUpGetDischargeInfo.Properties.View.GetFocusedRowCellValue("DischargeOn").ToString();
aMedicalManager = new MedicalManager();
DataTable dataTable = new DataTable();
gridControl1.DataSource = null;
dataTable = aMedicalManager.GetDischargeDetails(_dischargePatient);
for (int i = 0; i < dataTable.Rows.Count; i++)
{
DataRow rows = tempDrug.NewRow();
tempDrug.Rows.Add(rows);
rows["DrugId"] = dataTable.Rows[i]["DrugId"];
rows["DrugName"] = dataTable.Rows[i]["DrugName"];
rows["Doose"] = dataTable.Rows[i]["Doose"];
rows["Description"] = dataTable.Rows[i]["Description"];
rows["Id"] = dataTable.Rows[i]["Id"];
}
gridControl1.DataSource = tempDrug;
btnSave.Enabled = false;
btnEdit.Enabled = true;
}
private void btnDelete_Click_1(object sender, EventArgs e)
{
DialogResult dr = MessageBox.Show("Are you sure to delete this row?", "Confirmation Message", MessageBoxButtons.YesNo);
if (dr == DialogResult.Yes)
{
DischargePatient _dischargePatient = new DischargePatient();
_dischargePatient.OPID = searchLookUpGetDischargeInfo.Properties.View.GetFocusedRowCellValue("OPID").ToString();
MessageModel aMessageModel = new MessageModel();
aMessageModel = aMedicalManager.DeleteDischargePatient(_dischargePatient);
if (aMessageModel.MessageTitle == "Successfull")
{
MessageBox.Show(aMessageModel.MessageBody, aMessageModel.MessageTitle, MessageBoxButtons.OK, MessageBoxIcon.Information);
Refresh();
}
}
}
static async Task AsyncMain()
{
var dispatcher = await SetupDispatcher();
var patientId = Guid.NewGuid().ToString();
var admitPatient = new AdmitPatient(patientId, "Tony Ferguson", 32, DateTime.UtcNow, 10);
await dispatcher.Dispatch(admitPatient);
var transferPatientOne = new TransferPatient(patientId, 76);
await dispatcher.Dispatch(transferPatientOne);
var transferPatientTwo = new TransferPatient(patientId, 34);
await dispatcher.Dispatch(transferPatientTwo);
var dischargePatient = new DischargePatient(patientId);
await dispatcher.Dispatch(dischargePatient);
Console.ReadLine();
}
public void Given_PatientID_When_DischargeandDeallocateBed_Then_Patient_List_Size_Will_Decreazed_By_1()
{
int patientID = 1;
List <BedData> listOfBeds = new List <BedData>();
BedData bedData = new BedData();
bedData.BedAvailability = false;
bedData.PatientID = patientID;
listOfBeds.Add(bedData);
List <PatientInfo> listOfPatient = new List <PatientInfo>();
PatientInfo newPatient = new PatientInfo();
newPatient.PatientID = patientID;
newPatient.BedID = 1;
listOfPatient.Add(newPatient);
DischargePatient dischargePatient = new DischargePatient();
dischargePatient.DischargeandDeallocateBed(patientID, listOfBeds, listOfPatient);
int expectedValue = 0;
int actualValue = listOfPatient.Count;
Assert.AreEqual(expectedValue, actualValue);
}
public async Task EndToEndTest()
{
var ct = new CancellationTokenSource().Token;
var eventStore = GetEventStore();
var dispatcher = SetupDispatcher(eventStore);
var connectionFactory = new ConnectionFactory("PatientManagement");
await connectionFactory.EnsureDatabaseExistsAsync(ct);
var projections = new List <IProjection>
{
new WardViewProjection(connectionFactory),
new PatientDemographicProjection(connectionFactory)
};
var projectionManager = new ProjectionManager.ProjectionManager(
eventStore,
connectionFactory,
projections);
await projectionManager.StartAsync(ct);
var patientId = Guid.NewGuid();
var admitPatient = new AdmitPatient(patientId, "Tony Ferguson", 32, DateTime.UtcNow, 10);
await dispatcher.Dispatch(admitPatient, ct);
await retryPolicy.ExecuteAsync(async token =>
{
using var session = connectionFactory.Connect();
var patient = await session.LoadAsync <Patient>(patientId.ToString(), token);
Assert.NotNull(patient);
Assert.Equal(patientId.ToString(), patient.Id);
Assert.Equal(admitPatient.PatientName, patient.PatientName);
Assert.Equal(admitPatient.AgeInYears, patient.AgeInYears);
Assert.Equal(admitPatient.WardNumber, patient.WardNumber);
}, ct);
var transferPatientOne = new TransferPatient(patientId, 76);
await dispatcher.Dispatch(transferPatientOne, ct);
await retryPolicy.ExecuteAsync(async token =>
{
using var session = connectionFactory.Connect();
var patient = await session.LoadAsync <Patient>(patientId.ToString(), token);
Assert.NotNull(patient);
Assert.Equal(transferPatientOne.WardNumber, patient.WardNumber);
}, ct);
var transferPatientTwo = new TransferPatient(patientId, 34);
await dispatcher.Dispatch(transferPatientTwo, ct);
await retryPolicy.ExecuteAsync(async token =>
{
using var session = connectionFactory.Connect();
var patient = await session.LoadAsync <Patient>(patientId.ToString(), token);
Assert.NotNull(patient);
Assert.Equal(transferPatientTwo.WardNumber, patient.WardNumber);
}, ct);
var dischargePatient = new DischargePatient(patientId);
await dispatcher.Dispatch(dischargePatient, ct);
await retryPolicy.ExecuteAsync(async token =>
{
using var session = connectionFactory.Connect();
var patient = await session.LoadAsync <Patient>(patientId.ToString(), token);
Assert.Null(patient);
}, ct);
}
// Update
public int UpdateDischargePatient(DischargePatient dischargePatient)
{
try
{
int count = 0;
Query = "UPDATE tbl_MasterDischargeForm SET RegNo=@RegNo,weight=@weight,AddmissionOn=@AddmissionOn," +
"DischargeOn=@DischargeOn,DiagOnAdmission=@DiagOnAdmission,DiagOnDischarge=@DiagOnDischarge," +
"StatusOnDischarge=@StatusOnDischarge,Cured=@Cured,Improved=@Improved,Dor=@Dor,Dorb=@Dorb," +
"NotImproved=@NotImproved,userId=@userId,Status=@Status,FatherHusbandName=@FatherHusbandName," +
"Gender=@Gender,Age=@Age,BloodGroup=@BloodGroup,Consult=@Consult,Cabin_BedNo=@Cabin_BedNo," +
"ContactNo=@ContactNo WHERE OPID='" + dischargePatient.OPID + "'";
Command = new SqlCommand(Query, Connection);
Command.CommandType = CommandType.Text;
Command.Parameters.AddWithValue(@"RegNo", dischargePatient.RegNo);
Command.Parameters.AddWithValue(@"weight", dischargePatient.weight);
Command.Parameters.AddWithValue(@"AddmissionOn", dischargePatient.AddmissionOn);
Command.Parameters.AddWithValue(@"DischargeOn", dischargePatient.DischargeOn);
Command.Parameters.AddWithValue(@"DiagOnAdmission", dischargePatient.DiagOnAdmission);
Command.Parameters.AddWithValue(@"DiagOnDischarge", dischargePatient.DiagOnDischarge);
Command.Parameters.AddWithValue(@"StatusOnDischarge", false);
Command.Parameters.AddWithValue(@"Cured", dischargePatient.Cured);
Command.Parameters.AddWithValue(@"Improved", dischargePatient.Improved);
Command.Parameters.AddWithValue(@"Dor", dischargePatient.Dor);
Command.Parameters.AddWithValue(@"Dorb", dischargePatient.Dorb);
Command.Parameters.AddWithValue(@"NotImproved", dischargePatient.NotImproved);
Command.Parameters.AddWithValue(@"userId", dischargePatient.userId ?? "");
Command.Parameters.AddWithValue(@"Status", "Discharge");
Command.Parameters.AddWithValue(@"FatherHusbandName", dischargePatient.FatherHusbandName ?? "");
Command.Parameters.AddWithValue(@"Gender", dischargePatient.Gender ?? "");
Command.Parameters.AddWithValue(@"Age", dischargePatient.Age ?? "");
Command.Parameters.AddWithValue(@"BloodGroup", dischargePatient.BloodGroup ?? "");
Command.Parameters.AddWithValue(@"Consult", dischargePatient.Consult ?? "");
Command.Parameters.AddWithValue(@"Cabin_BedNo", dischargePatient.Cabin_BedNo ?? "");
Command.Parameters.AddWithValue(@"ContactNo", dischargePatient.ContactNo ?? "");
count += Command.ExecuteNonQuery();
if (count > 0)
{
Query = "DELETE tbl_DischargeDrugDetials WHERE OPID='" + dischargePatient.OPID + "'";
Command = new SqlCommand(Query, Connection);
Command.CommandType = CommandType.Text;
count += Command.ExecuteNonQuery();
}
foreach (DataRow dischageDrugDetialse in dischargePatient.Tempdatatable.Rows)
{
Query = "INSERT INTO tbl_DischargeDrugDetials(OPID,DrugName,Doose,DrugId,Description)VALUES(@OPID,@DrugName,@Doose,@DrugId,@Description)";
Command = new SqlCommand(Query, Connection);
Command.CommandType = CommandType.Text;
Command.Parameters.AddWithValue(@"OPID", dischargePatient.OPID);
Command.Parameters.AddWithValue(@"DrugName", dischageDrugDetialse["DrugName"]);
Command.Parameters.AddWithValue(@"Doose", dischageDrugDetialse["Doose"]);
Command.Parameters.AddWithValue(@"DrugId", dischageDrugDetialse["DrugId"]);
Command.Parameters.AddWithValue(@"Description", dischageDrugDetialse["Description"]);
count += Command.ExecuteNonQuery();
}
return(count);
}
catch (Exception exception)
{
throw exception;
}
}
//Save
public int SaveDischargePatient(DischargePatient dischargePatient)
{
int count = 0;
Query = "INSERT INTO [tbl_MasterDischargeForm]" +
"([OPID],[RegNo],[weight],[AddmissionOn],[DischargeOn],[DiagOnAdmission],[DiagOnDischarge],[StatusOnDischarge],[Cured],[Improved],[Dor],[Dorb],[NotImproved],[userId],[Status],FatherHusbandName,Gender,Age,BloodGroup,Consult,Cabin_BedNo,ContactNo,DischargeTime,BreefHistory)" +
"VALUES(@OPID,@RegNo,@weight,@AddmissionOn,@DischargeOn,@DiagOnAdmission,@DiagOnDischarge, @StatusOnDischarge,"
+ "@Cured,@Improved,@Dor,@Dorb,@NotImproved,@userId, @Status,@FatherHusbandName,@Gender,@Age,@BloodGroup,@Consult,@Cabin_BedNo,@ContactNo,@DischargeTime,@BreefHistory)";
Command = new SqlCommand(Query, Connection);
Command.CommandType = CommandType.Text;
Command.Parameters.AddWithValue(@"OPID", dischargePatient.OPID);
Command.Parameters.AddWithValue(@"RegNo", dischargePatient.RegNo);
Command.Parameters.AddWithValue(@"weight", dischargePatient.weight);
Command.Parameters.AddWithValue(@"AddmissionOn", dischargePatient.AddmissionOn);
Command.Parameters.AddWithValue(@"DischargeOn", dischargePatient.DischargeOn);
Command.Parameters.AddWithValue(@"DiagOnAdmission", dischargePatient.DiagOnAdmission);
Command.Parameters.AddWithValue(@"DiagOnDischarge", dischargePatient.DiagOnDischarge);
Command.Parameters.AddWithValue(@"StatusOnDischarge", false);
Command.Parameters.AddWithValue(@"Cured", dischargePatient.Cured);
Command.Parameters.AddWithValue(@"Improved", dischargePatient.Improved);
Command.Parameters.AddWithValue(@"Dor", dischargePatient.Dor);
Command.Parameters.AddWithValue(@"Dorb", dischargePatient.Dorb);
Command.Parameters.AddWithValue(@"NotImproved", dischargePatient.NotImproved);
Command.Parameters.AddWithValue(@"userId", dischargePatient.userId ?? "");
Command.Parameters.AddWithValue(@"Status", "Discharge");
Command.Parameters.AddWithValue(@"FatherHusbandName", dischargePatient.FatherHusbandName ?? "");
Command.Parameters.AddWithValue(@"Gender", dischargePatient.Gender ?? "");
Command.Parameters.AddWithValue(@"Age", dischargePatient.Age ?? "");
Command.Parameters.AddWithValue(@"BloodGroup", dischargePatient.BloodGroup ?? "");
Command.Parameters.AddWithValue(@"Consult", dischargePatient.Consult ?? "");
Command.Parameters.AddWithValue(@"Cabin_BedNo", dischargePatient.Cabin_BedNo ?? "");
Command.Parameters.AddWithValue(@"ContactNo", dischargePatient.ContactNo ?? "");
Command.Parameters.AddWithValue(@"DischargeTime", dischargePatient.DischargeTime);
Command.Parameters.AddWithValue(@"BreefHistory", dischargePatient.BreffHistory);
count += Command.ExecuteNonQuery();
//////////// In Drug Detials////////////////////////////
foreach (DataRow dr in dischargePatient.Tempdatatable.Rows)
{
Query = "INSERT INTO tbl_DischargeDrugDetials (OPID,DrugName,Doose,DrugId,Description)"
+ "VALUES(@OPID,@DrugName,@Doose,@DrugId,@Description)";
Command = new SqlCommand(Query, Connection);
Command.CommandType = CommandType.Text;
Command.Parameters.AddWithValue(@"OPID", dischargePatient.OPID);
Command.Parameters.AddWithValue(@"DrugName", dr["DrugName"]);
Command.Parameters.AddWithValue(@"Doose", dr["Doose"]);
Command.Parameters.AddWithValue(@"DrugId", dr["DrugId"]);
Command.Parameters.AddWithValue(@"Description", dr["Description"]);
count += Command.ExecuteNonQuery();
}
int row = 0;
foreach (Advice advice in dischargePatient.ListofAdvice)
{
Query = "insert into tbl_AdviceRecord (AdviceName,PatientId) values(@AdviceName,@PatientId)";
Command = new SqlCommand(Query, Connection);
Command.Parameters.AddWithValue("@AdviceName", advice.AdviceName);
Command.Parameters.AddWithValue("@PatientId", dischargePatient.OPID);
Command.CommandText = Query;
row += Command.ExecuteNonQuery();
}
return(count);
}
