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