public UserLogin selectUserSP(string _username, string _password)
{
UserLogin aux = new UserLogin();
List <Parameter> parameters = new List <Parameter>();
parameters.Add(new Parameter {
name = "_username", value = _username
});
parameters.Add(new Parameter {
name = "_password", value = _password
});
try
{
MySqlDataReader reader = ExecuteSP.executeStoreProcedure("login", parameters);
while (reader.Read())
{
aux.username = reader["username_a"] + "";
aux.password = reader["password_a"] + "";
aux.typeUser = reader["typeUserID_fk"] + "";
aux.mySqlStatus = "ok";
}
return(aux);
}
catch (MySqlException e)
{
aux.username = "";
aux.password = "";
aux.typeUser = "";
aux.mySqlStatus = e.ToString();
return(aux);
}
}
public bool updateServiceSP(element _id)
{
List <Parameter> parameters = new List <Parameter>();
parameters.Add(new Parameter {
name = "_id", value = _id.id
});
try
{
MySqlDataReader reader = ExecuteSP.executeStoreProcedure("updateService", parameters);
return(true);
}
catch (MySqlException e)
{
return(false);
}
}
public string addServiceSP(Service _service)
{
List <Parameter> parameters = new List <Parameter>();
parameters.Add(new Parameter {
name = "_clientID_fk", value = _service.clientID
});
parameters.Add(new Parameter {
name = "_adminID_fk", value = _service.adminID
});
parameters.Add(new Parameter {
name = "_userID_fk", value = _service.userID
});
parameters.Add(new Parameter {
name = "_description", value = _service.description
});
parameters.Add(new Parameter {
name = "_typeService_fk", value = _service.typeService
});
parameters.Add(new Parameter {
name = "_date", value = _service.date
});
parameters.Add(new Parameter {
name = "_status_fk", value = _service.status
});
try
{
MySqlDataReader r = ExecuteSP.executeStoreProcedure("AddService", parameters);
return("ok");
}
catch (MySqlException e)
{
return(e.Number.ToString());
}
}
