private void btnSave_Click(object sender, EventArgs e)
{
Patient aPatient = new Patient();
IPDBedHistory aBedHistory = new IPDBedHistory();
aBedHistory.BedorCabin = gridView3.GetRowCellValue(0, "BedCabinID").ToString();;
aBedHistory.fromDate = Convert.ToDateTime(txtAdmissionDate.Text);
aBedHistory.Todate = DateTime.Today;
aBedHistory.Rate = Convert.ToDecimal(txtRate.Text);
aBedHistory.TransferDate = Convert.ToDateTime(txtAdmissionDate.Text);
aBedHistory.DayQty = (DateTime.Today - Convert.ToDateTime(txtAdmissionDate.Text)).Days;
aBedHistory.PatientID = gridView3.GetRowCellValue(0, "OPID").ToString();
aBedHistory.UserId = "";
if (chkCabin.Checked == true)
{
aPatient.SelectedBed = txtseletedBed.SelectedValue.ToString();
aPatient.WardOrCabin = "";
}
else if (chkCabin.Checked == false)
{
aPatient.SelectedBed = "";
aPatient.WardOrCabin = cmbwardCabin.SelectedValue.ToString();
}
aPatient.OPID = gridView1.GetFocusedRowCellValue("OPID").ToString();
MessageModel message = new BedHistoryManager().SaveBedShipment(aBedHistory, aPatient);
MessageBox.Show(message.MessageBody, message.MessageTitle, MessageBoxButtons.OK, MessageBoxIcon.Information);
specialButton4_Click(sender, e);
WardOrCabin();
GetIpInfo();
ChkFreeOccupied();
GetBadorCabin();
}
public MessageModel SaveBedShipment(IPDBedHistory aBedHistory,Patient patient)
{
aBedHistoryGateWay = new BedHistoryGateWay();
MessageModel messageModel = new MessageModel();
if (aBedHistoryGateWay.SaveIPDBedHistory(aBedHistory) > 0)
{
if (aBedHistoryGateWay.UpdatePatientBedIPD(patient) > 0)
{
messageModel.MessageTitle = "Successfull";
messageModel.MessageBody = "Indoor Patient Shipment information save successfully!";
}
}
return messageModel;
}
public int SaveIPDBedHistory(IPDBedHistory BedHistory)
{
Query = "insert into tbl_BedCabinShipment(BedorCabin,fromDate,Todate,PatientID,Rate,DayQty,UserId,TransferDate) values(@BedorCabin,@fromDate,@Todate,@PatientID,@Rate,@DayQty,@UserId,@TransferDate) ";
Command = new SqlCommand(Query, Connection);
Command.CommandType = CommandType.Text;
Command.Parameters.AddWithValue("@BedorCabin", BedHistory.BedorCabin);
Command.Parameters.AddWithValue("@fromDate", BedHistory.fromDate);
Command.Parameters.AddWithValue("@Todate", BedHistory.Todate);
Command.Parameters.AddWithValue("@PatientID", BedHistory.PatientID);
Command.Parameters.AddWithValue("@Rate", BedHistory.Rate);
Command.Parameters.AddWithValue("@DayQty", BedHistory.DayQty);
Command.Parameters.AddWithValue("@UserId", BedHistory.UserId);
Command.Parameters.AddWithValue("@TransferDate", BedHistory.TransferDate);
int count = Command.ExecuteNonQuery();
return(count);
}
private void btnSave2_Click(object sender, EventArgs e)
{
try
{
Patient aPatient = new Patient();
IPDBedHistory aBedHistory = new IPDBedHistory();
aBedHistory.BedorCabin = gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "BedCabinID").ToString();;
aBedHistory.fromDate = Convert.ToDateTime(txtAdmissionDate.Text);
aBedHistory.Todate = TransferDate.Value;
aBedHistory.Rate = Convert.ToDecimal(txtRate.Text);
aBedHistory.TransferDate = Convert.ToDateTime(txtAdmissionDate.Text);
aBedHistory.DayQty = Convert.ToDecimal(txtdays.Text);
aBedHistory.PatientID = gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "OPID").ToString();
DateTime dt = dateTransferTime.Value;
TimeSpan st = new TimeSpan(dt.Hour, dt.Minute, dt.Second);
aBedHistory.TransferTime = st;
aBedHistory.UserId = "";
if (chkCabin.Checked == true)
{
aPatient.SelectedBed = txtseletedBed.SelectedValue.ToString();
aPatient.WardOrCabin = "";
}
else if (chkCabin.Checked == false)
{
aPatient.SelectedBed = "";
aPatient.WardOrCabin = cmbwardCabin.SelectedValue.ToString();
}
aPatient.OPID = gridView1.GetFocusedRowCellValue("OPID").ToString();
MessageModel message = new BedHistoryManager().SaveBedShipment(aBedHistory, aPatient);
MessageBox.Show(message.MessageBody, message.MessageTitle, MessageBoxButtons.OK, MessageBoxIcon.Information);
specialButton4_Click(sender, e);
WardOrCabin();
GetIpInfo();
ChkFreeOccupied();
GetBadorCabin();
}
catch (Exception)
{
//throw;
}
}
