public DataTable GetAllBeds(string ward)
{
aIpdGateway = new IpdGateway();
DataTable dt = aIpdGateway.GetAllBeds(ward);
return(dt);
}
private void simpleButton2_Click(object sender, EventArgs e)
{
ReportModel model = new ReportModel();
model.Parameters = new List <ReportParameter>
{
new ReportParameter("Company", model.Company.ToUpper()),
new ReportParameter("Address", model.Address),
};
var opid = gridViewDischarge.GetFocusedRowCellValue("OPID").ToString();
var DisChargeSummery = new IpdGateway().DisChargeSummery(opid);
var ConsultSrviceBill = new IpdGateway().DisChargeSummery_ConsultanName(opid);
var DisChargeSummery_MedicineTakeInHopital = new IpdGateway().DisChargeSummery_MedicineTakeInHopital(opid);
var DisChargeSummery_Pathology = new IpdGateway().DisChargeSummery_Pathology(opid);
var DisChargeSummery_Treatment = new IpdGateway().DisChargeSummery_Treatment(opid);
var DisChargeSummeryAdviceList = new IpdGateway().DataSetAdvice(opid);
model.MultiReportDataSource = new List <ReportDataSource>()
{
new ReportDataSource("DisChargeSummery", DisChargeSummery),
new ReportDataSource("ConsultSrviceBill", ConsultSrviceBill),
new ReportDataSource("DisChargeSummery_MedicineTakeInHopital", DisChargeSummery_MedicineTakeInHopital),
new ReportDataSource("DisChargeSummery_Pathology", DisChargeSummery_Pathology),
new ReportDataSource("DisChargeSummery_Treatment", DisChargeSummery_Treatment),
new ReportDataSource("DataSetAdvice", DisChargeSummeryAdviceList),
};
model.ReportPath = "GHospital_Care.Report.rdlcDischargeSummery.rdlc";
model.Show(model, this, true);
}
public DataTable GetAllBedsNICU()
{
aIpdGateway = new IpdGateway();
DataTable dt = aIpdGateway.GetAllBedNICU();
return(dt);
}
public MessageModel SaveCosultBilling(List <Patient> patient, Service service)
{
//Service service = new Service() { OPID = patient[0].OPID };
//int IsExist = new ServiceManager().UpdateService("ConsultService", service);
//int saveCount = new IpdGateway().SaveCosultBilling(patient);
//MessageModel messageModel = new MessageModel();
//if (saveCount > 0)
//{
// messageModel.MessageTitle = "Successfull";
// messageModel.MessageBody = "Indoor Patient Consult Billing information saved successfully!";
//}
//return messageModel;
int IsExist = new ServiceManager().UpdateService("ConsultService", service);
int saveCount = new IpdGateway().SaveCosultBilling(patient);
MessageModel messageModel = new MessageModel();
if (saveCount > 0)
{
messageModel.MessageTitle = "Successfull";
messageModel.MessageBody = "Indoor Patient Consult Billing information saved successfully!";
}
return(messageModel);
}
public Patient GetPatientInformationBySl(string selectId)
{
DataTable table = new IpdGateway().GetIndoorPatientInformationBySl(selectId);
Patient patient = new Patient();
if (table.Rows.Count > 0)
{
patient.PatientName = table.Rows[0]["PatientName"].ToString();
patient.Address = table.Rows[0]["Address"].ToString();
patient.Age = table.Rows[0]["Age"].ToString();
patient.BloodGroup = table.Rows[0]["BloodGroup"].ToString();
string docId = table.Rows[0]["Doctor"].ToString();
Doctor doctor = new MedicalManager().GetAllDoctorbyId(docId);
patient.Doctor = doctor.DoctorName;
patient.Gender = table.Rows[0]["Gender"].ToString();
patient.Mobile = table.Rows[0]["Mobile"].ToString();
patient.Nationality = table.Rows[0]["Nationality"].ToString();
patient.Phone = table.Rows[0]["Phone"].ToString();
patient.FatherName = table.Rows[0]["FatherName"].ToString();
patient.MotherName = table.Rows[0]["MotherName"].ToString();
patient.Gender = table.Rows[0]["Gender"].ToString();
patient.Relation = table.Rows[0]["Relation"].ToString();
patient.Gurdian = table.Rows[0]["Gurdian"].ToString();
patient.SelectedBed = table.Rows[0]["BedName"].ToString();
patient.InputDate = Convert.ToDateTime(table.Rows[0]["InputDate"]).Date;
patient.RegNo = table.Rows[0]["RegNo"].ToString();
patient.Weight = table.Rows[0]["Weight"].ToString();
patient.SelectedBed = table.Rows[0]["BedName"].ToString();
patient.OPID = selectId;
}
return(patient);
}
public MessageModel UpdateAdmissionPatient(Patient patient, DAL.Model.OutdoorPatient aOutdoorPatient)
{
aIpdGateway = new IpdGateway();
MessageModel aMessageModel = new MessageModel();
int saveCount = 0;
OutdoorPatientGatway aOutdoorPatientGatway = new OutdoorPatientGatway();
DataTable data = new DataTable();
data = aOutdoorPatientGatway.IsExist(aOutdoorPatient);
if (data.Rows.Count > 0)
{
saveCount = aIpdGateway.UpdateAdmissionPatient(patient);
aMessageModel.MessageTitle = "Successfull";
aMessageModel.MessageBody = "Indoor patient information updated successfully!";
return(aMessageModel);
}
else
{
saveCount = aIpdGateway.UpdateAdmissionPatient(patient);
saveCount = new OutdoorPatientGatway().UpdateOutdoorPatient(aOutdoorPatient);
aMessageModel.MessageTitle = "Successfull";
aMessageModel.MessageBody = "Indoor patient information updated successfully!";
}
return(aMessageModel);
}
private void repositoryItemHyperLinkEdit3_Click(object sender, EventArgs e)
{
var uniqkey = gridViewServiceBill.GetFocusedRowCellValue("Id");
var opid = cmbPid.Text;
int deleterow = new IpdGateway().DeleteServiceByCategory("PService", opid, uniqkey.ToString());
gridViewServiceBill.DeleteRow(gridViewServiceBill.GetFocusedDataSourceRowIndex());
}
public MessageModel DeleteAdmitedPatient(Patient aPatient)
{
aIpdGateway = new IpdGateway();
MessageModel messageModel = new MessageModel();
if (aIpdGateway.DeleteAdmitedPatient(aPatient) > 0)
{
messageModel.MessageTitle = "Successfull";
messageModel.MessageBody = "Indoor patient information Deleted successfully!";
}
return(messageModel);
}
public MessageModel SaveIpdPatient(Patient patient, Service service, DAL.Model.OutdoorPatient aOutdoorPatient)
{
int saveCount = 0;
MessageModel aMessageModel = new MessageModel();
string message = Ischecked(patient);
if (message != "Checked")
{
aMessageModel.MessageTitle = "Warning";
aMessageModel.MessageBody = message;
return(aMessageModel);
}
OutdoorPatientGatway aOutdoorPatientGatway = new OutdoorPatientGatway();
DataTable data = new DataTable();
data = aOutdoorPatientGatway.IsExist(aOutdoorPatient);
if (data.Rows.Count > 0)
{
saveCount = new IpdGateway().SaveAdmissionPatient(patient);
saveCount = new IpdGateway().SavePatientServiceIPD(service);
if (saveCount > 0)
{
aMessageModel.MessageTitle = "Successful";
aMessageModel.MessageBody = "Indoor patient information saved successfully!";
}
return(aMessageModel);
}
else
{
saveCount = new IpdGateway().SaveAdmissionPatient(patient);
saveCount = new IpdGateway().SavePatientServiceIPD(service);
saveCount = new OutdoorPatientGatway().SaveOutdoorPatient(aOutdoorPatient);
if (saveCount > 0)
{
aMessageModel.MessageTitle = "Successful";
aMessageModel.MessageBody = "Indoor patient information saved successfully!";
}
return(aMessageModel);
}
}
public List <OT_Consump> GetOtServiceConsumListByPatientId(Service paitentId)
{
try
{
DataTable list = new IpdGateway().GetOtServiceConsumListByPatientId(paitentId);
foreach (DataRow dataRow in list.Rows)
{
ConsumeList.Add(new OT_Consump {
batchId = dataRow["batchId"].ToString(), ProductId = dataRow["ProductId"].ToString(), ProductName = dataRow["ProductName"].ToString(), Qty = Convert.ToInt16(dataRow["Qty"]), Rate = Convert.ToDecimal(dataRow["Rate"]), IssueDate = Convert.ToDateTime(dataRow["IssueDate"]), VoucherNo = Convert.ToInt64(dataRow["voucherNo"])
});
}
ConsumeList.Add(new OT_Consump());
return(ConsumeList);
}
catch (Exception)
{
return(null);
}
}
public DataTable OT_StockMedicine(Service paitentId)
{
DataTable dt = new IpdGateway().GetOtServiceConsumList(paitentId);
return(dt);
}