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 LoadEntity() { using (ClinicDBContext db = new ClinicDBContext()) { var clinicdata = from clinic_tbl in db.Entities where (clinic_tbl.Deleted == null || clinic_tbl.Deleted == false) select clinic_tbl; GridViewClinic.DataSource = clinicdata.ToList(); GridViewClinic.DataBind(); } }
private void ClinicSearchTempQuery() { int EntityType = int.Parse(ddlEntityType.SelectedValue); using (EntityTempDBContext db = new EntityTempDBContext()) { if (txtEntityNameSe.Text == "" && ddlEntityType.SelectedIndex != 0) { var clinicdata = from clinic_tbl in db.EntityTemps where (clinic_tbl.Deleted == null || clinic_tbl.Deleted == false) && clinic_tbl.Status == null && 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.EntityTemps where (clinic_tbl.Deleted == null || clinic_tbl.Deleted == false) && clinic_tbl.Status == null && 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.EntityTemps where (clinic_tbl.Deleted == null || clinic_tbl.Deleted == false) && clinic_tbl.Status == null && 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.EntityTemps where (clinic_tbl.Deleted == null || clinic_tbl.Deleted == false) && clinic_tbl.Status == null && 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; } }
protected void btnUpdate_Click(object sender, EventArgs e) { //ClinclblSaveStatus.Text = SelectedClinc.ToString(); 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 Brick"; lblAreaReq.Visible = true; } else { using (EntityTempDBContext entityUpdate = new EntityTempDBContext()) { int ID = int.Parse(txtEntityID.Text); EntityTemp updateEn = new EntityTemp(); updateEn.EntityID = ID; updateEn.EntityName = txtEntityName.Text; //updateEn.EntityCode = int.Parse(txtEntityCode.Text); updateEn.EntityAddress = txtEntityAddress.Text; updateEn.EntityTypeID = int.Parse(ddlEntityTypeID.SelectedValue); updateEn.Tel1 = txtTel1.Text; updateEn.Tel2 = txtTel2.Text; updateEn.Tel3 = txtTel3.Text; updateEn.Fax = txtFax.Text; updateEn.EntityEmailAddress = txtEntityEmailAddress.Text; updateEn.EntityWebSite = txtEntityWebSite.Text; updateEn.BrickID = int.Parse(ddlAreaID.SelectedValue); updateEn.BrickName = ddlAreaID.SelectedItem.ToString(); updateEn.Deleted = null; updateEn.EntryDate = DateTime.Now; updateEn.EntryEmployeeID = int.Parse(Session["EmployeeHRCodeFromAdmin"].ToString()); entityUpdate.EntityTemps.Add(updateEn); int roweffected = entityUpdate.SaveChanges(); if (roweffected > 0) { ClinclblSaveStatus.Text = "Updated"; using (EntityTempDBContext Refreshdb = new EntityTempDBContext()) { int code = int.Parse(txtEntityID.Text); var clinicdata = from clinic_tbl in Refreshdb.EntityTemps where (clinic_tbl.Deleted == null || clinic_tbl.Deleted == false) && clinic_tbl.EntityID == code select clinic_tbl; GridViewClinic.DataSource = clinicdata.ToList(); GridViewClinic.DataBind(); } //ClinicSearchQuery(); btnClinicSave.Visible = true; btnUpdate.Visible = false; clearFields(); } else { ClinclblSaveStatus.Text = "Error"; } } } }