public void showFilters(object sender, EventArgs e) { string s = FilterBy_SelectedIndexChanged(); string text = findTextBox(); var context = new DefaultContainer(new Uri("https://services.odata.org/V4/(S(y5tuj04bxbfsxzimbxbnauqg))/TripPinServiceRW/")); IEnumerable <Person> person = context.People.Execute();; switch (s) { case "UserName": person = context.People.Where(c => c.UserName.Equals(text)); break; case "LastName": person = context.People.Where(c => c.LastName.Equals(text)); break; case "FirstName": person = context.People.Where(c => c.FirstName.Equals(text)); break; } GridViewPerson.DataSource = person; GridViewPerson.DataBind(); }
/// <summary> /// Method to load the Person Search Results gridview /// </summary> protected void LoadPersonGridView() { string strFirstName = Convert.ToString(txtFirstName.Text.Trim()); string strLastName = Convert.ToString(txtLastName.Text.Trim()); int?nStateId = null; if (Convert.ToInt32(ddlState.SelectedItem.Value) != -1) { nStateId = Convert.ToInt32(ddlState.SelectedItem.Value); } char?cGender = null; if (rblGender.SelectedIndex != -1) { cGender = Convert.ToChar(rblGender.SelectedItem.Value); } DateTime?dtDob = null; if (!(String.IsNullOrEmpty(txtDOB.Text))) { dtDob = Convert.ToDateTime(DateTime.Parse(txtDOB.Text.Trim()).Date); } List <DTOPerson> lstPerson = new List <DTOPerson>(); DALMethods dalMethods = new DALMethods(); lstPerson = dalMethods.GetPersonDetails(strFirstName, strLastName, nStateId, cGender, dtDob); GridViewPerson.DataSource = lstPerson; GridViewPerson.DataBind(); lblSearchResults.Visible = true; }
protected void ListPeople() { var serviceRoot = "https://services.odata.org/V4/TripPinServiceRW/"; var context = new DefaultContainer(new Uri(serviceRoot)); IEnumerable <Person> people = context.People.Execute(); GridViewPerson.DataSource = people; GridViewPerson.DataBind(); }
/// <summary> /// Method to load the Person Search Results gridview /// </summary> /// <param name="strFirstName"></param> /// <param name="strLastName"></param> /// <param name="nStateId"></param> /// <param name="Gender"></param> /// <param name="dtDOB"></param> protected void LoadPersonGridView(string strFirstName, string strLastName, int nStateId, char Gender, DateTime dtDOB) { List <DTOPerson> lstPerson = new List <DTOPerson>(); DALMethods dalMethods = new DALMethods(); lstPerson = dalMethods.GetPersonDetails(strFirstName, strLastName, nStateId, Gender, dtDOB); GridViewPerson.DataSource = lstPerson; GridViewPerson.DataBind(); lblSearchResults.Visible = true; }
protected void LoadDataGridView(string name) { if (string.IsNullOrEmpty(name)) { GridViewPerson.DataSource = DalPerson.GetPerson(); } else { GridViewPerson.DataSource = DalPerson.GetPerson(name); } GridViewPerson.DataBind(); }
protected void DropDownListPatients_SelectedIndexChanged(object sender, EventArgs e) { GridViewPerson.Visible = true; if (Convert.ToInt32(DropDownListPatients.SelectedValue) != 0) { GridViewRes.Visible = false; GridViewDays.Visible = false; LabelMessage.Text = DropDownListPatients.SelectedValue.ToString(); try { conn.Open(); cmd = conn.CreateCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "SelectAllRes"; SqlParameter in1 = cmd.Parameters.Add("@P_id", SqlDbType.Int); in1.Direction = ParameterDirection.Input; in1.Value = Convert.ToInt32(DropDownListPatients.SelectedValue.ToString()); rdr = cmd.ExecuteReader(); GridViewPerson.DataSource = rdr; GridViewPerson.DataBind(); } catch (Exception ex) { LabelMessage.Text = ex.Message + ex.StackTrace; } finally { conn.Close(); } } }
protected void descButton_Click(object sender, EventArgs e) { string s = DropDownList_SelectedIndexChanged(); var context = new DefaultContainer(new Uri("https://services.odata.org/V4/(S(y5tuj04bxbfsxzimbxbnauqg))/TripPinServiceRW/")); IEnumerable <Person> person = context.People.Execute();; switch (s) { case "UserName": person = context.People.OrderByDescending(c => c.UserName).ToList(); break; case "LastName": person = context.People.OrderByDescending(c => c.LastName).ToList(); break; case "FirstName": person = context.People.OrderByDescending(c => c.FirstName).ToList(); break; } GridViewPerson.DataSource = person; GridViewPerson.DataBind(); }
protected void ButtonUpdate_Click(object sender, EventArgs e) { SqlConnection conn = new SqlConnection(@"data source = .\sqlexpress; integrated security = true; database = Dentist"); SqlCommand cmd = null; try { conn.Open(); cmd = conn.CreateCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "UpdateReservation"; SqlParameter in1 = cmd.Parameters.Add("@Date", SqlDbType.DateTime); SqlParameter in2 = cmd.Parameters.Add("@P_Id", SqlDbType.Int); SqlParameter in3 = cmd.Parameters.Add("@D_Id", SqlDbType.Int); SqlParameter in4 = cmd.Parameters.Add("@T_Id", SqlDbType.Int); SqlParameter in5 = cmd.Parameters.Add("@R_Id", SqlDbType.Int); in1.Direction = ParameterDirection.Input; in1.Value = DateTime.Parse(TextBoxDate.Text); in2.Direction = ParameterDirection.Input; in2.Value = TextBoxP_id.Text; in3.Direction = ParameterDirection.Input; in3.Value = TextBoxD_id.Text; in4.Direction = ParameterDirection.Input; in4.Value = TextBoxT_id.Text; in5.Direction = ParameterDirection.Input; in5.Value = Convert.ToInt32(LabelMessage.Text); cmd.ExecuteNonQuery(); LabelMessage.Text = "Reservation has been updated"; } catch (Exception ex) { LabelMessage.Text = ex.Message + ex.StackTrace; } finally { conn.Close(); } if (Session["PatientName"] != null) { UpdateGridview(); } else if (Session["DentistName"] != null) { UpdateGridviewDentist(); } try { conn.Open(); cmd = conn.CreateCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "SelectAllRes"; SqlParameter in1 = cmd.Parameters.Add("@P_id", SqlDbType.Int); in1.Direction = ParameterDirection.Input; in1.Value = Convert.ToInt32(TextBoxP_id.Text); rdr = cmd.ExecuteReader(); GridViewPerson.DataSource = rdr; GridViewPerson.DataBind(); } catch (Exception ex) { LabelMessage.Text = ex.Message + ex.StackTrace; } finally { conn.Close(); } try { conn.Open(); cmd = conn.CreateCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "SelectResByDay"; SqlParameter in1 = cmd.Parameters.Add("@Date", SqlDbType.DateTime); in1.Direction = ParameterDirection.Input; in1.Value = Convert.ToDateTime(TextBoxDate.Text); rdr = cmd.ExecuteReader(); GridViewDays.DataSource = rdr; GridViewDays.DataBind(); } catch (Exception ex) { LabelMessage.Text = ex.Message + ex.StackTrace; } finally { conn.Close(); } }