private void SaveData()
{
string sUserName = Session["User"].ToString();
oDAL = new PatientAppointmentDAL();
oClass = new PatientAppointmentModel();
oClass.PatientNo = PatientNo.Value;
oClass.CaseNo = "";
oClass.AppointmentDate = Convert.ToDateTime(AppointmentDate.Value);
oClass.PhysicianID = Convert.ToInt16(ddlPhysician.SelectedValue);
oClass.HospitalID = Convert.ToInt16(ddlHospital.SelectedValue);
oClass.StatusID = 3;
oClass.Remarks = txtRemarks.InnerText;
string id = AppointmentID.Value;
if (id == "")
{
oDAL.InsertData(sUserName, oClass);
//lblMsg.Text = "New Record has been saved";
}
else
{
oClass.ID = Convert.ToInt16(id);
oDAL.UpdateData(sUserName, oClass);
// lblMsg.Text = "Record has been updated";
}
}
private void LoadAppointment(int appointmentID)
{
PatientAppointmentDAL appointmentDAL = new PatientAppointmentDAL();
PatientAppointmentModel appointmentModel = new PatientAppointmentModel();
appointmentModel.ID = appointmentID;
oDs = new DataSet();
oDs = appointmentDAL.SelectByID(appointmentModel);
// ddlHospitalName.SelectedValue = oDs.Tables[0].Rows[0]["FacilityID"].ToString();
ddlPhysician.SelectedValue = oDs.Tables[0].Rows[0]["PhysicianID"].ToString();
LoadPatient(oDs.Tables[0].Rows[0]["PatientNo"].ToString());
}
protected void Ok_ServerClick(object sender, EventArgs e)
{
string UserName = Session["User"].ToString();
int ID = Convert.ToInt32(HiddenFieldItem.Value);
oDAL = new PatientAppointmentDAL();
oClass = new PatientAppointmentModel();
oDs = new DataSet();
oClass.IsDeleted = true;
oClass.ReasonDelete = itemname.InnerText;
string lbl = lblSelectedItem.Text;
oClass.ID = ID;
oDAL.DeleteData(UserName, oClass);
PopulateGrid();
}
private void PopulateData(int id)
{
oDAL = new PatientAppointmentDAL();
oClass = new PatientAppointmentModel();
oDs = new DataSet();
oClass.ID = id;
oDs = oDAL.SelectByID(oClass);
AppointmentID.Value = oDs.Tables[0].Rows[0][0].ToString();
// CaseNo.Value = oDs.Tables[0].Rows[0][1].ToString();
AppointmentDate.Value = oDs.Tables[0].Rows[0][2].ToString();
PatientNo.Value = oDs.Tables[0].Rows[0]["PatientNo"].ToString();
PatientName.Value = oDs.Tables[0].Rows[0]["PatientName"].ToString();
DOB.Value = Convert.ToDateTime(oDs.Tables[0].Rows[0]["DOB"]).ToShortDateString();
ddlPhysician.SelectedValue = oDs.Tables[0].Rows[0]["PhysicianID"].ToString();
ddlHospital.SelectedValue = oDs.Tables[0].Rows[0]["FacilityID"].ToString();
// ddlStatus.SelectedValue = oDs.Tables[0].Rows[0]["StatusID"].ToString();
txtRemarks.Value = oDs.Tables[0].Rows[0][6].ToString();
}
private void PopulateGrid()
{
oDAL = new PatientAppointmentDAL();
oDs = new DataSet();
if (searchKeyword.Value != "")
{
// oDs = oDAL.SeachData(searchKeyword.Value);
}
else
{
oDs = oDAL.SelectAll();
}
if (oDs != null)
{
gvList.DataSource = oDs.Tables[0];
gvList.DataBind();
}
}
