protected void btnSearchTemp_Click(object sender, EventArgs e) { int area = int.Parse(ddlAreaSe.SelectedValue); using (PhysiciansTempDBContext db = new PhysiciansTempDBContext()) { if (txtPhysicianNameSe.Text == "" && ddlAreaSe.SelectedIndex != 0) { var alldata = from physicion_tbl in db.PhysiciansTemps where physicion_tbl.Status == null && physicion_tbl.SpecialtyID == area select physicion_tbl; GridView1.DataSource = alldata.ToList(); GridView1.DataBind(); } else if (txtPhysicianNameSe.Text != "" && ddlAreaSe.SelectedIndex == 0) { var alldata = from physicion_tbl in db.PhysiciansTemps where physicion_tbl.Status == 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.PhysiciansTemps where physicion_tbl.Status == null && physicion_tbl.PhysicianName.Contains(txtPhysicianNameSe.Text) && physicion_tbl.SpecialtyID == area 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.PhysiciansTemps where physicion_tbl.Status == null && physicion_tbl.PhysicianID == phcode select physicion_tbl; GridView1.DataSource = alldata.ToList(); GridView1.DataBind(); } else { var alldata = from physicion_tbl in db.PhysiciansTemps where physicion_tbl.Status == null select physicion_tbl; GridView1.DataSource = alldata.ToList(); GridView1.DataBind(); } } }
protected void btnPhysicianUpdate_Click(object sender, EventArgs e) { using (PhysiciansTempDBContext NewPhyTemp = new PhysiciansTempDBContext()) { PhysiciansTemp updateph = new PhysiciansTemp(); int PhysicianID = int.Parse(txtphysicianID.Text); updateph.PhysicianID = PhysicianID; updateph.PhysicianName = txtPhysicianName.Text; updateph.TelNumber = txtTelNumber.Text; updateph.PhysicianEmailAddress = txtPhysicianEmailAddress.Text; updateph.MobileNumber = txtMobileNumber.Text; updateph.SpecialtyID = int.Parse(ddlAreaId.SelectedValue); updateph.SpecialtyName = ddlAreaId.SelectedItem.ToString(); updateph.Deleted = null; updateph.BirthDate = dpBrithDate.SelectedDate; updateph.EntryEmployeeID = int.Parse(Session["EmployeeHRCodeFromAdmin"].ToString()); updateph.EntryDate = DateTime.Now; NewPhyTemp.PhysiciansTemps.Add(updateph); int roweffected = NewPhyTemp.SaveChanges(); if (roweffected > 0) { lblSaveStatus.Text = "Updated"; using (PhysiciansTempDBContext refreshdb = new PhysiciansTempDBContext()) { var alldata = from physicion_tbl in refreshdb.PhysiciansTemps where physicion_tbl.Deleted == null && physicion_tbl.PhysicianName == txtPhysicianName.Text select physicion_tbl; GridView1.DataSource = alldata.ToList(); GridView1.DataBind(); } clearFields(); } else { lblSaveStatus.Text = "Error"; } //LoadPhysician(); } }