private void MoveDisplayDetails_Window(UserDetailsClass displayUser)
{
DisplayPersonWindow dashboardDetails = new DisplayPersonWindow();
dashboardDetails.FillDetails(displayUser);
dashboardDetails.Show();
this.Close();
}
public MainWindow()
{
InitializeComponent();
#region Select
//DataTable dt = UserDetailsClass.Select();
//displayDetails.ItemsSource = dt.DefaultView;
#endregion
UserDetailsClass searchUser = new UserDetailsClass();
searchUser.UserID = -1;
searchUser.FirstName = "";
searchUser.LastName = "";
DataTable dt = UserDetailsClass.Search(searchUser);
displayDetails.ItemsSource = dt.DefaultView;
}
private void btnSearch_Click(object sender, RoutedEventArgs e)
{
UserDetailsClass searchUser = new UserDetailsClass();
if (String.IsNullOrEmpty(txtID.Text))
{
searchUser.UserID = -1;
}
else
{
searchUser.UserID = int.Parse(txtID.Text);
}
if (String.IsNullOrEmpty(txtName.Text)) // FirstName and LastName empty.
{
searchUser.FirstName = "";
searchUser.LastName = "";
}
else
{
if (txtName.Text.Split(' ').Length == 2) // FirstName and LastName uses.
{
searchUser.FirstName = txtName.Text.Split(' ')[0];
searchUser.LastName = txtName.Text.Split(' ')[1];
}
else if (txtName.Text.Split(' ').Length == 1) // FirstName use, LastName empty.
{
searchUser.FirstName = txtName.Text.Split(' ')[0];
searchUser.LastName = "";
}
else
{
searchUser.FirstName = "-1";
searchUser.LastName = "-1";
}
}
DataTable dt = UserDetailsClass.Search(searchUser);
displayDetails.ItemsSource = dt.DefaultView;
}
public void FillDetails(UserDetailsClass displayUser)
{
txtName1.Text = displayUser.FirstName + " " + displayUser.LastName;
txtWorkerNum.Text = "000" + displayUser.UserID.ToString();
txtName2.Text = displayUser.FirstName + " " + displayUser.LastName;
txtID.Text = displayUser.UserID.ToString();
txtAddress.Text = displayUser.Address;
txtPhoneNumber.Text = displayUser.PhoneNumber;
txtGender.Text = displayUser.Gender;
txtDescription.Text = displayUser.Description;
#region another solution
//txtName.Content = displayUser.FirstName + " " + displayUser.LastName;
//txtID.Content = displayUser.UserID;
//txtAddress.Content = displayUser.Address;
//txtPhoneNumber.Content = displayUser.PhoneNumber;
//txtGender.Content = displayUser.Gender;
#endregion
}
private void DisplayDetails_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
DataGrid dg = sender as DataGrid;
DataRowView dr = dg.SelectedItem as DataRowView;
Console.WriteLine("-----"); Console.WriteLine("-----"); Console.WriteLine("-----");
if (dr != null)
{
UserDetailsClass displayUser = new UserDetailsClass()
{
UserID = Convert.ToInt32(dr["UserID"]),
FirstName = dr["FirstName"].ToString(),
LastName = dr["LastName"].ToString(),
PhoneNumber = dr["PhoneNumber"].ToString(),
Address = dr["Address"].ToString(),
Gender = dr["Gender"].ToString(),
Description = dr["Description"].ToString()
};
MoveDisplayDetails_Window(displayUser);
}
Console.WriteLine(dr["FirstName"].ToString() + " " + dr["LastName"].ToString());
}
//public Button Buutton { get; set; }
#region Select
//public static DataTable Select()
//{
// // Database Connection
// SqlConnection sqlCon = new SqlConnection(@"data source=LAPTOP-NSUOOFBL\SQLEXPRESS; initial catalog=LoginDB; integrated security=True;");
// DataTable dt = new DataTable();
// try
// {
// if (sqlCon.State == System.Data.ConnectionState.Closed)
// {
// sqlCon.Open();
// }
// // Writing SQL Query
// String query = "select *" +
// " from tbl_user_info" +
// " order by UserID, FirstName";
// // Creating sqlCmd using query and sqlCon
// SqlCommand sqlCmd = new SqlCommand(query, sqlCon);
// // Creating SQL DataAdapter using sqlCmd
// SqlDataAdapter adapter = new SqlDataAdapter(sqlCmd);
// adapter.Fill(dt);
// int count = Convert.ToInt32(sqlCmd.ExecuteScalar());
// if (count != 1)
// {
// MessageBox.Show(".אין אנשים במערכת");
// }
// }
// catch (Exception ex)
// {
// MessageBox.Show(ex.Message);
// }
// finally
// {
// sqlCon.Close();
// }
// return dt;
//}
#endregion
public static DataTable Search(UserDetailsClass s)
{
//bool isSuccess = false;
// Database Connection
SqlConnection sqlCon = new SqlConnection(@"data source=LAPTOP-NSUOOFBL\SQLEXPRESS; initial catalog=LoginDB; integrated security=True;");
DataTable dt = new DataTable();
try
{
if (sqlCon.State == System.Data.ConnectionState.Closed)
{
sqlCon.Open();
}
String query = "select * from tbl_user_info ";
Console.WriteLine("-----------------------");
Console.WriteLine("-> FirstName:" + s.FirstName + ",LastName:" + s.LastName);
if ((s.UserID == -1) && (s.FirstName == "" && s.LastName == "")) // all empty.
{
//dt = Select();
//return dt;
// Writing SQL Query
query += "order by UserID, FirstName";
}
else if ((s.UserID != -1) && (s.FirstName == "" && s.LastName == "")) // UserID use.
{
// Writing SQL Query
query += "where UserID=@UserID";
}
else if ((s.UserID == -1) && (s.FirstName != "-1" || s.FirstName != "") && s.LastName == "") // FirstName use.
{
// Writing SQL Query
query += "where (FirstName=@FirstName or FirstName like @FirstName + '%')";
}
else if ((s.UserID != -1) && (s.FirstName != "-1" || s.FirstName != "") && s.LastName == "") // UserID and FirstName uses.
{
// Writing SQL Query
query += "where UserID=@UserID and (FirstName=@FirstName or FirstName like @FirstName + '%')";
}
else if ((s.UserID == -1) && (s.FirstName != "-1" || s.FirstName != "") && (s.LastName != "-1" || s.LastName != "")) // UserID empty and FullName uses.
{
// Writing SQL Query
query += "where (FirstName=@FirstName or FirstName like @FirstName + '%') and (LastName=@LastName or LastName like @LastName + '%')";
}
else
{
// Writing SQL Query
query += "where UserID=@UserID and (FirstName=@FirstName or FirstName like @FirstName + '%') and (LastName=@LastName or LastName like @LastName + '%')";
#region complet select
//query = "select" +
// " UserID as 'מזהה משתמש'," +
// " FirstName as 'שם פרטי'," +
// " LastName as 'שם משפחה'," +
// " PhoneNumber as 'מספר טלפון'," +
// " Address as 'כתובת'," +
// " Gender as 'מין'" +
// " from tbl_user_info" +
// " where UserID=@UserID and (FirstName=@FirstName or FirstName like @FirstName + '%') and (LastName=@LastName or LastName like @LastName + '%')";
#endregion
}
// Creating sqlCmd using query and sqlCon
SqlCommand sqlCmd = new SqlCommand(query, sqlCon);
// Create Parameters to do search
sqlCmd.Parameters.AddWithValue("@UserID", s.UserID);
sqlCmd.Parameters.AddWithValue("@FirstName", s.FirstName);
sqlCmd.Parameters.AddWithValue("@LastName", s.LastName);
// Creating SQL DataAdapter using sqlCmd
SqlDataAdapter adapter = new SqlDataAdapter(sqlCmd);
adapter.Fill(dt);
for (int a = 0; a < dt.Rows.Count; a++)
{
for (int b = 0; b < dt.Columns.Count; b++)
{
Console.WriteLine(dt.Rows[a].ItemArray[b]);
}
Console.WriteLine("--");
}
foreach (DataRow row in dt.Rows)
{
string value0 = row.ItemArray[0].ToString();
string value1 = row.ItemArray[1].ToString();
string value2 = row.ItemArray[2].ToString();
Console.WriteLine(value0 + " - " + value1 + " " + value2);
//...
}
#region comments
//sqlReader.Close();
//SqlDataAdapter adapter = new SqlDataAdapter(sqlCmd);
//adapter.Fill(dt);
//DataColumn newColumn = new DataColumn("הצגת פרטים", typeof(Button));
//dt.Columns.Add(newColumn);
//for (int a = 0; a < dt.Rows.Count; a++)
//{
// dt.Rows[a].ItemArray[6] = MakeAButton();
//}
//adapter.Update(dt);
//adapter.Fill(dt);
//SqlDataReader sqlReader = sqlCmd.ExecuteReader();
//DataColumn newColumn0 = new DataColumn("מזהה משתמש", typeof(int));
//DataColumn newColumn1 = new DataColumn("שם פרטי", typeof(string));
//DataColumn newColumn2 = new DataColumn("שם משפחה", typeof(string));
//DataColumn newColumn3 = new DataColumn("מספר טלפון", typeof(string));
//DataColumn newColumn4 = new DataColumn("כתובת", typeof(string));
//DataColumn newColumn5 = new DataColumn("מין", typeof(string));
//DataColumn newColumn6 = new DataColumn("הצגת פרטים", typeof(Button));
//dt.Columns.Add(newColumn0);
//dt.Columns.Add(newColumn1);
//dt.Columns.Add(newColumn2);
//dt.Columns.Add(newColumn3);
//dt.Columns.Add(newColumn4);
//dt.Columns.Add(newColumn5);
//dt.Columns.Add(newColumn6);
//dt.Columns.Add("מזהה משתמש");
//dt.Columns.Add("שם פרטי");
//dt.Columns.Add("שם משפחה");
//dt.Columns.Add("מספר טלפון");
//dt.Columns.Add("כתובת");
//dt.Columns.Add("מין");
//dt.Columns.Add("הצגת פרטים");
//while (sqlReader.Read())
//{
// DataRow dataRow = dt.NewRow();
// Console.WriteLine(sqlReader["FirstName"].ToString() + " " + sqlReader["LastName"].ToString());
// dataRow["מזהה משתמש"] = Convert.ToInt32(sqlReader["UserID"]);
// dataRow["שם פרטי"] = sqlReader["FirstName"].ToString();
// dataRow["שם משפחה"] = sqlReader["LastName"].ToString();
// dataRow["מספר טלפון"] = sqlReader["PhoneNumber"].ToString();
// dataRow["כתובת"] = sqlReader["Address"].ToString();
// dataRow["מין"] = sqlReader["Gender"].ToString();
// dataRow["הצגת פרטים"] = MakeAButton();
// Console.WriteLine(dataRow["שם פרטי"].ToString() + " " + dataRow["שם משפחה"].ToString());
// dt.Rows.Add(dataRow);
//}
//foreach (DataRow row in schemaTable.Rows)
//{
// for (int a = 0; a < schemaTable.Rows.Count; a++)
// {
// DataColumn newColumn1 = new DataColumn();
// Button btn = new Button();
// btn.Content = "הצג פרטים";
// btn.Name = "button" + a + "";
// btn.Click += BtnDelete_Click;
// //newColumn1.add = btn;
// //schemaTable.Columns.Add(btn);
// //dt.Columns.Add("הצגת פרטים", typeof(Button));
// //btn.Click += new EventHandler(this.BtnDelete_Click);
// //btn.Click += new RoutedEventHandler(this.BtnDelete_Click);
// //btnExitApp.Content = "Exit Application";
// //btnExitApp.Height = 25;
// //btnExitApp.Width = 100;
// //dt.Rows.Add(newColumn1);
// }
//}
//DataRow[] rows = dt.Select();
//DataColumn newColumn = new DataColumn("הצגת פרטים", typeof(System.String));
//DataColumn newColumn = new DataColumn("הצגת פרטים", typeof(Button));
//dt.Columns.Add(newColumn);
//adapter.Fill(dt);
//int countNum = 0;
//for(int i=0; i< dt.Rows.Count; i++)
//{
// //DataColumn newColumn1 = new DataColumn();
// Button btn = new Button();
// btn.DataContext = "הצג פרטים";
// btn.Name = "button" + i + "";
// btn.Click += BtnDelete_Click;
// dt.Rows[i] = "button";
// //dt.Columns.Add("הצגת פרטים", typeof(Button));
// //btn.Click += new EventHandler(this.BtnDelete_Click);
// //dt.Rows.Add(newColumn1);
//}
//DataRow newRow = dt.NewRow();
//Button btn1 = new Button();
////btn.DataContext = "הצג פרטים";
//btn1.Name = "button1";
//btn1.Content = "הצג פרטים";
//btn1.Width = 10;
//btn1.Height = 10;
//btn1.ClickMode = ClickMode.Press;
//btn1.Click += BtnDelete_Click;
//newRow[0] = 10;
//newRow[1] = "אורן";
//newRow[2] = "ביטון";
//newRow[3] = "חדרה";
//newRow[4] = 098888888;
//newRow[5] = "זכר";
//newRow[6] = btn1;
//dt.Rows.Add(newRow);
//newRow["הצגת פרטים"] = new Button()
//{
// //DataContext = "הצג פרטים",
// Name = "button1",
// Content = "הצג פרטים",
// Width = 10,
// Height = 10,
//};
//dt.Rows.Add(newRow);
//for (int a = 0; a < dt.Rows.Count; a++)
//{
// Button btn = new Button();
// //btn.DataContext = "הצג פרטים";
// btn.Name = "button" + a + "";
// btn.Content = "הצג פרטים";
// btn.Width = 10;
// btn.Height = 10;
// btn.Click += BtnDelete_Click;
// //btn.Click += new EventHandler(dt.Rows[a].ItemArray[6].BtnDelete_Click);
// //dt.Rows[a].GetChildRows(btn);
// Console.WriteLine(dt.Rows[a][6].GetType());
// //dt.Rows[a]["הצגת פרטים"] = btn;
// //dt.Rows[a].ItemArray[6] = btn;
// //dt.Rows.Add(dt.NewRow());
// adapter.Update(dt);
// for (int b = 0; b < dt.Columns.Count; b++)
// {
// Console.WriteLine(dt.Rows[a].ItemArray[b].ToString());
// }
// Console.WriteLine("----------");
// Console.WriteLine(dt.Rows[a].ItemArray[6].ToString());
// //dt.Rows[i].ItemArray[5] = new Button() {
// // Name = "rowButton",
// // DataContext = "Row Button Content",
// // Width = 10,
// // Height = 10,
// //};
// //Console.WriteLine(dt.Rows[i].ItemArray[5].ToString());
//}
//foreach (DataRow row in dt.Rows)
//{
// Console.WriteLine("1 -------");
// row.BeginEdit();
// row["הצגת פרטים"] = new Button()
// {
// Name = "rowButton",
// DataContext = "Row Button Content",
// Width = 10,
// Height = 10,
// };
// dt.Rows.Add(row);
// //adapter.Fill(dt);
// row.EndEdit();
// //row.BeginEdit();
//}
//for (int i = 0; i < dt.Rows.Count; i++)
//{
// Console.WriteLine(i);
// //row.AcceptChanges();
// //row["הצגת פרטים"] = new Button()
// //{
// // Name = "rowButton",
// // DataContext = "Row Button Content",
// // Width = 10,
// // Height = 10,
// //};
// //dt.Rows.Add(row);
// //row.AcceptChanges();
// ////row.AcceptChanges();
// //dt.AcceptChanges();
//}
//row["הצגת פרטים"] = new Button
//{
// Name = "rowButton",
// DataContext = "Row Button Content",
// Width = 10,
// Height = 10
//};
//dt.Rows.Add(row);
//dt.RowChanged
//DataColumn newColumn1 = new DataColumn();
//Button btn = new Button();
//btn.DataContext = "הצג פרטים";
//btn.Name = "button" + countNum + "";
//btn.Click += BtnDelete_Click;
//btn.Click += new EventHandler(this.BtnDelete_Click);
////Console.WriteLine(" ***** ");
//countNum++;
//dt.Rows.Add(btn);
//btn.Click += new EventHandler(BtnDelete_Click);
//adapter.Fill(dt);
//newColumn.DefaultValue = "הצג פרטים";
//dt.Columns.Add(newColumn);
//for (int i = 0; i < rows.Length; i++)
//{
// //dt.Rows[i].add;
//}
//adapter.Fill(dt);
//private static void BtnDelete_Click(object sender, RoutedEventArgs e)
//{
// MessageBox.Show("הייתה לחיצה.");
//}
//int count = Convert.ToInt32(sqlCmd.ExecuteScalar());
//if ((count == 0 || count != s.UserID) && s.FirstName == "")
//{
// MessageBox.Show(".אין אנשים במערכת בעלי תעודת זהות כזו");
//}
//Console.WriteLine("------->" + count);
#endregion
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
sqlCon.Close();
}
return(dt);
}
