private void btnBack_Click(object sender, RoutedEventArgs e) { LogBookTask task = new LogBookTask(); task.Show(); this.Close(); }
//public void Roles() //{ // SqlConnection Connection = new SqlConnection(myCo); // try // { // Connection.Open(); // string Daily = "SELECT * FROM RoleTb"; // SqlCommand command = new SqlCommand(Daily, Connection); // SqlDataReader dr = command.ExecuteReader(); // while (dr.Read()) // { // // string Id = dr.GetString(0); // string Roles = dr.GetString(1); // // string FullName = Id + " " + Roles; // SignUpForm signup = new SignUpForm(); // signup.cmRoles.Items.Add(Roles); // } // } // catch (Exception ex) // { // MessageBox.Show(ex.Message); // } //} //public void Master(string date, int personId, string training) //{ // try // { // SqlConnection Connection = new SqlConnection(myCo); // Connection.Open(); // // string role = ""; // // string Query = "INSERT INTO AttendanceMasterTb (Date, PersonId, Training) Values('" + date + "', '" + personId + "','" + training + "')join INSERT INTO AttendanceDetailsTb(PersonId, Hours)VALUES ('" + personId2 + "', '" + hours + "')"; // string Query = "SELECT * FROM PersonTb WHERE RoleId = '1'; INSERT INTO AttendanceMasterTb( Date, AttendanceMasterTb.PersonId, Training) Values('" + date + "', '" + personId + "', '" + training + "')"; // SqlCommand command = new SqlCommand(Query, Connection); // command.ExecuteNonQuery(); // MessageBox.Show("Saved"); // Connection.Close(); // // DailyRegister daily = new DailyRegister(); // // daily.Show(); // } // catch (Exception ex) // { // MessageBox.Show(ex.Message); // } //} //public void details(int personId, string hours) //{ // try // { // SqlConnection Connection = new SqlConnection(myCo); // Connection.Open(); // string Query = "SELECT * FROM PersonTb WHERE RoleId = '3'; INSERT INTO AttendanceDetailsTb (AttendanceDetailsTb.PersonId, Hours, MasterId) Values('" + personId + "', '" + hours + "', @MasterId ) "; // SqlCommand command = new SqlCommand(Query, Connection); // command.ExecuteNonQuery(); // MessageBox.Show("Saved"); // Connection.Close(); // // DailyRegister daily = new DailyRegister(); // // daily.Show(); // } // catch (Exception ex) // { // MessageBox.Show(ex.Message); // } //} public string LoginMentors(string username, string password) { SqlConnection myConnection = new SqlConnection(myCo); myConnection.Open(); try { string query = "SELECT * FROM PersonTb WHERE Username = '******' AND Password = '******' AND RoleId = '1'"; SqlCommand command = new SqlCommand(query, myConnection); command.ExecuteNonQuery(); //myConnection.Close(); SqlDataReader dr = command.ExecuteReader(); int count = 0; while (dr.Read()) { count++; } if (count == 1) { Message = "Successfully login"; MessageBox.Show(Message); LogBookTask task = new LogBookTask(); task.Show(); } if (count > 1) { Message = "duplicated"; MessageBox.Show(Message); } if (count < 1) { Message = "Only Mentors and Manager are allowed to login for daily register"; MessageBox.Show(Message); } } catch (Exception ex) { MessageBox.Show(ex.Message); } myConnection.Close(); return(Message); }
public void Signup(string Surname, string Names, string Gender, string EmailAddress, string Username, string Password, int RoleId) { try { SqlConnection Connection = new SqlConnection(myCo); Connection.Open(); // string role = ""; string Query = "INSERT INTO PersonTb (Surname, Names, Gender, EmailAddress, Username, Password, RoleId) VALUES ('" + Surname + "', '" + Names + "', '" + Gender + "', '" + EmailAddress + "', '" + Username + "', '" + Password + "', '" + RoleId + "' )"; SqlCommand command = new SqlCommand(Query, Connection); command.ExecuteNonQuery(); MessageBox.Show("Saved"); Connection.Close(); LogBookTask task = new LogBookTask(); task.Show(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }