protected void btnSave_Click(object sender, EventArgs e)
{
try
{
string SP = "";
SqlParameter[] param = null;
param = new SqlParameter[25];
SP = "usp_insert_PatientDetails";
param[0] = new SqlParameter("@FirstName", txt_fname.Text.ToLower());
param[1] = new SqlParameter("@LastName", txt_lname.Text.ToLower());
param[2] = new SqlParameter("@MiddleName", txt_mname.Text.ToLower());
param[3] = new SqlParameter("@Sex", ddl_gender.SelectedItem.Value);
param[4] = new SqlParameter("@Address", txt_add.Text.Trim().ToLower());
param[5] = new SqlParameter("@City", txt_city.Text.Trim());
param[6] = new SqlParameter("@State", ddState.SelectedItem.Value);
param[7] = new SqlParameter("@Zip", txt_zip.Text.Trim());
param[8] = new SqlParameter("@RaceEthnicity", txtRaceEthnicity.Text.Trim());
param[9] = new SqlParameter("@Language", txtLanguage.Text.Trim());
param[10] = new SqlParameter("@HomePhno", txt_home_ph.Text.Trim());
param[11] = new SqlParameter("@MobilePhno", txt_mobile.Text.Trim());
param[12] = new SqlParameter("@eMail", txtEmail.Text.Trim());
param[13] = new SqlParameter("@SSN", txt_SSN.Text.Trim());
param[14] = new SqlParameter("@MaritalStatus", ddlMaratialStatus.SelectedItem.Value);
param[15] = new SqlParameter("@PatientEmployment", txtPatientEmployment.Text.Trim());
param[16] = new SqlParameter("@PEAddress", txt_zip.Text.Trim());
param[17] = new SqlParameter("@PECity", txtPatientEmploymentCity.Text.Trim());
param[18] = new SqlParameter("@PEState", ddlPatientEmploymentState.SelectedItem.Value);
param[19] = new SqlParameter("@PEZip", txtPatientEmploymentZip.Text.Trim());
param[20] = new SqlParameter("@RelationToPatient", txtRelation.Text.Trim());
param[21] = new SqlParameter("@PEPhno", txtRelationPhno.Text.Trim());
param[22] = new SqlParameter("@NextOfKinEmergency", txtNextOfKinEmergency.Text.Trim());
param[23] = new SqlParameter("@Description", txtDescription.Text.Trim());
if (string.IsNullOrWhiteSpace(txt_DOB.Text))
{
param[24] = new SqlParameter("@DOB", DBNull.Value);
}
else
{
param[24] = new SqlParameter("@DOB", Convert.ToDateTime(txt_DOB.Text));
}
int val = db.executeSP(SP, param);
if (val > 0)
{
lblmess.Text = "Patient Details Recorded Sucessfully.";
lblmess.ForeColor = System.Drawing.Color.Green;
lblMessage.Attributes.Add("style", "color:green");
upMessage.Update();
DataSet locds = new DataSet();
}
}
catch (Exception ex)
{
db.LogError(ex);
}
finally
{
ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), Guid.NewGuid().ToString(), "openPopup('mymodelmessage')", true);
ClearControls();
}
}
