protected void Button8_Click(object sender, EventArgs e)
{
DataSet ds = new DataSet();
ds = objb.getdiagnosis_byipdcode_ipd(Session["prn"].ToString());
IPDDataContext rt1 = new IPDDataContext();
palm_ipd_diagnosis_master pom = new palm_ipd_diagnosis_master();
if (ds.Tables[0].Rows.Count == 0)
{
pom.pateint_code = Session["pateint_code"].ToString();
pom.prn = Session["prn"].ToString();
pom.inserted_by = Session["emp_code"].ToString();
pom.inserted_on = DateTime.Now;
rt1.palm_ipd_diagnosis_masters.InsertOnSubmit(pom);
rt1.SubmitChanges();
palm_ipd_final_diagnosi pod = new palm_ipd_final_diagnosi();
pom = rt1.palm_ipd_diagnosis_masters.Single(palm_ipd_diagnosis_master => palm_ipd_diagnosis_master.pateint_code == Session["pateint_code"].ToString());
pod.master_id = pom.opd_diagnosis_master_id;
pod.prn = pom.prn;
pod.Final_diagnosis = TextBox6.Text;
pod.final_remark = TextBox9.Text;
rt1.palm_ipd_final_diagnosis.InsertOnSubmit(pod);
rt1.SubmitChanges();
}
else
{
palm_ipd_final_diagnosi pod = new palm_ipd_final_diagnosi();
pom = rt1.palm_ipd_diagnosis_masters.Single(palm_ipd_diagnosis_master => palm_ipd_diagnosis_master.pateint_code == Session["pateint_code"].ToString());
pod.master_id = pom.opd_diagnosis_master_id;
pod.prn = pom.prn;
pod.Final_diagnosis = TextBox6.Text;
pod.final_remark = TextBox9.Text;
rt1.palm_ipd_final_diagnosis.InsertOnSubmit(pod);
rt1.SubmitChanges();
}
// BindData1();
GridView2.DataBind();
}
