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