protected void btnSearch_Click(object sender, EventArgs e)
{
EntityPatientDetails objEntity = new EntityPatientDetails();
BusinessViewPatientHistory objBus = new BusinessViewPatientHistory();
DataTable dt = new DataTable();
if (ddlPatientId.SelectedIndex == 0)//PatientId not selected in DropDownList
{
objEntity.FirstName = ddlFirstName.SelectedItem.Text;
objEntity.LastName = ddlLastName.SelectedItem.Text;
dt.Clear();
dt = objBus.businessFillPatientHistoryUsingPatientName(objEntity);
}
else if (ddlFirstName.SelectedIndex == 0 && ddlLastName.SelectedIndex == 0)//Firsname and LastName not selected in DropDownList
{
objEntity.PatientId = Convert.ToInt32(ddlPatientId.SelectedItem.Text);
dt.Clear();
dt = objBus.businessFillPatientHistoryUsingPatientId(objEntity);
}
else
{
//Error massage: Eiter enter Patient Id or First Name and Lastname of the Patient whoes history you want to see.
}
gvViewPatientHistory.DataSource = dt;
gvViewPatientHistory.DataBind();
}
public DataTable businessFillPatientHistoryUsingPatientId(EntityPatientDetails objEntity)
{
SqlParameter[] objPara = new SqlParameter[1];
objPara[0] = new SqlParameter("@PatientId", SqlDbType.Int);
objPara[0].Value = objEntity.PatientId;
DataTable objTable = new DataTable();
objTable.Clear();
objTable = objDataViewPatient.DataFillPatientHistoryUsingPatientId(objPara).Tables["PatientHistoryUsingId"];
return(objTable);
}
public DataTable businessFillPatientHistoryUsingPatientName(EntityPatientDetails objEntity)
{
SqlParameter[] objPara = new SqlParameter[2];
objPara[0] = new SqlParameter("@FirstName", SqlDbType.VarChar, 20);
objPara[0].Value = objEntity.FirstName;
objPara[1] = new SqlParameter("@LastName", SqlDbType.VarChar, 20);
objPara[1].Value = objEntity.LastName;
DataTable objTable = new DataTable();
objTable.Clear();
objTable = objDataViewPatient.DataFillPatientHistoryUsingPatientName(objPara).Tables["PatientHistoryUsingName"];
return(objTable);
}
public int BussinessUpdateEnrollPatientDetails(EntityPatientDetails objEn)
{
int result;
SqlParameter[] objPara = new SqlParameter[9];
objPara[0] = new SqlParameter("@FirstName", SqlDbType.VarChar, 20);
objPara[0].Value = objEn.FirstName;
objPara[1] = new SqlParameter("@LastName", SqlDbType.VarChar, 20);
objPara[1].Value = objEn.LastName;
objPara[2] = new SqlParameter("@DateOfBirth", SqlDbType.Date);
objPara[2].Value = objEn.DateOfBirth;
//Age Skipped:Calculated in Database as derived attribute
objPara[3] = new SqlParameter("@Sex", SqlDbType.VarChar, 1);
objPara[3].Value = objEn.Sex;
objPara[4] = new SqlParameter("@BloodType", SqlDbType.VarChar, 3);
objPara[4].Value = objEn.BloodType;
objPara[5] = new SqlParameter("@PhoneNumber", SqlDbType.Int);
objPara[5].Value = objEn.PhoneNumber;
objPara[6] = new SqlParameter("@Email", SqlDbType.VarChar, 20);
objPara[6].Value = objEn.Email;
objPara[7] = new SqlParameter("@StateId", SqlDbType.VarChar, 2);
objPara[7].Value = objEn.StateId;
objPara[8] = new SqlParameter("@PlanId", SqlDbType.VarChar, 4);
objPara[8].Value = objEn.PlanId;
result = objDataEntrollPatient.DataUpdateEnrollPatientDetails(objPara);
return(result);
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
EntityPatientDetails objEn = new EntityPatientDetails();
objEn.FirstName = tbFirstName.Text;
objEn.LastName = tbLastName.Text;
objEn.DateOfBirth = DateTime.ParseExact(tbDOB.Text, "dd-MM-yy", System.Globalization.CultureInfo.InvariantCulture);
//objEn.Age
objEn.Sex = rblSex.SelectedItem.Text;
if (ddlBloodType.SelectedItem.Value == "-1")
{
//Error Massage
}
else
{
objEn.BloodType = ddlBloodType.SelectedItem.Text;
}
if (ddlState.SelectedItem.Value == "-1")
{
//Error Massage
}
else
{
objEn.StateId = ddlState.SelectedItem.Value;
}
if (ddlPlan.SelectedItem.Value == "-1")
{
//Error Massage
}
else
{
objEn.PlanId = ddlPlan.SelectedItem.Value;
}
objEn.PhoneNumber = Convert.ToInt32(tbPhoneNumber.Text);
objEn.Email = tbEmail.Text;
BusinessEnrollPatient bus = new BusinessEnrollPatient();
int result;
result = bus.BussinessUpdateEnrollPatientDetails(objEn);
if (result == 1)
{
lblMassange.Text = "Data Insertion Successfull" + result;
}
else
{
lblMassange.Text = "ERROR";
}
//Response.Write("Selected Index: " + ddlState.SelectedIndex+"<br/>");
//Response.Write("Selected Text: " + ddlState.SelectedItem.Text + "<br/>");
//Response.Write("Selected Value: " + ddlState.SelectedValue + "<br/>");
}
