public systemUsers checkSystemUser(string userName, string password) { systemUsers systemUserData = new systemUsers(); if (string.IsNullOrEmpty(userName) || string.IsNullOrEmpty(password)) { return(null); } using (systemUserDatabaseLogicLayer systemUserDatabase = new systemUserDatabaseLogicLayer()) { SqlDataReader reader = systemUserDatabase.checkSystemUser(new systemUsers() { userName = userName, password = password }); while (reader.Read()) { systemUserData.id = reader.IsDBNull(0) ? Guid.Empty : reader.GetGuid(0); systemUserData.userName = reader.IsDBNull(1) ? string.Empty : reader.GetString(1); systemUserData.password = reader.IsDBNull(2) ? string.Empty : reader.GetString(2); } reader.Close(); systemUserDatabase.connectionWizard(); } return(systemUserData); }
public SqlDataReader checkSystemUser(systemUsers data) { command = new System.Data.SqlClient.SqlCommand("checkSystemUser", connection); command.CommandType = System.Data.CommandType.StoredProcedure; command.Parameters.Add("@userName", SqlDbType.NVarChar).Value = data.userName; command.Parameters.Add("@passwords", SqlDbType.NVarChar).Value = data.password; connectionWizard(); return(command.ExecuteReader()); }
private void btnControl_Click(object sender, EventArgs e) { systemUserService userService = new systemUserService(); systemUsers systemUserData = userService.checkSystemUser(txtUserName.Text, txtPassword.Text); if (systemUserData == null || systemUserData.id == Guid.Empty) { MessageBox.Show("Girmiş olduğunuz bilgiler hatalı", "Bilgilendirme", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { applicationStatics.currentSystemUser = systemUserData; mainForm main = new mainForm(); main.Show(); this.Hide(); } }