private void LoadPhysician() { using (PhysicianViewDBContext db = new PhysicianViewDBContext()) { var alldata = from physicion_tbl in db.View_Physicians where physicion_tbl.Deleted == null select physicion_tbl; GridView1.DataSource = alldata.ToList(); GridView1.DataBind(); } }
protected void btnPhysicianSave_Click(object sender, EventArgs e) { if (txtPhysicianName.Text == "") { lblSaveStatus.Text = "Please Fill a Physician Name"; lblPhReq.Visible = true; } else if (ddlAreaId.SelectedIndex == 0) { lblSaveStatus.Text = "Please Select Area"; lblAreaReq.Visible = true; } else { using (PhysicianBDContext newph = new PhysicianBDContext()) { Physician ph = new Physician(); ph.PhysicianName = txtPhysicianName.Text; ph.TelNumber = txtTelNumber.Text; ph.PhysicianEmailAddress = txtPhysicianEmailAddress.Text; ph.MobileNumber = txtMobileNumber.Text; ph.SpecialtyID = int.Parse(ddlAreaId.SelectedValue); ph.Deleted = null; ph.BirthDate = dpBrithDate.SelectedDate; ph.EntryDate = DateTime.Now; ph.EntryEmployeeID = int.Parse(Session["EmployeeHRCodeFromAdmin"].ToString()); newph.Physicians.Add(ph); int roweffected = newph.SaveChanges(); if (roweffected > 0) { lblSaveStatus.Text = "Saved"; lblPhReq.Visible = false; lblAreaReq.Visible = false; clearFields(); } else { lblSaveStatus.Text = "Error"; } } } using (PhysicianViewDBContext db = new PhysicianViewDBContext()) { int maxphy = db.View_Physicians.Max(ph => ph.PhysicianID); var alldata = from physicion_tbl in db.View_Physicians where physicion_tbl.Deleted == null && physicion_tbl.PhysicianID == maxphy select physicion_tbl; GridView1.DataSource = alldata.ToList(); GridView1.DataBind(); } }
protected void btnSearch_Click(object sender, EventArgs e) { int area = int.Parse(ddlAreaSe.SelectedValue); using (PhysicianViewDBContext db = new PhysicianViewDBContext()) { if (txtPhysicianNameSe.Text == "" && ddlAreaSe.SelectedIndex != 0) { var alldata = from physicion_tbl in db.View_Physicians where physicion_tbl.Deleted == null select physicion_tbl; GridView1.DataSource = alldata.ToList(); GridView1.DataBind(); } else if (txtPhysicianNameSe.Text != "" && ddlAreaSe.SelectedIndex == 0) { var alldata = from physicion_tbl in db.View_Physicians where physicion_tbl.Deleted == null && physicion_tbl.PhysicianName.Contains(txtPhysicianNameSe.Text) select physicion_tbl; GridView1.DataSource = alldata.ToList(); GridView1.DataBind(); } else if (txtPhysicianNameSe.Text != "" && ddlAreaSe.SelectedIndex != 0) { var alldata = from physicion_tbl in db.View_Physicians where physicion_tbl.Deleted == null && physicion_tbl.PhysicianName.Contains(txtPhysicianNameSe.Text) select physicion_tbl; GridView1.DataSource = alldata.ToList(); GridView1.DataBind(); } else if (txtPhyCodeSe.Text != "") { int phCode = int.Parse(txtPhyCodeSe.Text); var alldata = from physicion_tbl in db.View_Physicians where physicion_tbl.Deleted == null && physicion_tbl.PhysicianID == phCode select physicion_tbl; GridView1.DataSource = alldata.ToList(); GridView1.DataBind(); } else { lblSaveStatus.Text = "Please Enter Physican Name or Area to Search"; } } }