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