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(); } }