//DAL.onLocal();
// MySqlParameter[] param = new MySqlParameter[1];
//param[0] = new MySqlParameter("@idCar", int.Parse(idCar));
//DataTable data = DAL.SelectData("Call CarDetailsByIdCar(@idCar);", param);
public DataTable user_profileInsertUpdate(UserProfile_Model userProfile)
{
DataTable dt = new DataTable();
DAL2.onOnLine();
MySqlParameter[] param = new MySqlParameter[7];
param[0] = new MySqlParameter("@id", userProfile.id);
param[1] = new MySqlParameter("@username", userProfile.username);
param[2] = new MySqlParameter("@password", userProfile.password);
param[3] = new MySqlParameter("@roleUser", userProfile.roleUser);
param[4] = new MySqlParameter("@stateUser", userProfile.stateUser);
param[5] = new MySqlParameter("@dateValidate", userProfile.dateValidate);
param[6] = new MySqlParameter("@uuid", userProfile.uuid);
dt = DAL2.SelectData("CALL user_profileInsertUpdate( @id, @username,@password,@roleUser, @stateUser, @dateValidate, @uuid);", param);
return(dt);
}