public DataTable GetDischargeDetails(DischargeRequestNICU _dischargePatient)
{
DataTable data = new DataTable();
aMedicalGatway = new NICUDischargeReqGateWay();
data = aMedicalGatway.GetDischargeDetails(_dischargePatient);
return(data);
}
public DataTable GetDischargeInfo(DischargeRequestNICU dischargePatient)
{
DataTable dtDataTable = new DataTable();
Query = "SELECT * FROM ViewGetDischargeInfoNICU WHERE RegNo NOT IN (SELECT OPID FROM tbl_DischargeBillNICU) AND RegNo='" + dischargePatient.OPID + "'";
Command = new SqlCommand(Query, Connection);
Command.CommandType = CommandType.Text;
Reader = Command.ExecuteReader();
dtDataTable.Load(Reader);
return(dtDataTable);
}
public DataTable GetDischargeDetails(DischargeRequestNICU _dischargePatient)
{
Query = "SELECT * FROM tbl_DischargeDrugDetialsNICU 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 MessageModel UpdateNICUDischargePatient(DischargeRequestNICU dischargePatient)
{
MessageModel model = new MessageModel();
int count = new NICUDischargeReqGateWay().UpdateNICUDischargePatient(dischargePatient);
if (count > 0)
{
model.MessageBody = "Patient is Discharge ";
model.MessageTitle = "Success";
}
return(model);
}
public MessageModel DeleteNICUDischargePatient(DischargeRequestNICU dischargePatient)
{
MessageModel model = new MessageModel();
int count = new NICUDischargeReqGateWay().DeleteNICUDischargePatient(dischargePatient);
if (count > 0)
{
model.MessageBody = "NICU Discharge patient deleted successfully. \n Thank you.";
model.MessageTitle = "Successfull";
}
return(model);
}
public int DeleteNICUDischargePatient(DischargeRequestNICU dischargePatient)
{
int rowAffect2 = 0;
Query = "DELETE tbl_MasterDischargeFormNICU WHERE OPID='" + dischargePatient.OPID + "'";
Command = new SqlCommand(Query, Connection);
int rowAffect = Command.ExecuteNonQuery();
if (rowAffect > 0)
{
Query = "DELETE tbl_DischargeDrugDetialsNICU 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();
DischargeRequestNICU _dischargePatient = new DischargeRequestNICU();
_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 NICUDischargeReqManager();
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)
{
DischargeRequestNICU _dischargePatient = new DischargeRequestNICU();
_dischargePatient.OPID = searchLookUpGetDischargeInfo.Properties.View.GetFocusedRowCellValue("OPID").ToString();
MessageModel aMessageModel = new MessageModel();
aMessageModel = aMedicalManager.DeleteNICUDischargePatient(_dischargePatient);
if (aMessageModel.MessageTitle == "Successfull")
{
MessageBox.Show(aMessageModel.MessageBody, aMessageModel.MessageTitle, MessageBoxButtons.OK, MessageBoxIcon.Information);
Refresh();
}
}
}
public int SaveNICUDischargePatient(DischargeRequestNICU dischargePatient)
{
int count = 0;
Query = "INSERT INTO [tbl_MasterDischargeFormNICU]" +
"([OPID],[RegNo],[weight],[AddmissionOn],[DischargeOn],[DiagOnAdmission],[DiagOnDischarge],[StatusOnDischarge],[Cured],[Improved],[Dor],[Dorb],[NotImproved],[userId],[Status],FatherHusbandName,Gender,Age,BloodGroup,Consult,Cabin_BedNo,ContactNo,DischargeTime)" +
"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)";
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);
count += Command.ExecuteNonQuery();
//////////// In Drug Detials////////////////////////////
foreach (DataRow dr in dischargePatient.Tempdatatable.Rows)
{
Query = "INSERT INTO tbl_DischargeDrugDetialsNICU (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);
}
public int UpdateNICUDischargePatient(DischargeRequestNICU dischargePatient)
{
try
{
int count = 0;
Query = "UPDATE tbl_MasterDischargeFormNICU 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_DischargeDrugDetialsNICU 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_DischargeDrugDetialsNICU(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;
}
}
