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