public ModelEmployee Login(String SerialNumber, String Password) { var employee = new ModelEmployee(); var daoEmployee = new DaoEmployee(); foreach (DataRow row in daoEmployee.Login(SerialNumber, Password).Rows) { employee.Name = Convert.ToString(row["Name"]); employee.Departament = Convert.ToString(row["Departament"]); employee.SeriaNumber = Convert.ToString(row["SerialNumber"]); employee.IsTecnic = Convert.ToInt32(row["IsTecnic"]); } return(employee); }
public void AlterEmployee(ModelEmployee modelEmployee) { try { using (SqlConnection connection = new SqlConnection(sqlConnection())) { string queryString = "UPDATE EMPLOYEE SET NAME = '" + modelEmployee.Name + "', DEPARTAMENT = '" + modelEmployee.Departament + "', SERIALNUMBER = '" + modelEmployee.SeriaNumber + "', ISTECNIC = '" + modelEmployee.IsTecnic + "', PASSWORD = '******' WHERE SERIALNUMBER = '" + modelEmployee.SeriaNumber + "'"; SqlCommand command = new SqlCommand(queryString, connection); command.Connection.Open(); command.ExecuteNonQuery(); } } catch (Exception ex) { } }
public void Save(ModelEmployee modelEmployee) { try { using (SqlConnection connection = new SqlConnection(sqlConnection())) { string queryString = "INSERT INTO EMPLOYEE(NAME, DEPARTAMENT, SERIALNUMBER, ISTECNIC, PASSWORD) VALUES('" + modelEmployee.Name + "','" + modelEmployee.Departament + "','" + modelEmployee.SeriaNumber + "','" + modelEmployee.IsTecnic + "','" + modelEmployee.Password + "')"; SqlCommand command = new SqlCommand(queryString, connection); command.Connection.Open(); command.ExecuteNonQuery(); } } catch (Exception ex) { } }
public List <ModelEmployee> ListEmployee() { var lista = new List <ModelEmployee>(); var daoEmployee = new DaoEmployee(); foreach (DataRow row in daoEmployee.List().Rows) { var employee = new ModelEmployee(); employee.Name = Convert.ToString(row["Name"]); employee.Departament = Convert.ToString(row["Departament"]); employee.SeriaNumber = Convert.ToString(row["SerialNumber"]); employee.IsTecnic = Convert.ToInt32(row["IsTecnic"]); lista.Add(employee); } return(lista); }