protected void btnClinicSave_Click(object sender, EventArgs e)
{
if (txtEntityName.Text == "")
{
ClinclblSaveStatus.Text = "Please Fill a Entity Name";
lblNameReq.Visible = true;
}
else if (ddlEntityTypeID.SelectedIndex == 0)
{
ClinclblSaveStatus.Text = "Please Select Entity Type";
lbltypeReq.Visible = true;
}
else if (ddlAreaID.SelectedIndex == 0)
{
ClinclblSaveStatus.Text = "Please Select Area";
lblAreaReq.Visible = true;
}
else
{
using (ClinicDBContext newEn = new ClinicDBContext())
{
Entity en = new Entity();
en.EntityName = txtEntityName.Text;
//en.EntityCode = int.Parse(txtEntityCode.Text);
en.EntityAddress = txtEntityAddress.Text;
en.EntityTypeID = int.Parse(ddlEntityTypeID.SelectedValue);
en.Tel1 = txtTel1.Text;
en.Tel2 = txtTel2.Text;
en.Tel3 = txtTel3.Text;
en.Fax = txtFax.Text;
en.EntityEmailAddress = txtEntityEmailAddress.Text;
en.EntityWebSite = txtEntityWebSite.Text;
en.BrickID = int.Parse(ddlAreaID.SelectedValue);
en.Deleted = false;
en.EntryDate = DateTime.Now;
en.EntryEmployeeID = int.Parse(Session["EmployeeHRCodeFromAdmin"].ToString());
newEn.Entities.Add(en);
int roweffected = newEn.SaveChanges();
if (roweffected > 0)
{
ClinclblSaveStatus.Text = "Saved";
lblNameReq.Visible = false;
lbltypeReq.Visible = false;
lblAreaReq.Visible = false;
clearFields();
}
else
{
ClinclblSaveStatus.Text = "Error";
}
}
}
using (EntitiesViewDBContext db = new EntitiesViewDBContext())
{
int maxent = db.View_Entities.Max(en => en.EntityID);
var clinicdata = from clinic_tbl in db.View_Entities where (clinic_tbl.Deleted == null || clinic_tbl.Deleted == false) && clinic_tbl.EntityID == maxent select clinic_tbl;
GridViewClinic.DataSource = clinicdata.ToList();
GridViewClinic.DataBind();
}
}
private void ClinicSearchQuery()
{
int EntityType = int.Parse(ddlEntityType.SelectedValue);
using (EntitiesViewDBContext db = new EntitiesViewDBContext())
{
if (txtEntityNameSe.Text == "" && ddlEntityType.SelectedIndex != 0)
{
var clinicdata = from clinic_tbl in db.View_Entities where (clinic_tbl.Deleted == null || clinic_tbl.Deleted == false) && clinic_tbl.EntityTypeID == EntityType select clinic_tbl;
GridViewClinic.DataSource = clinicdata.ToList();
GridViewClinic.DataBind();
}
else if (txtEntityNameSe.Text != "" && ddlEntityType.SelectedIndex != 0)
{
var clinicdata = from clinic_tbl in db.View_Entities where (clinic_tbl.Deleted == null || clinic_tbl.Deleted == false) && clinic_tbl.EntityTypeID == EntityType && clinic_tbl.EntityName.Contains(txtEntityNameSe.Text) select clinic_tbl;
GridViewClinic.DataSource = clinicdata.ToList();
GridViewClinic.DataBind();
}
else if (txtEntityNameSe.Text != "" && ddlEntityType.SelectedIndex == 0)
{
var clinicdata = from clinic_tbl in db.View_Entities where (clinic_tbl.Deleted == null || clinic_tbl.Deleted == false) && clinic_tbl.EntityName.Contains(txtEntityNameSe.Text) select clinic_tbl;
GridViewClinic.DataSource = clinicdata.ToList();
GridViewClinic.DataBind();
}
else if (txtEntityCodeSe.Text != "")
{
int EntCode = int.Parse(txtEntityCodeSe.Text);
var clinicdata = from clinic_tbl in db.View_Entities where (clinic_tbl.Deleted == null || clinic_tbl.Deleted == false) && clinic_tbl.EntityID == EntCode select clinic_tbl;
GridViewClinic.DataSource = clinicdata.ToList();
GridViewClinic.DataBind();
}
else
{
ClinclblSaveStatus.Text = "Please Enter Entity Name or Type to Search";
}
//GridViewClinic.Columns[2].Visible = false;
//GridViewClinic.Columns[3].Visible = false;
}
}
