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