protected void BtnUpdate_Click(object sender, EventArgs e)
 {
     try
     {
         //ddlPatient.Enabled = false;
         tblNursingManagement tblins = new tblNursingManagement();
         tblins.SrNo          = Convert.ToInt32(Session["PrescriptionId"]);
         tblins.CategoryId    = Convert.ToInt32(ddlWardCategory.SelectedValue);
         tblins.NurseId       = Convert.ToInt32(ddlNurseName.SelectedValue);
         tblins.Department    = Convert.ToString(txtDepartment.Text);
         tblins.TreatmentDate = Convert.ToDateTime(txtTreatmentDate.Text);
         List <EntityNursingManagementDetails> inslst = (List <EntityNursingManagementDetails>)Session["Prescript"];
         MobjClaim.Update(tblins, inslst);
         lblMessage.Text = "Record Updated Successfully.....";
         Clear();
         List <EntityNursingManagementDetails> lst = new List <EntityNursingManagementDetails>();
         dgvChargeDetails.DataSource = lst;
         dgvChargeDetails.DataBind();
         BindDailyNursingManagement();
         Session["Charges"] = null;
         MultiView1.SetActiveView(View1);
     }
     catch (Exception ex)
     {
         lblMsg.Text = ex.Message;
     }
 }
        public int?Save(tblNursingManagement tblins, List <EntityNursingManagementDetails> lst)
        {
            int?SrNo = 0;

            try
            {
                objData.STP_Insert_tblNursingManagement(Convert.ToInt32(tblins.CategoryId), Convert.ToInt32(tblins.NurseId), Convert.ToString(tblins.Department), Convert.ToDateTime(tblins.TreatmentDate), ref SrNo);
                foreach (EntityNursingManagementDetails item in lst)
                {
                    tblNursingManagementDetail tbl = new tblNursingManagementDetail()
                    {
                        PatientId             = Convert.ToInt32(item.PatientId),
                        InjectableMedications = Convert.ToString(item.InjectableMedications),
                        Infusions             = Convert.ToString(item.Infusions),
                        Oral          = Convert.ToString(item.Oral),
                        NursingCare   = Convert.ToString(item.NursingCare),
                        TreatmentTime = Convert.ToString(item.TreatmentTime),
                        CategoryId    = Convert.ToInt32(tblins.CategoryId),
                        NurseId       = Convert.ToInt32(tblins.NurseId),
                        TreatmentDate = Convert.ToDateTime(tblins.TreatmentDate),
                        Department    = Convert.ToString(tblins.Department),
                        SrNo          = Convert.ToInt32(SrNo),
                        IsDelete      = false
                    };
                    objData.tblNursingManagementDetails.InsertOnSubmit(tbl);
                }
                objData.SubmitChanges();
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return(SrNo);
        }
        public tblNursingManagement GetPrescriptionInfo(int SrNo)
        {
            tblNursingManagement obj = null;

            try
            {
                obj = (from tbl in objData.tblNursingManagements
                       where tbl.IsDelete == false &&
                       tbl.SrNo == SrNo
                       select tbl).FirstOrDefault();
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return(obj);
        }
        protected void BtnEdit_Click(object sender, EventArgs e)
        {
            btnAdd.Visible          = true;
            btnUpdatecharge.Visible = false;
            BtnSave.Visible         = false;
            btnUpdate.Visible       = true;
            Session["MyFlag"]       = "Edit";
            ImageButton imgEdit = (ImageButton)sender;
            GridViewRow row     = (GridViewRow)imgEdit.NamingContainer;

            Session["PrescriptionId"] = Convert.ToInt32(dgvClaim.DataKeys[row.RowIndex].Value);
            ListItem item    = ddlNurseName.Items.FindByText(Convert.ToString(row.Cells[2].Text));
            ListItem itemDoc = ddlWardCategory.Items.FindByText(Convert.ToString(row.Cells[4].Text));

            if (item != null && itemDoc != null)
            {
                ddlNurseName.SelectedValue    = item.Value;
                ddlWardCategory.SelectedValue = itemDoc.Value;
                DateTime MDate = Convert.ToDateTime(row.Cells[1].Text);
                txtTreatmentDate.Text = string.Format("{0:MM/dd/yyyy}", MDate);
                txtDepartment.Text    = Convert.ToString(row.Cells[3].Text);
                string dept = txtDepartment.Text;
                List <EntityPatientAdmit> lst = MobjClaim.GetPatientList(dept);
                ddlPatient.DataSource = lst;
                lst.Insert(0, new EntityPatientAdmit()
                {
                    AdmitId = 0, PatientFirstName = "--Select--"
                });
                ddlPatient.DataValueField = "AdmitId";
                ddlPatient.DataTextField  = "PatientFirstName";
                ddlPatient.DataBind();
                tblNursingManagement objPresc = MobjClaim.GetPrescriptionInfo(Convert.ToInt32(Session["PrescriptionId"]));
                BindPrescription(Convert.ToInt32(Session["PrescriptionId"]));
                //InjectionPara(false);
                MultiView1.SetActiveView(View2);
            }
            else
            {
                lblMessage.Text = "Category Name Not Found";
            }
        }
        protected void BtnSave_Click(object sender, EventArgs e)
        {
            tblNursingManagement tblins = new tblNursingManagement();

            tblins.CategoryId    = Convert.ToInt32(ddlWardCategory.SelectedValue);
            tblins.NurseId       = Convert.ToInt32(ddlNurseName.SelectedValue);
            tblins.Department    = Convert.ToString(txtDepartment.Text);
            tblins.TreatmentDate = Convert.ToDateTime(txtTreatmentDate.Text);

            List <EntityNursingManagementDetails> inslst = (List <EntityNursingManagementDetails>)Session["Charges"];
            int ClaimId = Convert.ToInt32(MobjClaim.Save(tblins, inslst));

            lblMessage.Text    = "Record Saved Successfully.....";
            Session["Charges"] = null;
            Clear();
            inslst = new List <EntityNursingManagementDetails>();
            dgvChargeDetails.DataSource = inslst;
            dgvChargeDetails.DataBind();
            lblMsg.Text = string.Empty;

            Session["Charges"] = new List <EntityNursingManagementDetails>();
            BindDailyNursingManagement();
            MultiView1.SetActiveView(View1);
        }
        public void Update(tblNursingManagement obj, List <EntityNursingManagementDetails> lst)
        {
            try
            {
                tblNursingManagement objcurrent = (from tbl in objData.tblNursingManagements
                                                   where tbl.SrNo == obj.SrNo
                                                   select tbl).FirstOrDefault();
                if (objcurrent != null)
                {
                    objcurrent.CategoryId    = obj.CategoryId;
                    objcurrent.NurseId       = obj.NurseId;
                    objcurrent.TreatmentDate = obj.TreatmentDate;
                    objcurrent.Department    = obj.Department;
                }

                foreach (EntityNursingManagementDetails item in lst)
                {
                    tblNursingManagementDetail objsal = new tblNursingManagementDetail();
                    objsal = (from tbl in objData.tblNursingManagementDetails
                              where tbl.SrDetailId == item.SrDetailId &&
                              tbl.SrNo == item.SrNo && tbl.PatientId == item.PatientId &&
                              tbl.IsDelete == false
                              select tbl).FirstOrDefault();
                    if (objsal != null)
                    {
                        objsal.PatientId             = Convert.ToInt32(item.PatientId);
                        objsal.CategoryId            = obj.CategoryId;
                        objsal.NurseId               = obj.NurseId;
                        objsal.TreatmentDate         = obj.TreatmentDate;
                        objsal.InjectableMedications = item.InjectableMedications;
                        objsal.Infusions             = item.Infusions;
                        objsal.Oral          = item.Oral;
                        objsal.NursingCare   = item.NursingCare;
                        objsal.TreatmentTime = item.TreatmentTime;
                        objsal.Department    = obj.Department;
                        objsal.IsDelete      = item.IsDelete;
                    }
                    else
                    {
                        objsal = new tblNursingManagementDetail()
                        {
                            PatientId             = item.PatientId,
                            CategoryId            = obj.CategoryId,
                            NurseId               = obj.NurseId,
                            TreatmentDate         = obj.TreatmentDate,
                            Department            = obj.Department,
                            InjectableMedications = item.InjectableMedications,
                            Infusions             = item.Infusions,
                            Oral          = item.Oral,
                            NursingCare   = item.NursingCare,
                            TreatmentTime = item.TreatmentTime,
                            SrNo          = Convert.ToInt32(obj.SrNo),
                            IsDelete      = false
                        };
                        objData.tblNursingManagementDetails.InsertOnSubmit(objsal);
                    }
                }
                objData.SubmitChanges();
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }