public void Update(List <tblPathologyDetail> lst, tblPathology tblpath) { try { tblPathology path = (from tbl in objData.tblPathologies where tbl.PatientId == tblpath.PatientId select tbl).FirstOrDefault(); if (path != null) { path.FinalComment = tblpath.FinalComment; } foreach (tblPathologyDetail item in lst) { tblPathologyDetail tblpat = (from tbl in objData.tblPathologyDetails where tbl.LabId == item.LabId && tbl.TestParaId == item.TestParaId && tbl.Isdelete == false select tbl).FirstOrDefault(); if (tblpat != null) { tblpat.Result = item.Result; tblpat.UnitId = item.UnitId; tblpat.TestMethodId = item.TestMethodId; tblpat.Comment = item.Comment; } } objData.SubmitChanges(); } catch (Exception ex) { throw ex; } }
protected void BtnEdit_Click(object sender, EventArgs e) { EntityLogin entLogin = (EntityLogin)Session["user"]; tblPathology tblpath = new tblPathology(); tblpath.PatientId = Convert.ToInt32(Session["T_Id"]); tblpath.TestId = Convert.ToInt32(ddlTest.SelectedValue); tblpath.TestDate = DateTime.Now.Date; tblpath.TestDoneById = entLogin.PKId; tblpath.LabId = Convert.ToInt32(Session["LabId"]); tblpath.FinalComment = Convert.ToString(txtFinalComment.Text); List <tblPathologyDetail> lst = new List <tblPathologyDetail>(); foreach (GridViewRow item in GridView1.Rows) { var textbox = item.FindControl("txtResult") as TextBox; var a = textbox.Text; var textboxCommnet = item.FindControl("ddlComment") as DropDownList; var comm = textboxCommnet.SelectedItem.Text; var ddl = item.FindControl("ddlUnit") as DropDownList; var unit = ddl.SelectedValue; var ddltestMeth = item.FindControl("ddlTestMethod") as DropDownList; var testmethod = ddltestMeth.SelectedValue; lst.Add(new tblPathologyDetail { LabId = Convert.ToInt32(Session["LabId"]), TestParaId = Convert.ToInt32(GridView1.DataKeys[0].Value), Result = Convert.ToDecimal(a), UnitId = Convert.ToInt32(unit), TestMethodId = Convert.ToInt32(testmethod), Comment = comm, Isdelete = false }); } mobjDeptBLL.Update(lst, tblpath); BindPatientPathologyTest(); lblMessage.Text = "Record Updated Sucessfully......"; MultiView1.SetActiveView(View1); }
public int Save(tblPathology pathology, List <tblPathologyDetail> lst) { int?Id = 0; objData.STP_Insert_tblPathology(Convert.ToInt32(pathology.PatientId), Convert.ToInt32(pathology.TestId), Convert.ToDateTime(DateTime.Now.Date), pathology.FinalComment, pathology.TestDoneById, ref Id); foreach (tblPathologyDetail item in lst) { tblPathologyDetail objtestDetails = new tblPathologyDetail() { LabId = Convert.ToInt32(Id), TestParaId = item.TestParaId, UnitId = item.UnitId, TestMethodId = item.TestMethodId, Result = item.Result, Comment = item.Comment, Isdelete = false, }; objData.tblPathologyDetails.InsertOnSubmit(objtestDetails); } objData.SubmitChanges(); return(1); }
protected void BtnSave_Click(object sender, EventArgs e) { try { if (ddlPatient.SelectedIndex == 0) { lblMsg.Text = "Please Select Patient"; ddlPatient.SelectedIndex = 0; ddlPatient.Focus(); } if (ddlTest.SelectedIndex == 0) { lblMsg.Text = "Please Select Test"; ddlTest.SelectedIndex = 0; ddlTest.Focus(); } if (txtFinalComment.Text == null) { lblMsg.Text = "Please Enter Final Comment"; ddlTest.SelectedIndex = 0; ddlTest.Focus(); return; } bool flag = false; List <tblPathologyDetail> lst = new List <tblPathologyDetail>(); foreach (GridViewRow item in GridView1.Rows) { var textbox = item.FindControl("txtResult") as TextBox; var a = textbox.Text; if (string.IsNullOrEmpty(a)) { flag = true; break; } var textboxCommnet = item.FindControl("ddlComment") as DropDownList; var comm = textboxCommnet.SelectedItem.Text; if (string.IsNullOrEmpty(comm)) { flag = true; break; } var ddl = item.FindControl("ddlUnit") as DropDownList; int unit = Convert.ToInt32(ddl.SelectedValue); if (unit == 0) { flag = true; break; } var ddltestMeth = item.FindControl("ddlTestMethod") as DropDownList; int testmethod = Convert.ToInt32(ddltestMeth.SelectedValue); if (testmethod == 0) { flag = true; break; } lst.Add(new tblPathologyDetail { TestParaId = Convert.ToInt32(GridView1.DataKeys[item.RowIndex].Value), Result = Convert.ToDecimal(a), UnitId = Convert.ToInt32(unit), TestMethodId = Convert.ToInt32(testmethod), Comment = comm, Isdelete = false }); } if (flag) { lblMsg.Text = "Please Fill Valid & Complete Data"; } else { EntityLogin entLogin = (EntityLogin)Session["user"]; PathologyBLL PBll = new PathologyBLL(); tblPathology pathology = new tblPathology(); pathology.PatientId = Convert.ToInt32(ddlPatient.SelectedValue); pathology.TestId = Convert.ToInt32(ddlTest.SelectedValue); pathology.TestDate = DateTime.Now.Date; pathology.FinalComment = txtFinalComment.Text; pathology.TestDoneById = entLogin.PKId; HttpPostedFile File = (HttpPostedFile)Session["Photo"]; if (File != null) { string appPath = Server.MapPath("~/PathologyImages/"); string Id = Convert.ToString(mobjDeptBLL.GetLabId()); File.SaveAs(appPath + Id + ".jpg"); } int i = PBll.Save(pathology, lst); lblMessage.Text = "Record Saved Sucessfully"; BindPatientPathologyTest(); MultiView1.SetActiveView(View1); } } catch (Exception ex) { lblMessage.Text = ex.Message; } }